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