select distinct lieux.ID,annonce.ville from annonce inner join lieux on lieux.Nom = annonce.ville WHERE 1 AND ( `idag` = '1' OR `idag` = '474' OR `idag` = '245' OR `idag` = '232' OR `idag` = '83' OR `idag` = '509' OR `idag` = '15' OR `idag` = '457' OR `idag` = '288' OR `idag` = '175' OR `idag` = '60' OR `idag` = '210' OR `idag` = '357' OR `idag` = '281' OR `idag` = '144' OR `idag` = '233' OR `idag` = '226' OR `idag` = '574' OR `idag` = '596' OR `idag` = '291' OR `idag` = '316' OR `idag` = '440' OR `idag` = '342' OR `idag` = '379' OR `idag` = '598' OR `idag` = '599' OR `idag` = '601' OR `idag` = '604' OR `idag` = '606' OR `idag` = '607' OR `idag` = '424' OR `idag` = '427' OR `idag` = '597' OR `idag` = '605' OR `idag` = '511' OR `idag` = '513' OR `idag` = '522' OR `idag` = '525' OR `idag` = '527' OR `idag` = '529' OR `idag` = '577' OR `idag` = '595' OR `idag` = '608' OR `idag` = '609' OR `idag` = '610' OR `idag` = '611' OR `idag` = '618' OR `idag` = '617' OR `idag` = '632' OR `idag` = '621' OR `idag` = '624' OR `idag` = '629' OR `idag` = '630' OR `idag` = '631' OR `idag` = '633' OR `idag` = '634' OR `idag` = '635' OR `idag` = '636' OR `idag` = '637' OR `idag` = '625' OR `idag` = '626' OR `idag` = '627' OR `idag` = '638' OR `idag` = '639') AND annonce.date > '2023-11-13' ORDER by ville ASC
