Skip to content

Instantly share code, notes, and snippets.

@dirkcuys
Created January 7, 2013 07:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dirkcuys/4473181 to your computer and use it in GitHub Desktop.
Save dirkcuys/4473181 to your computer and use it in GitHub Desktop.
Refactored SQL query
SELECT
`relationships_relationship`.`id`,
`relationships_relationship`.`source_id`,
`relationships_relationship`.`target_user_id`,
`relationships_relationship`.`target_project_id`,
`relationships_relationship`.`created_on`,
`relationships_relationship`.`deleted`
FROM
`relationships_relationship`
INNER JOIN
`users_userprofile` ON (`relationships_relationship`.`source_id` = `users_userprofile`.`id`)
INNER JOIN
`projects_perusertaskcompletion` ON (`relationships_relationship`.`source_id` = `projects_perusertaskcompletion`.`user_id`)
INNER JOIN
`content_page` U1 ON (`projects_perusertaskcompletion`.`page_id` = U1.`id`)
WHERE
`projects_perusertaskcompletion`.`unchecked_on` IS NULL
AND U1.`project_id` = 355
AND U1.`deleted` = False
AND `users_userprofile`.`deleted` = False
AND `relationships_relationship`.`target_project_id` = 355
GROUP BY
`projects_perusertaskcompletion`.`user_id`, `projects_perusertaskcompletion`.`user_id`
HAVING
COUNT(`projects_perusertaskcompletion`.`page_id`) = 4
LIMIT 56;
@dirkcuys
Copy link
Author

dirkcuys commented Jan 7, 2013

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment