in:
[select specials_id, products_id from specials where status = '0' and (((specials_date_available <= 20240429 and specials_date_available != '0001-01-01') and (expires_date > 20240429)) or ((specials_date_available <= 20240429 and specials_date_available != '0001-01-01') and (expires_date = '0001-01-01')) or (specials_date_available = '0001-01-01' and expires_date > 20240429)) ]