SELECT P.*, PL.* FROM parks.pun P JOIN parks.pun_lingua PL ON (P.id_pun=PL.id_pun AND PL.id_lingua='it') JOIN parks.pun_ap PA ON (P.id_pun=PA.id_pun) WHERE P.id_pun='1519' AND P.se_attivo=1 AND PA.id_ap='PRMIN' ORDER BY P.ordinamento, P.id_pun