select c.id, c.idTipo, c.titoloit as Titolo, c.sottotitoloit as sottoTitolo, c.testoit as Testo, c.titolo2it as Titolo2, c.testo2it as Testo2, c.titolo3it as Titolo3, c.testo3it as Testo3, c.pdf1it as pdf1, c.pdflabel1it as pdflabel1, c.pdf2it as pdf2, c.pdflabel2it as pdflabel2, c.pdf3it as pdf3, c.pdflabel3it as pdflabel3, c.pdf4it as pdf4, c.pdflabel4it as pdflabel4, c.linkit as link, c.linklabelit as linklabel, c.videoit as video, c.data, c.riservata, PageCat.tipoit as TipoCat, c.idcat, c.ordine,f.zoom, c.metatitoloit as metatitolo, c.metadescit as metadesc, c.metakeyit as metakey, p.Tipoit as TipoPage, p.url as UrlPage, p.imgBackGround, p.zoompage, p.sottotitoloit as sottotitoloPage, p.descrizioneit as TestoPage, p.metatitoloit as metatitoloPage, p.metadescit as metadescPage, p.metakeyit 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.titoloit