string(1042) " 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 '(AUSVERKAUF|BESTVERKAUF|EXLUSIVITAT|GRATIS HÜLLE|NEUHEITEN|NIEDRIGSTE PREIS|UNSER FAVORIT|UNSER TIPP)', '6666-66-66 66:66:66', products_date_added ) ) as MD FROM `woodbrass_com_-_OsCommerce`.search_engine_de WHERE products_id IN (SELECT products_id FROM `woodbrass_com_-_OsCommerce`.products ) AND (match(products_search) against ('+huelle* ' IN BOOLEAN MODE)) 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"