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(74_172_63_142,sale_categories)