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
|