SELECT distinct M.*, D.moduloINFO, D.parcobreve
						FROM parks.manif_piccole M
						JOIN parks.dbparks D ON (M.codiceAP=D.codiceAP)
						JOIN parks.province P ON (SUBSTR(M.provincia,1,2)=P.id)
						JOIN parks.regioni R ON (P.id_regione=R.id)
						LEFT OUTER JOIN parks.province P1 ON (SUBSTR(M.provincia,4,2)=P1.id)
						LEFT OUTER JOIN parks.regioni R1 ON (P1.id_regione=R1.id)
						LEFT OUTER JOIN parks.province P2 ON (SUBSTR(M.provincia,7,2)=P2.id)
						LEFT OUTER JOIN parks.regioni R2 ON (P2.id_regione=R2.id) WHERE D.codiceAP IN ("PNGPA", "PRAMT") AND M.validato = '1' AND M.data_al >= '2012-06-13'  AND (R.reg LIKE '%Piemonte%' OR R1.reg LIKE '%Piemonte%' OR R2.reg LIKE '%Piemonte%')AND M.data_dal >= '2012-06-13' ORDER BY data_dal ASC, data_al ASC LIMIT -20, 20