SELECT conference_code, conference, conference_url, (CASE WHEN url_code = 0 THEN conference_code ELSE url_code END) url_code, fromdate, pr.image_file, promote_end_date, todate, not_final_date
FROM promotions pr
JOIN conferences c ON c.conference_code=pr.conf_code
WHERE promote_start_date <= '2020-04-01' AND promote_end_date >= '2020-04-01' AND trans_id!='0' AND pr.conf_date = c.fromdate AND c.fromdate > '2020-04-01'
ORDER BY fromdate
