string(1055) " 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 '(BEST SELLER|CLEARANCE|EXLUSIVITY|FAVOURITE|FREE COVER|LOWEST PRICE|NEW PRODUCT|TIP)', '6666-66-66 66:66:66', products_date_added ) ) as MD FROM `woodbrass_com_-_OsCommerce`.search_engine_en WHERE products_id IN (SELECT products_id FROM `woodbrass_com_-_OsCommerce`.products ) AND (match(products_search) against ('+h4n* +zoom* ' IN BOOLEAN MODE)) && manufacturers_id IN(695) 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"