gistfile1

2011-11-15 13:43:43 UTC LOG:  duration: 351.323 ms  statement: SELECT DISTINCT "cms_contentitem"."id", "cms_contentitem"."creation_date", "cms_contentitem"."publication_date", "cms_contentitem"."modification_date", "cms_contentitem"."status", "cms_contentitem"."title", "cms_contentitem"."basename", "cms_contentitem"."description", "cms_contentitem"."category_id", "cms_contentitem"."promo_image_id", "cms_contentitem"."author_id", "cms_category"."id", "cms_category"."label", "cms_category"."basename", "cms_category"."parent_id", "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", "cms_entry"."contentitem_ptr_id", "cms_entry"."body", "cms_entry"."_body_rendered", "cms_slideshow"."contentitem_ptr_id" FROM "cms_contentitem" INNER JOIN "cms_contentitem_tags" ON ("cms_contentitem"."id" = "cms_contentitem_tags"."contentitem_id") INNER JOIN "cms_category" ON ("cms_contentitem"."category_id" = "cms_category"."id") LEFT OUTER JOIN "auth_user" ON ("cms_contentitem"."author_id" = "auth_user"."id") LEFT OUTER JOIN "cms_entry" ON ("cms_contentitem"."id" = "cms_entry"."contentitem_ptr_id") LEFT OUTER JOIN "cms_slideshow" ON ("cms_contentitem"."id" = "cms_slideshow"."contentitem_ptr_id") WHERE ("cms_contentitem"."status" = 'P'  AND NOT ("cms_contentitem"."id" = 66246 ) AND "cms_contentitem_tags"."tag_id" IN (SELECT U0."id" FROM "cms_tag" U0 INNER JOIN "cms_contentitem_tags" U1 ON (U0."id" = U1."tag_id") WHERE U1."contentitem_id" = 66246 )) ORDER BY "cms_contentitem"."publication_date" DESC LIMIT 3