select c.id, c.idTipo, c.titoloen as Titolo, c.sottotitoloen as sottoTitolo, c.testoen as Testo, c.titolo2en as Titolo2, c.testo2en as Testo2, c.titolo3en as Titolo3, c.testo3en as Testo3, c.pdf1en as pdf1, c.pdflabel1en as pdflabel1, c.pdf2en as pdf2, c.pdflabel2en as pdflabel2, c.pdf3en as pdf3, c.pdflabel3en as pdflabel3, c.pdf4en as pdf4, c.pdflabel4en as pdflabel4, c.linken as link, c.linklabelen as linklabel, c.videoen as video, c.data, c.riservata, PageCat.tipoen as TipoCat, c.idcat, c.ordine,f.zoom, c.metatitoloen as metatitolo, c.metadescen as metadesc, c.metakeyen as metakey, p.Tipoen as TipoPage, p.url as UrlPage, p.imgBackGround, p.zoompage, p.sottotitoloen as sottotitoloPage, p.descrizioneen as TestoPage, p.metatitoloen as metatitoloPage, p.metadescen as metadescPage, p.metakeyen 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.titoloen