string(998) " SELECT products_id, categories_id, (products_quantity_web) AS instock, (products_quantity_web > 0) AS dispo, IF( products_date_added != '0000-00-00 00:00:00', products_date_added, IF ( products_search REGEXP '(BONPLAN|COUPDECOEUR|DESTOCKAGE|EXCLUSIVITE|HOUSSEOFFERTE|MEILLEUREVENTE|NOUVEAUTE|PRIXBAS)', '6666-66-66 66:66:66', products_date_added ) ) as MD FROM `woodbrass_com_-_OsCommerce`.search_engine_fr WHERE products_id IN (SELECT products_id FROM `woodbrass_com_-_OsCommerce`.products ) AND 1 && manufacturers_id IN(2432) GROUP BY products_id ORDER BY dispo DESC, FIELD(products_date_added, '2104-12-31 00:00:00','2103-12-31 00:00:00', '2102-12-31 00:00:00', '2101-12-31 00:00:00', '2100-12-31 00:00:00', '6666-66-66 66:66:66', '0000-00-00 00:00:00'), caht DESC"