: 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 (`STATUS` = 'Active' OR `STATUS` = 'Hold')  AND (( MANUFACTURER LIKE '%audemars%' OR MODEL_NAME LIKE '%audemars%' OR INVENTORY_NUM LIKE '%audemars%' OR MOVEMENT_COMMENT LIKE '%audemars%' OR MOVEMENT LIKE '%audemars%' OR MODEL_NUM LIKE '%audemars%' OR CONDITION LIKE '%audemars%' OR GENDER LIKE '%audemars%' OR _CASE_ LIKE '%audemars%' OR BRACELET LIKE '%audemars%' OR DIAL LIKE '%audemars%' OR STRAP LIKE '%audemars%' OR COMMENT LIKE '%audemars%' OR stock_notes LIKE '%audemars%' OR HIDDEN LIKE '%audemars%') AND ( MANUFACTURER LIKE '%piguet%' OR MODEL_NAME LIKE '%piguet%' OR INVENTORY_NUM LIKE '%piguet%' OR MOVEMENT_COMMENT LIKE '%piguet%' OR MOVEMENT LIKE '%piguet%' OR MODEL_NUM LIKE '%piguet%' OR CONDITION LIKE '%piguet%' OR GENDER LIKE '%piguet%' OR _CASE_ LIKE '%piguet%' OR BRACELET LIKE '%piguet%' OR DIAL LIKE '%piguet%' OR STRAP LIKE '%piguet%' OR COMMENT LIKE '%piguet%' OR stock_notes LIKE '%piguet%' OR HIDDEN LIKE '%piguet%') AND ( MANUFACTURER LIKE '%tourbillon%' OR MODEL_NAME LIKE '%tourbillon%' OR INVENTORY_NUM LIKE '%tourbillon%' OR MOVEMENT_COMMENT LIKE '%tourbillon%' OR MOVEMENT LIKE '%tourbillon%' OR MODEL_NUM LIKE '%tourbillon%' OR CONDITION LIKE '%tourbillon%' OR GENDER LIKE '%tourbillon%' OR _CASE_ LIKE '%tourbillon%' OR BRACELET LIKE '%tourbillon%' OR DIAL LIKE '%tourbillon%' OR STRAP LIKE '%tourbillon%' OR COMMENT LIKE '%tourbillon%' OR stock_notes LIKE '%tourbillon%' OR HIDDEN LIKE '%tourbillon%')))  ORDER BY W.CREATED DESC LIMIT 0, 48