in:
[select sale_id from salemaker_sales where sale_status = '0' and (((sale_date_start <= 20241122 and sale_date_start != '0001-01-01') and (sale_date_end > 20241122)) or ((sale_date_start <= 20241122 and sale_date_start != '0001-01-01') and (sale_date_end = '0001-01-01')) or (sale_date_start = '0001-01-01' and sale_date_end > 20241122)) ]