: 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 = 1  AND ( (`STATUS` = 'Active' OR `STATUS` = 'Hold')  )  AND ( MANUFACTURER LIKE '%Oyster%' OR MODEL_NAME LIKE '%Oyster%' OR INVENTORY_NUM LIKE '%Oyster%' OR MOVEMENT_COMMENT LIKE '%Oyster%' OR MOVEMENT LIKE '%Oyster%' OR MODEL_NUM LIKE '%Oyster%' OR CONDITION LIKE '%Oyster%' OR GENDER LIKE '%Oyster%' OR _CASE_ LIKE '%Oyster%' OR BRACELET LIKE '%Oyster%' OR DIAL LIKE '%Oyster%' OR STRAP LIKE '%Oyster%' OR COMMENT LIKE '%Oyster%' OR stock_notes LIKE '%Oyster%' OR HIDDEN LIKE '%Oyster%') AND ( MANUFACTURER LIKE '%Perpetual%' OR MODEL_NAME LIKE '%Perpetual%' OR INVENTORY_NUM LIKE '%Perpetual%' OR MOVEMENT_COMMENT LIKE '%Perpetual%' OR MOVEMENT LIKE '%Perpetual%' OR MODEL_NUM LIKE '%Perpetual%' OR CONDITION LIKE '%Perpetual%' OR GENDER LIKE '%Perpetual%' OR _CASE_ LIKE '%Perpetual%' OR BRACELET LIKE '%Perpetual%' OR DIAL LIKE '%Perpetual%' OR STRAP LIKE '%Perpetual%' OR COMMENT LIKE '%Perpetual%' OR stock_notes LIKE '%Perpetual%' OR HIDDEN LIKE '%Perpetual%') AND (MANUFACTURER NOT LIKE '%Date%' AND MODEL_NAME NOT LIKE '%Date%' AND INVENTORY_NUM NOT LIKE '%Date%' AND MOVEMENT_COMMENT NOT LIKE '%Date%' AND MOVEMENT NOT LIKE '%Date%' AND MODEL_NUM NOT LIKE '%Date%' AND CONDITION NOT LIKE '%Date%' AND GENDER NOT LIKE '%Date%' AND _CASE_ NOT LIKE '%Date%' AND BRACELET NOT LIKE '%Date%' AND DIAL NOT LIKE '%Date%' AND STRAP NOT LIKE '%Date%' AND COMMENT NOT LIKE '%Date%' AND stock_notes NOT LIKE '%Date%' AND HIDDEN NOT LIKE '%Date%') AND (MANUFACTURER NOT LIKE '%Daytona%' AND MODEL_NAME NOT LIKE '%Daytona%' AND INVENTORY_NUM NOT LIKE '%Daytona%' AND MOVEMENT_COMMENT NOT LIKE '%Daytona%' AND MOVEMENT NOT LIKE '%Daytona%' AND MODEL_NUM NOT LIKE '%Daytona%' AND CONDITION NOT LIKE '%Daytona%' AND GENDER NOT LIKE '%Daytona%' AND _CASE_ NOT LIKE '%Daytona%' AND BRACELET NOT LIKE '%Daytona%' AND DIAL NOT LIKE '%Daytona%' AND STRAP NOT LIKE '%Daytona%' AND COMMENT NOT LIKE '%Daytona%' AND stock_notes NOT LIKE '%Daytona%' AND HIDDEN NOT LIKE '%Daytona%') AND (MANUFACTURER NOT LIKE '%Submariner%' AND MODEL_NAME NOT LIKE '%Submariner%' AND INVENTORY_NUM NOT LIKE '%Submariner%' AND MOVEMENT_COMMENT NOT LIKE '%Submariner%' AND MOVEMENT NOT LIKE '%Submariner%' AND MODEL_NUM NOT LIKE '%Submariner%' AND CONDITION NOT LIKE '%Submariner%' AND GENDER NOT LIKE '%Submariner%' AND _CASE_ NOT LIKE '%Submariner%' AND BRACELET NOT LIKE '%Submariner%' AND DIAL NOT LIKE '%Submariner%' AND STRAP NOT LIKE '%Submariner%' AND COMMENT NOT LIKE '%Submariner%' AND stock_notes NOT LIKE '%Submariner%' AND HIDDEN NOT LIKE '%Submariner%') AND (MANUFACTURER NOT LIKE '%Turn-O-Graph%' AND MODEL_NAME NOT LIKE '%Turn-O-Graph%' AND INVENTORY_NUM NOT LIKE '%Turn-O-Graph%' AND MOVEMENT_COMMENT NOT LIKE '%Turn-O-Graph%' AND MOVEMENT NOT LIKE '%Turn-O-Graph%' AND MODEL_NUM NOT LIKE '%Turn-O-Graph%' AND CONDITION NOT LIKE '%Turn-O-Graph%' AND GENDER NOT LIKE '%Turn-O-Graph%' AND _CASE_ NOT LIKE '%Turn-O-Graph%' AND BRACELET NOT LIKE '%Turn-O-Graph%' AND DIAL NOT LIKE '%Turn-O-Graph%' AND STRAP NOT LIKE '%Turn-O-Graph%' AND COMMENT NOT LIKE '%Turn-O-Graph%' AND stock_notes NOT LIKE '%Turn-O-Graph%' AND HIDDEN NOT LIKE '%Turn-O-Graph%') AND (MANUFACTURER NOT LIKE '%Masterpiece%' AND MODEL_NAME NOT LIKE '%Masterpiece%' AND INVENTORY_NUM NOT LIKE '%Masterpiece%' AND MOVEMENT_COMMENT NOT LIKE '%Masterpiece%' AND MOVEMENT NOT LIKE '%Masterpiece%' AND MODEL_NUM NOT LIKE '%Masterpiece%' AND CONDITION NOT LIKE '%Masterpiece%' AND GENDER NOT LIKE '%Masterpiece%' AND _CASE_ NOT LIKE '%Masterpiece%' AND BRACELET NOT LIKE '%Masterpiece%' AND DIAL NOT LIKE '%Masterpiece%' AND STRAP NOT LIKE '%Masterpiece%' AND COMMENT NOT LIKE '%Masterpiece%' AND stock_notes NOT LIKE '%Masterpiece%' AND HIDDEN NOT LIKE '%Masterpiece%') AND (MANUFACTURER NOT LIKE '%President%' AND MODEL_NAME NOT LIKE '%President%' AND INVENTORY_NUM NOT LIKE '%President%' AND MOVEMENT_COMMENT NOT LIKE '%President%' AND MOVEMENT NOT LIKE '%President%' AND MODEL_NUM NOT LIKE '%President%' AND CONDITION NOT LIKE '%President%' AND GENDER NOT LIKE '%President%' AND _CASE_ NOT LIKE '%President%' AND BRACELET NOT LIKE '%President%' AND DIAL NOT LIKE '%President%' AND STRAP NOT LIKE '%President%' AND COMMENT NOT LIKE '%President%' AND stock_notes NOT LIKE '%President%' AND HIDDEN NOT LIKE '%President%'))  ORDER BY W.CREATED DESC LIMIT 0, 48