Skip to content

Important SQL queries

Gerard Casas edited this page Nov 5, 2018 · 3 revisions

Missing applications emails

Emails from users that have registered but have not completed the application.

select u.email from user_user u where not is_director and not is_volunteer and not is_organizer and u.id not in (select a.user_id from applications_application a);

Clone this wiki locally