SELECT a.ident as aident,a.nom as anom,a.acces as aacces,u.prenom as uprenom,u.nom as unom FROM rvs_actus as a left join rvs_users as u on u.ident=a.user WHERE (a.ddd like '2028-03%' or a.ddf like '2028-03%' or (a.ddd<='2028-03%' and a.ddf>='2028-03%')) and a.onair='1' ORDER BY a.ddd,a.nom