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(127_128_125_115_135_290_117,sale_categories)