SELECT WP.id_pagina AS pagina, CASE WHEN MU.nome_in_menu != '' THEN MU.nome_in_menu ELSE WP.nome_in_menu END AS nome_in_menu, URW.nome_in_link FROM wsp_pagina WP LEFT OUTER JOIN SweetFox4site.url_rewrite URW ON WP.id_pagina = URW.record AND URW.dbs = 'SweetFox4site' AND URW.tabella = 'wsp_pagina' AND URW.attivo = 1 AND URW.online = 1 AND URW.lingua_id = (SELECT id_lingua FROM lingua WHERE valore='uk') LEFT OUTER JOIN SweetFox4site.multilingua MU ON WP.id_pagina = MU.record AND MU.tabella = 'wsp_pagina' AND MU.lingua = WHERE WP.wsp_sito = 38 AND WP.online = 1 AND WP.home_page = 1 AND WP.commessa_id=0![]() |
![]() |