: SELECT W.*,  IF((W.sale_start_date <= NOW() OR W.sale_start_date = '0000-00-00') AND (W.sale_end_date >= NOW() OR W.sale_end_date = '0000-00-00'), 1, 0) AS sale_active, (SELECT i.thumb_file FROM images i WHERE i.fk_product_id = W.WRIST_WATCH_ID AND i.image_type = 'Main' ORDER BY i.`id` DESC LIMIT 1) AS thumb_file FROM WRIST_WATCH W WHERE (W.`STATUS` = 'Active' OR W.`STATUS` = 'Hold') AND (1=1 AND 1=1 AND fk_manufacturer_id = 6  AND ( (`STATUS` = 'Active' OR `STATUS` = 'Hold')   )  AND (( MANUFACTURER LIKE '%Classique%' OR MODEL_NAME LIKE '%Classique%' OR INVENTORY_NUM LIKE '%Classique%' OR MOVEMENT_COMMENT LIKE '%Classique%' OR MOVEMENT LIKE '%Classique%' OR MODEL_NUM LIKE '%Classique%' OR CONDITION LIKE '%Classique%' OR GENDER LIKE '%Classique%' OR _CASE_ LIKE '%Classique%' OR BRACELET LIKE '%Classique%' OR DIAL LIKE '%Classique%' OR STRAP LIKE '%Classique%' OR COMMENT LIKE '%Classique%' OR stock_notes LIKE '%Classique%' OR HIDDEN LIKE '%Classique%') OR ( MANUFACTURER LIKE '%Reserve%' OR MODEL_NAME LIKE '%Reserve%' OR INVENTORY_NUM LIKE '%Reserve%' OR MOVEMENT_COMMENT LIKE '%Reserve%' OR MOVEMENT LIKE '%Reserve%' OR MODEL_NUM LIKE '%Reserve%' OR CONDITION LIKE '%Reserve%' OR GENDER LIKE '%Reserve%' OR _CASE_ LIKE '%Reserve%' OR BRACELET LIKE '%Reserve%' OR DIAL LIKE '%Reserve%' OR STRAP LIKE '%Reserve%' OR COMMENT LIKE '%Reserve%' OR stock_notes LIKE '%Reserve%' OR HIDDEN LIKE '%Reserve%'))  AND (MANUFACTURER NOT LIKE '%ladies%' AND MODEL_NAME NOT LIKE '%ladies%' AND INVENTORY_NUM NOT LIKE '%ladies%' AND MOVEMENT_COMMENT NOT LIKE '%ladies%' AND MOVEMENT NOT LIKE '%ladies%' AND MODEL_NUM NOT LIKE '%ladies%' AND CONDITION NOT LIKE '%ladies%' AND GENDER NOT LIKE '%ladies%' AND _CASE_ NOT LIKE '%ladies%' AND BRACELET NOT LIKE '%ladies%' AND DIAL NOT LIKE '%ladies%' AND STRAP NOT LIKE '%ladies%' AND COMMENT NOT LIKE '%ladies%' AND stock_notes NOT LIKE '%ladies%' AND HIDDEN NOT LIKE '%ladies%'))  ORDER BY W.CREATED DESC LIMIT 0, 48