IN SELECT MAX(dtaccountl) as fin_mois FROM tm_balance b WHERE b.dtaccountl BETWEEN '2010-09-07' AND '2010-09-07' AND b.dtaccountl >= '2006-12-01' AND 1 AND (((id_compte BETWEEN '508TI00085004000EUR' AND '508TI00085004500EUR') OR (id_compte BETWEEN '508TI00085012500EUR' AND '508TI00085012999EUR'))) AND id_compte NOT LIKE 'VIRT%'GROUP BY DATE_FORMAT(dtaccountl, '%m/%y')ORDER BY dtaccountl