SELECT M.* FROM parks.manif_piccole M JOIN manif_tags_associazioni MTA ON (M.id=MTA.id_man_pic) WHERE M.codiceAP IN ("PRDPE", "SISIC", "SISTR", "S0116", "S0115") AND M.validato = '1' AND M.data_al >= '2024-04-18' AND MTA.id_tag = '1' AND M.data_dal >= '2024-04-18' ORDER BY data_dal ASC, data_al ASC LIMIT -20, 20