: 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')   )  AND (( MANUFACTURER LIKE '%Chronograph%' OR MODEL_NAME LIKE '%Chronograph%' OR INVENTORY_NUM LIKE '%Chronograph%' OR MOVEMENT_COMMENT LIKE '%Chronograph%' OR MOVEMENT LIKE '%Chronograph%' OR MODEL_NUM LIKE '%Chronograph%' OR CONDITION LIKE '%Chronograph%' OR GENDER LIKE '%Chronograph%' OR _CASE_ LIKE '%Chronograph%' OR BRACELET LIKE '%Chronograph%' OR DIAL LIKE '%Chronograph%' OR STRAP LIKE '%Chronograph%' OR COMMENT LIKE '%Chronograph%' OR stock_notes LIKE '%Chronograph%' OR HIDDEN LIKE '%Chronograph%') OR ( 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 '%Tourbill%' OR MODEL_NAME LIKE '%Tourbill%' OR INVENTORY_NUM LIKE '%Tourbill%' OR MOVEMENT_COMMENT LIKE '%Tourbill%' OR MOVEMENT LIKE '%Tourbill%' OR MODEL_NUM LIKE '%Tourbill%' OR CONDITION LIKE '%Tourbill%' OR GENDER LIKE '%Tourbill%' OR _CASE_ LIKE '%Tourbill%' OR BRACELET LIKE '%Tourbill%' OR DIAL LIKE '%Tourbill%' OR STRAP LIKE '%Tourbill%' OR COMMENT LIKE '%Tourbill%' OR stock_notes LIKE '%Tourbill%' OR HIDDEN LIKE '%Tourbill%') 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%') OR ( MANUFACTURER LIKE '%Calendar%' OR MODEL_NAME LIKE '%Calendar%' OR INVENTORY_NUM LIKE '%Calendar%' OR MOVEMENT_COMMENT LIKE '%Calendar%' OR MOVEMENT LIKE '%Calendar%' OR MODEL_NUM LIKE '%Calendar%' OR CONDITION LIKE '%Calendar%' OR GENDER LIKE '%Calendar%' OR _CASE_ LIKE '%Calendar%' OR BRACELET LIKE '%Calendar%' OR DIAL LIKE '%Calendar%' OR STRAP LIKE '%Calendar%' OR COMMENT LIKE '%Calendar%' OR stock_notes LIKE '%Calendar%' OR HIDDEN LIKE '%Calendar%') OR ( MANUFACTURER LIKE '%Power%' OR MODEL_NAME LIKE '%Power%' OR INVENTORY_NUM LIKE '%Power%' OR MOVEMENT_COMMENT LIKE '%Power%' OR MOVEMENT LIKE '%Power%' OR MODEL_NUM LIKE '%Power%' OR CONDITION LIKE '%Power%' OR GENDER LIKE '%Power%' OR _CASE_ LIKE '%Power%' OR BRACELET LIKE '%Power%' OR DIAL LIKE '%Power%' OR STRAP LIKE '%Power%' OR COMMENT LIKE '%Power%' OR stock_notes LIKE '%Power%' OR HIDDEN LIKE '%Power%') 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%') OR ( MANUFACTURER LIKE '%Dual%' OR MODEL_NAME LIKE '%Dual%' OR INVENTORY_NUM LIKE '%Dual%' OR MOVEMENT_COMMENT LIKE '%Dual%' OR MOVEMENT LIKE '%Dual%' OR MODEL_NUM LIKE '%Dual%' OR CONDITION LIKE '%Dual%' OR GENDER LIKE '%Dual%' OR _CASE_ LIKE '%Dual%' OR BRACELET LIKE '%Dual%' OR DIAL LIKE '%Dual%' OR STRAP LIKE '%Dual%' OR COMMENT LIKE '%Dual%' OR stock_notes LIKE '%Dual%' OR HIDDEN LIKE '%Dual%') OR ( MANUFACTURER LIKE '%World%' OR MODEL_NAME LIKE '%World%' OR INVENTORY_NUM LIKE '%World%' OR MOVEMENT_COMMENT LIKE '%World%' OR MOVEMENT LIKE '%World%' OR MODEL_NUM LIKE '%World%' OR CONDITION LIKE '%World%' OR GENDER LIKE '%World%' OR _CASE_ LIKE '%World%' OR BRACELET LIKE '%World%' OR DIAL LIKE '%World%' OR STRAP LIKE '%World%' OR COMMENT LIKE '%World%' OR stock_notes LIKE '%World%' OR HIDDEN LIKE '%World%') OR ( MANUFACTURER LIKE '%Repeater%' OR MODEL_NAME LIKE '%Repeater%' OR INVENTORY_NUM LIKE '%Repeater%' OR MOVEMENT_COMMENT LIKE '%Repeater%' OR MOVEMENT LIKE '%Repeater%' OR MODEL_NUM LIKE '%Repeater%' OR CONDITION LIKE '%Repeater%' OR GENDER LIKE '%Repeater%' OR _CASE_ LIKE '%Repeater%' OR BRACELET LIKE '%Repeater%' OR DIAL LIKE '%Repeater%' OR STRAP LIKE '%Repeater%' OR COMMENT LIKE '%Repeater%' OR stock_notes LIKE '%Repeater%' OR HIDDEN LIKE '%Repeater%') OR ( MANUFACTURER LIKE '%Jump%' OR MODEL_NAME LIKE '%Jump%' OR INVENTORY_NUM LIKE '%Jump%' OR MOVEMENT_COMMENT LIKE '%Jump%' OR MOVEMENT LIKE '%Jump%' OR MODEL_NUM LIKE '%Jump%' OR CONDITION LIKE '%Jump%' OR GENDER LIKE '%Jump%' OR _CASE_ LIKE '%Jump%' OR BRACELET LIKE '%Jump%' OR DIAL LIKE '%Jump%' OR STRAP LIKE '%Jump%' OR COMMENT LIKE '%Jump%' OR stock_notes LIKE '%Jump%' OR HIDDEN LIKE '%Jump%')) )  ORDER BY W.CREATED DESC LIMIT 0, 48