: 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 '%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%') 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 '%Moonphase%' OR MODEL_NAME LIKE '%Moonphase%' OR INVENTORY_NUM LIKE '%Moonphase%' OR MOVEMENT_COMMENT LIKE '%Moonphase%' OR MOVEMENT LIKE '%Moonphase%' OR MODEL_NUM LIKE '%Moonphase%' OR CONDITION LIKE '%Moonphase%' OR GENDER LIKE '%Moonphase%' OR _CASE_ LIKE '%Moonphase%' OR BRACELET LIKE '%Moonphase%' OR DIAL LIKE '%Moonphase%' OR STRAP LIKE '%Moonphase%' OR COMMENT LIKE '%Moonphase%' OR stock_notes LIKE '%Moonphase%' OR HIDDEN LIKE '%Moonphase%') 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 '%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%') OR ( MANUFACTURER LIKE '%Equation%' OR MODEL_NAME LIKE '%Equation%' OR INVENTORY_NUM LIKE '%Equation%' OR MOVEMENT_COMMENT LIKE '%Equation%' OR MOVEMENT LIKE '%Equation%' OR MODEL_NUM LIKE '%Equation%' OR CONDITION LIKE '%Equation%' OR GENDER LIKE '%Equation%' OR _CASE_ LIKE '%Equation%' OR BRACELET LIKE '%Equation%' OR DIAL LIKE '%Equation%' OR STRAP LIKE '%Equation%' OR COMMENT LIKE '%Equation%' OR stock_notes LIKE '%Equation%' OR HIDDEN LIKE '%Equation%') OR ( 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 '%Rattrapante%' OR MODEL_NAME LIKE '%Rattrapante%' OR INVENTORY_NUM LIKE '%Rattrapante%' OR MOVEMENT_COMMENT LIKE '%Rattrapante%' OR MOVEMENT LIKE '%Rattrapante%' OR MODEL_NUM LIKE '%Rattrapante%' OR CONDITION LIKE '%Rattrapante%' OR GENDER LIKE '%Rattrapante%' OR _CASE_ LIKE '%Rattrapante%' OR BRACELET LIKE '%Rattrapante%' OR DIAL LIKE '%Rattrapante%' OR STRAP LIKE '%Rattrapante%' OR COMMENT LIKE '%Rattrapante%' OR stock_notes LIKE '%Rattrapante%' OR HIDDEN LIKE '%Rattrapante%') OR ( MANUFACTURER LIKE '%Alarm%' OR MODEL_NAME LIKE '%Alarm%' OR INVENTORY_NUM LIKE '%Alarm%' OR MOVEMENT_COMMENT LIKE '%Alarm%' OR MOVEMENT LIKE '%Alarm%' OR MODEL_NUM LIKE '%Alarm%' OR CONDITION LIKE '%Alarm%' OR GENDER LIKE '%Alarm%' OR _CASE_ LIKE '%Alarm%' OR BRACELET LIKE '%Alarm%' OR DIAL LIKE '%Alarm%' OR STRAP LIKE '%Alarm%' OR COMMENT LIKE '%Alarm%' OR stock_notes LIKE '%Alarm%' OR HIDDEN LIKE '%Alarm%') OR ( MANUFACTURER LIKE '%Midicale%' OR MODEL_NAME LIKE '%Midicale%' OR INVENTORY_NUM LIKE '%Midicale%' OR MOVEMENT_COMMENT LIKE '%Midicale%' OR MOVEMENT LIKE '%Midicale%' OR MODEL_NUM LIKE '%Midicale%' OR CONDITION LIKE '%Midicale%' OR GENDER LIKE '%Midicale%' OR _CASE_ LIKE '%Midicale%' OR BRACELET LIKE '%Midicale%' OR DIAL LIKE '%Midicale%' OR STRAP LIKE '%Midicale%' OR COMMENT LIKE '%Midicale%' OR stock_notes LIKE '%Midicale%' OR HIDDEN LIKE '%Midicale%') OR ( MANUFACTURER LIKE '%GMT%' OR MODEL_NAME LIKE '%GMT%' OR INVENTORY_NUM LIKE '%GMT%' OR MOVEMENT_COMMENT LIKE '%GMT%' OR MOVEMENT LIKE '%GMT%' OR MODEL_NUM LIKE '%GMT%' OR CONDITION LIKE '%GMT%' OR GENDER LIKE '%GMT%' OR _CASE_ LIKE '%GMT%' OR BRACELET LIKE '%GMT%' OR DIAL LIKE '%GMT%' OR STRAP LIKE '%GMT%' OR COMMENT LIKE '%GMT%' OR stock_notes LIKE '%GMT%' OR HIDDEN LIKE '%GMT%') 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 '%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 '%Mundi%' OR MODEL_NAME LIKE '%Mundi%' OR INVENTORY_NUM LIKE '%Mundi%' OR MOVEMENT_COMMENT LIKE '%Mundi%' OR MOVEMENT LIKE '%Mundi%' OR MODEL_NUM LIKE '%Mundi%' OR CONDITION LIKE '%Mundi%' OR GENDER LIKE '%Mundi%' OR _CASE_ LIKE '%Mundi%' OR BRACELET LIKE '%Mundi%' OR DIAL LIKE '%Mundi%' OR STRAP LIKE '%Mundi%' OR COMMENT LIKE '%Mundi%' OR stock_notes LIKE '%Mundi%' OR HIDDEN LIKE '%Mundi%') 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%')) )  ORDER BY W.CREATED DESC LIMIT 0, 48