select c.id, c.idTipo, c.titolode as Titolo, c.sottotitolode as sottoTitolo, c.testode as Testo, c.titolo2de as Titolo2, c.testo2de as Testo2, c.titolo3de as Titolo3, c.testo3de as Testo3, c.pdf1de as pdf1, c.pdflabel1de as pdflabel1, c.pdf2de as pdf2, c.pdflabel2de as pdflabel2, c.pdf3de as pdf3, c.pdflabel3de as pdflabel3, c.pdf4de as pdf4, c.pdflabel4de as pdflabel4, c.linkde as link, c.linklabelde as linklabel, c.videode as video, c.data, c.riservata, PageCat.tipode as TipoCat, c.idcat, c.ordine,f.zoom, c.metatitolode as metatitolo, c.metadescde as metadesc, c.metakeyde as metakey, p.Tipode as TipoPage, p.url as UrlPage, p.imgBackGround, p.zoompage, p.sottotitolode as sottotitoloPage, p.descrizionede as TestoPage, p.metatitolode as metatitoloPage, p.metadescde as metadescPage, p.metakeyde as metakeyPage from ((PageContenuti c inner join Page p on c.idTipo = p.id) left join (select idx, min(big) as zoom from pagefoto where ordine = 1 group by idx) f on f.idx = c.id) left join PageCat on c.idCat = PageCat.id where c.attivo = true and c.idtipo = 32 and c.ordine=2 order by c.ordine, c.titolode