string(1996) " 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(5005,61,1770,5830,6099,6100,6160,73,202,6103,6104,249,264,194,206,3334,3335,3336,207,208,209,212,3399,3400,214,3402,3403,3404,3527,3528,3483,6105,6107,9269,3432,3433,9302,9303,9304,3434,9301,9308,9307,1601,185,3481,6106,2607,2608,2609,2610,2611,2612,3326,3330,3485,6072,9284,219,1835,3337,3338,6071,6163,9313,9314,9315,9323,9286,186,2538,2539,2540,2544,3386,2541,2545,3383,3384,3385,3389,9309,9310,9311,3317,3379,3381,3382,3480,9312,6157,3387,3388,1602,3320,6076,9290,9291,1614,5831,6101,6102,5832,6161,2537,3415,3416,183,257,262,3417,6085,3482,3517,3518,3519,3520,3521,3522,2601,8529,1769,1773,9318,8531,250,1500,210,3368,3369,3370,3371,219,220,3353,3479,223,265,3358,3359,3360,3361,3362,3363,255,2590,3339,218,3346,3347,3348,3349,9158,3340,3350,3351,9151,9356,3341,222,3352,9152,3342,221,2588,9153,3343,3299,3364,3365,3366,3367,3344,2589,3380,8537,3345,3372,3373,3374,3375,3376,3377,8570,8537,8571,9250,9154,9155,9156,3354,3355,3356,3357,1771,1772,1780,2587,9306,9319,9298)) && manufacturers_id IN(881) 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"