select * from salemaker_sales where sale_deduction_value>0 and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0000-00-00') and (sale_date_end >= now() or sale_date_end = '0000-00-00') and find_in_set(3_167_140_139_76_200_242_141_344_343_4_267,sale_categories)