fast_explore.sql

SELECT "posts_post"."id",
       "posts_post"."created_by_id",
       "posts_post"."modified_by_id",
       "posts_post"."created_at",
       "posts_post"."modified_at",
       "posts_post"."blog_id",
       "posts_post"."author_id",
       "posts_post"."title",
       "posts_post"."body",
       "posts_post"."tags",
       "posts_post"."thumbnail_id",
       "posts_post"."status",
       "posts_post"."publish_date",
       "posts_post"."sticky",
       "posts_post"."allow_comments",
       "posts_post"."tease",
       "posts_post"."slug",
       "posts_post"."use_as_page",
       "posts_post"."title_tag",
       "posts_post"."meta_keywords",
       "posts_post"."meta_description",
       "posts_post"."objectionable_content",
       "posts_post"."objectionable_content_override",
       "posts_post"."spam",
       "posts_post"."share_google",
       "posts_post"."share_facebook",
       "posts_post"."share_twitter",
       "posts_post"."share_stumble",
       "posts_post"."share_pinterest",
       "posts_post"."bayes_trained_category",
       "posts_post"."bayes_spam_score",
       "posts_post"."bayes_ham_score",
       "posts_post"."bayes_classification",
       "posts_post"."bayes_scored_at"
FROM "posts_post"
INNER JOIN "blogs_blog" ON ("posts_post"."blog_id" = "blogs_blog"."id")
WHERE ("posts_post"."status" = Published
       AND "posts_post"."publish_date" <= 2013-12-22 23:33:11.053809+00:00
       AND "blogs_blog"."access_code" =
       AND "posts_post"."use_as_page" = FALSE
       AND "posts_post"."sticky" = FALSE
       AND "posts_post"."objectionable_content" = FALSE
       AND "posts_post"."objectionable_content_override" = FALSE
       AND "posts_post"."publish_date" IS NOT NULL
       AND "blogs_blog"."status" = Active
       AND "posts_post"."author_id" IN
         (SELECT U0."id"
          FROM "auth_user" U0
          INNER JOIN "spreedly_subscription" U1 ON (U0."id" = U1."user_id")
          WHERE U1."active" = TRUE))
ORDER BY "posts_post"."publish_date" DESC;