Skip to content

Instantly share code, notes, and snippets.

@schaary

schaary/resources_assing inconsitency

Forked from Krassmus/resources_assing inconsitency
Created March 24, 2017 12:28
Show Gist options
  • Save schaary/08e08348e7e21c575380d8073445a588 to your computer and use it in GitHub Desktop.
Save schaary/08e08348e7e21c575380d8073445a588 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
resources_assing inconsitency
Select resources_assign.*
FROM resources_assign
LEFT JOIN termine ON (termine.termin_id = resources_assign.`assign_user_id`)
LEFT JOIN auth_user_md5 ON (auth_user_md5.user_id = resources_assign.`assign_user_id`)
WHERE auth_user_md5.user_id IS NULL
AND termine.termin_id IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment