select c.id, c.idTipo, c.titolopt as Titolo, c.sottotitolopt as sottoTitolo, c.testopt as Testo, c.titolo2pt as Titolo2, c.testo2pt as Testo2, c.titolo3pt as Titolo3, c.testo3pt as Testo3, c.pdf1pt as pdf1, c.pdflabel1pt as pdflabel1, c.pdf2pt as pdf2, c.pdflabel2pt as pdflabel2, c.pdf3pt as pdf3, c.pdflabel3pt as pdflabel3, c.pdf4pt as pdf4, c.pdflabel4pt as pdflabel4, c.linkpt as link, c.linklabelpt as linklabel, c.videopt as video, c.data, c.riservata, PageCat.tipopt as TipoCat, c.idcat, c.ordine,f.zoom, c.metatitolopt as metatitolo, c.metadescpt as metadesc, c.metakeypt as metakey, p.Tipopt as TipoPage, p.url as UrlPage, p.imgBackGround, p.zoompage, p.sottotitolopt as sottotitoloPage, p.descrizionept as TestoPage, p.metatitolopt as metatitoloPage, p.metadescpt as metadescPage, p.metakeypt 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.titolopt