select c.id, c.idTipo, c.titolofr as Titolo, c.sottotitolofr as sottoTitolo, c.testofr as Testo, c.titolo2fr as Titolo2, c.testo2fr as Testo2, c.titolo3fr as Titolo3, c.testo3fr as Testo3, c.pdf1fr as pdf1, c.pdflabel1fr as pdflabel1, c.pdf2fr as pdf2, c.pdflabel2fr as pdflabel2, c.pdf3fr as pdf3, c.pdflabel3fr as pdflabel3, c.pdf4fr as pdf4, c.pdflabel4fr as pdflabel4, c.linkfr as link, c.linklabelfr as linklabel, c.videofr as video, c.data, c.riservata, PageCat.tipofr as TipoCat, c.idcat, c.ordine,f.zoom, c.metatitolofr as metatitolo, c.metadescfr as metadesc, c.metakeyfr as metakey, p.Tipofr as TipoPage, p.url as UrlPage, p.imgBackGround, p.zoompage, p.sottotitolofr as sottotitoloPage, p.descrizionefr as TestoPage, p.metatitolofr as metatitoloPage, p.metadescfr as metadescPage, p.metakeyfr 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.titolofr