gistfile1.sql

SELECT (gatekeeper_moderatedobject.moderation_status) AS "_moderation_status",
       (gatekeeper_moderatedobject.flagged) AS "_flagged",
       (gatekeeper_moderatedobject.id) AS "_moderation_id",
       "projects_project"."id",
       "projects_project"."created",
       "projects_project"."modified",
       "projects_project"."title",
       "projects_project"."mission_statement",
       "projects_project"."extra_description",
       "projects_project"."picture_id",
       "projects_project"."website",
       "projects_project"."website_description",
       "projects_project"."location",
       "projects_project"."privacy",
       "projects_project"."allow_showcase",
       "projects_project"."showcase",
       "projects_project"."highlight",
       "projects_project"."is_complete",
       "projects_project"."tags"
FROM "projects_project" ,
     "gatekeeper_moderatedobject" ,
     "tagging_taggeditem"
WHERE ("projects_project"."is_complete" = False
       AND "projects_project"."privacy" = 0)
  AND content_type_id=11
  AND gatekeeper_moderatedobject.object_id=projects_project.id
  AND moderation_status = 1
  AND "tagging_taggeditem".content_type_id = 11
  AND "tagging_taggeditem".tag_id = 1
  AND "projects_project"."id" = "tagging_taggeditem".object_id
ORDER BY "projects_project"."created" DESC