_my_wheres.append("%s.date_fin < DATE(NOW())" % m)
if s == "active":
_my_wheres.append(
- "%s.supprime = False AND ("
"((%s.`date_debut` <= DATE(NOW()) OR %s.`date_debut` IS NULL) AND %s.`date_fin` >= DATE(NOW())) OR "
"((%s.`date_fin` >= DATE(NOW()) OR %s.`date_fin` IS NULL) AND %s.`date_debut` <= DATE(NOW())) OR "
- "(%s.`date_debut` <= DATE(NOW()) AND %s.`date_fin` >= DATE(NOW())))"
- % (m, m, m, m, m, m, m, m, m))
+ "(%s.`date_debut` <= DATE(NOW()) AND %s.`date_fin` >= DATE(NOW()))"
+ % (m, m, m, m, m, m, m, m))
if s == "futur":
_my_wheres.append("%s.date_debut > DATE(NOW())" % m)
if s == "unknown":