debug message:
SELECT
URW1.id,
URW1.get_corrispondente,
URW1.nome_in_link
FROM
SweetFox4site.url_rewrite URW
JOIN
SweetFox4site.url_rewrite URW1
ON URW.url_rewrite_id = URW1.id
WHERE
URW.wsp_sito_id=109
AND URW.nome_in_link = '/about-us/press/7-virtual-jazz-club���s-contest-7th-edition-winners-announced/'
AND (URW.data_fine_validita = '0000-00-00 00:00:00' OR URW.data_fine_validita IS NULL)
AND URW.url_rewrite_id > 0
Global Online Competition for Jazz Musicians - 9th Edition | 7 Virtual Jazz Club
