Skip to content

Instantly share code, notes, and snippets.

@amackera
Created November 20, 2012 02:46
Show Gist options
  • Save amackera/4115606 to your computer and use it in GitHub Desktop.
Save amackera/4115606 to your computer and use it in GitHub Desktop.
wtfquery
SELECT `auth_user`.`id`, `auth_user`.`username`, `auth_user`.`first_name`, `auth_user`.`last_name`, `auth_user`.`email`, `auth_user`.`password`, `auth_user`.`is_staff`, `auth_user`.`is_active`, `auth_user`.`is_superuser`, `auth_user`.`last_login`, `auth_user`.`date_joined`, `accounts_thmuser`.`user_ptr_id`, `accounts_thmuser`.`key_str`, `accounts_thmuser`.`role`, `accounts_thmuser`.`created_date`, `accounts_thmuser`.`last_active`, `accounts_thmuser`.`logged_in`, `accounts_thmuser`.`student_id`, `accounts_thmuser`.`course_passwords`, `accounts_thmuser`.`current_ip_address`, `accounts_thmuser`.`is_anonymous_account`, `accounts_thmuser`.`phone_number`, `accounts_thmuser`.`verified`, `accounts_thmuser`.`clicker_id`, `accounts_thmuser`.`clicker_checksum`, `accounts_thmuser`.`department_id`, `accounts_thmuser`.`org_id`, `accounts_thmuser`.`subscription_id`, `accounts_thmuser`.`current_course_id`, `accounts_thmuser`.`weekly_notification_email`, `accounts_thmuser`.`alias` FROM `accounts_thmuser` INNER JOIN `course_coursemembership` ON (`accounts_thmuser`.`user_ptr_id` = `course_coursemembership`.`student_id`) INNER JOIN `auth_user` ON (`accounts_thmuser`.`user_ptr_id` = `auth_user`.`id`) WHERE `course_coursemembership`.`course_id` = 2950
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment