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