PAGINA NON CONFIGURATA
  • |

SELECT WP.id_pagina AS id, URW.id AS idUrw, CASE WHEN MU.nome_in_link != '' THEN MU.nome_in_link ELSE WP.nome_in_link END AS nome_in_link, URW.nome_in_link AS link_urw FROM SweetFox4site.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.lingua_id = (SELECT id_lingua FROM SweetFox4site.lingua WHERE valore='it') AND URW.attivo = 1 AND URW.online = 1 LEFT OUTER JOIN SweetFox4site.multilingua MU ON WP.id_pagina = MU.record AND MU.tabella = 'wsp_pagina' AND MU.lingua = (SELECT id_lingua FROM SweetFox4site.lingua WHERE valore='it') WHERE WP.wsp_sito=38 AND WP.online=1 AND WP.commessa_id= AND WP.WS=0 AND WP.esito_ricerca=1 ORDER BY URW.id

Ricerca
loading...