select c.id, c.idTipo, c.titoloes as Titolo, c.sottotitoloes as sottoTitolo, c.testoes as Testo, c.titolo2es as Titolo2, c.testo2es as Testo2, c.titolo3es as Titolo3, c.testo3es as Testo3, c.pdf1es as pdf1, c.pdflabel1es as pdflabel1, c.pdf2es as pdf2, c.pdflabel2es as pdflabel2, c.pdf3es as pdf3, c.pdflabel3es as pdflabel3, c.pdf4es as pdf4, c.pdflabel4es as pdflabel4, c.linkes as link, c.linklabeles as linklabel, c.videoes as video, c.data, c.riservata, PageCat.tipoes as TipoCat, c.idcat, c.ordine,f.zoom, c.metatitoloes as metatitolo, c.metadesces as metadesc, c.metakeyes as metakey, p.Tipoes as TipoPage, p.url as UrlPage, p.imgBackGround, p.zoompage, p.sottotitoloes as sottotitoloPage, p.descrizionees as TestoPage, p.metatitoloes as metatitoloPage, p.metadesces as metadescPage, p.metakeyes 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.titoloes