SELECT * FROM kameleon left join kameleon_ordre on kameleon.id = kameleon_ordre.id_fiche and key_ordre like '' where kameleon.id = 16701 and langue LIKE 'en' and crit1 like '%-101-%' and CURRENT_DATE >= date_debut_diffusion and CURRENT_DATE < date_fin_diffusion order by date_debut_diffusion DESC, kameleon.id DESC