string(1172) " 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 && ( categories_id IN(1941,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2413,2414,2420,2419,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2450,2470)) && manufacturers_id IN(1411) 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"