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(35_457_238,sale_categories)