Check table komf_scheduled_show_verifications;
Run stored procedure to update scheduled shows
CALL komf_update_scheduled_shows
Check table results afterwards. IF A NEW ROW WAS CREATED:
Join songs to komf_emails ON (title & type=’om_project’)
Joined to the new row in komf_scheduled_show_verifications ON ShowName = songs.album
Send an email to the address from komf_emails
(& ourselves?)
Check table komf_scheduled_show_verifications; Run stored procedure to update scheduled shows CALL komf_update_scheduled_shows Check table results afterwards. IF A NEW ROW WAS CREATED: Join songs to komf_emails ON (title & type=’om_project’) Joined to the new row in komf_scheduled_show_verifications ON ShowName = songs.album Send an email to the address from komf_emails (& ourselves?)