Skip to content

Instantly share code, notes, and snippets.

@ojii

ojii/django-cms-queries.sql

Created July 21, 2010 16:04
Show Gist options
  • Save ojii/484685 to your computer and use it in GitHub Desktop.
Save ojii/484685 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
django-cms-queries.sql
SELECT "django_site"."id",
"django_site"."domain",
"django_site"."name"
FROM "django_site"
WHERE "django_site"."id" = 1 ;
SELECT "cms_page"."id",
"cms_page"."publisher_is_draft",
"cms_page"."publisher_public_id",
"cms_page"."publisher_state",
"cms_page"."created_by",
"cms_page"."changed_by",
"cms_page"."parent_id",
"cms_page"."creation_date",
"cms_page"."publication_date",
"cms_page"."publication_end_date",
"cms_page"."in_navigation",
"cms_page"."soft_root",
"cms_page"."reverse_id",
"cms_page"."navigation_extenders",
"cms_page"."published",
"cms_page"."template",
"cms_page"."site_id",
"cms_page"."moderator_state",
"cms_page"."level",
"cms_page"."lft",
"cms_page"."rght",
"cms_page"."tree_id",
"cms_page"."login_required",
"cms_page"."limit_visibility_in_menu"
FROM "cms_page"
LEFT OUTER JOIN "cms_page" T3 ON ("cms_page"."parent_id" = T3."id")
WHERE ("cms_page"."site_id" = 1
AND "cms_page"."published" = TRUE
AND T3."id" IS NULL)
ORDER BY "cms_page"."tree_id" ASC LIMIT 1;
SELECT "cms_title"."id",
"cms_title"."publisher_is_draft",
"cms_title"."publisher_public_id",
"cms_title"."publisher_state",
"cms_title"."language",
"cms_title"."title",
"cms_title"."menu_title",
"cms_title"."slug",
"cms_title"."path",
"cms_title"."has_url_overwrite",
"cms_title"."application_urls",
"cms_title"."redirect",
"cms_title"."meta_description",
"cms_title"."meta_keywords",
"cms_title"."page_title",
"cms_title"."page_id",
"cms_title"."creation_date"
FROM "cms_title"
WHERE "cms_title"."page_id" = 1 ;
SELECT "cms_title"."id",
"cms_title"."publisher_is_draft",
"cms_title"."publisher_public_id",
"cms_title"."publisher_state",
"cms_title"."language",
"cms_title"."title",
"cms_title"."menu_title",
"cms_title"."slug",
"cms_title"."path",
"cms_title"."has_url_overwrite",
"cms_title"."application_urls",
"cms_title"."redirect",
"cms_title"."meta_description",
"cms_title"."meta_keywords",
"cms_title"."page_title",
"cms_title"."page_id",
"cms_title"."creation_date",
"cms_page"."id",
"cms_page"."publisher_is_draft",
"cms_page"."publisher_public_id",
"cms_page"."publisher_state",
"cms_page"."created_by",
"cms_page"."changed_by",
"cms_page"."parent_id",
"cms_page"."creation_date",
"cms_page"."publication_date",
"cms_page"."publication_end_date",
"cms_page"."in_navigation",
"cms_page"."soft_root",
"cms_page"."reverse_id",
"cms_page"."navigation_extenders",
"cms_page"."published",
"cms_page"."template",
"cms_page"."site_id",
"cms_page"."moderator_state",
"cms_page"."level",
"cms_page"."lft",
"cms_page"."rght",
"cms_page"."tree_id",
"cms_page"."login_required",
"cms_page"."limit_visibility_in_menu",
"django_site"."id",
"django_site"."domain",
"django_site"."name"
FROM "cms_title"
INNER JOIN "cms_page" ON ("cms_title"."page_id" = "cms_page"."id")
INNER JOIN "django_site" ON ("cms_page"."site_id" = "django_site"."id")
WHERE ("cms_page"."publisher_is_draft" = FALSE
AND "cms_page"."site_id" = 1
AND "cms_title"."application_urls" >);
SELECT "cms_page"."id",
"cms_page"."publisher_is_draft",
"cms_page"."publisher_public_id",
"cms_page"."publisher_state",
"cms_page"."created_by",
"cms_page"."changed_by",
"cms_page"."parent_id",
"cms_page"."creation_date",
"cms_page"."publication_date",
"cms_page"."publication_end_date",
"cms_page"."in_navigation",
"cms_page"."soft_root",
"cms_page"."reverse_id",
"cms_page"."navigation_extenders",
"cms_page"."published",
"cms_page"."template",
"cms_page"."site_id",
"cms_page"."moderator_state",
"cms_page"."level",
"cms_page"."lft",
"cms_page"."rght",
"cms_page"."tree_id",
"cms_page"."login_required",
"cms_page"."limit_visibility_in_menu"
FROM "cms_page"
INNER JOIN "django_site" ON ("cms_page"."site_id" = "django_site"."id")
LEFT OUTER JOIN "cms_page" T3 ON ("cms_page"."parent_id" = T3."id")
WHERE ("cms_page"."publisher_is_draft" = FALSE
AND "cms_page"."site_id" = 1
AND "cms_page"."published" = TRUE
AND "cms_page"."site_id" = 1
AND T3."id" IS NULL)
ORDER BY "django_site"."domain" ASC, "cms_page"."tree_id" ASC, "cms_page"."lft" ASC;
SELECT "cms_page"."id",
"cms_page"."publisher_is_draft",
"cms_page"."publisher_public_id",
"cms_page"."publisher_state",
"cms_page"."created_by",
"cms_page"."changed_by",
"cms_page"."parent_id",
"cms_page"."creation_date",
"cms_page"."publication_date",
"cms_page"."publication_end_date",
"cms_page"."in_navigation",
"cms_page"."soft_root",
"cms_page"."reverse_id",
"cms_page"."navigation_extenders",
"cms_page"."published",
"cms_page"."template",
"cms_page"."site_id",
"cms_page"."moderator_state",
"cms_page"."level",
"cms_page"."lft",
"cms_page"."rght",
"cms_page"."tree_id",
"cms_page"."login_required",
"cms_page"."limit_visibility_in_menu"
FROM "cms_page"
LEFT OUTER JOIN "cms_page" T3 ON ("cms_page"."parent_id" = T3."id")
WHERE ("cms_page"."publisher_is_draft" = FALSE
AND "cms_page"."site_id" = 1
AND "cms_page"."published" = TRUE
AND "cms_page"."site_id" = 1
AND "cms_page"."site_id" = 1
AND "cms_page"."published" = TRUE
AND T3."id" IS NULL)
ORDER BY "cms_page"."tree_id" ASC LIMIT 1;
SELECT "cms_title"."id",
"cms_title"."publisher_is_draft",
"cms_title"."publisher_public_id",
"cms_title"."publisher_state",
"cms_title"."language",
"cms_title"."title",
"cms_title"."menu_title",
"cms_title"."slug",
"cms_title"."path",
"cms_title"."has_url_overwrite",
"cms_title"."application_urls",
"cms_title"."redirect",
"cms_title"."meta_description",
"cms_title"."meta_keywords",
"cms_title"."page_title",
"cms_title"."page_id",
"cms_title"."creation_date"
FROM "cms_title"
WHERE ("cms_title"."page_id" = 2
AND "cms_title"."language" = en);
SELECT "cms_cmsplugin"."id",
"cms_cmsplugin"."publisher_is_draft",
"cms_cmsplugin"."publisher_public_id",
"cms_cmsplugin"."publisher_state",
"cms_cmsplugin"."placeholder_id",
"cms_cmsplugin"."parent_id",
"cms_cmsplugin"."position",
"cms_cmsplugin"."language",
"cms_cmsplugin"."plugin_type",
"cms_cmsplugin"."creation_date",
"cms_cmsplugin"."level",
"cms_cmsplugin"."lft",
"cms_cmsplugin"."rght",
"cms_cmsplugin"."tree_id"
FROM "cms_cmsplugin"
LEFT OUTER JOIN "cms_placeholder" ON ("cms_cmsplugin"."placeholder_id" = "cms_placeholder"."id")
INNER JOIN "cms_page_placeholders" ON ("cms_placeholder"."id" = "cms_page_placeholders"."placeholder_id")
LEFT OUTER JOIN "cms_cmsplugin" T5 ON ("cms_cmsplugin"."parent_id" = T5."id")
WHERE ("cms_cmsplugin"."publisher_is_draft" = FALSE
AND "cms_page_placeholders"."page_id" = 2
AND "cms_cmsplugin"."language" = en
AND T5."id" IS NULL)
ORDER BY "cms_cmsplugin"."placeholder_id" ASC, "cms_cmsplugin"."position" ASC;
SELECT "cms_cmsplugin"."id",
"cms_cmsplugin"."publisher_is_draft",
"cms_cmsplugin"."publisher_public_id",
"cms_cmsplugin"."publisher_state",
"cms_cmsplugin"."placeholder_id",
"cms_cmsplugin"."parent_id",
"cms_cmsplugin"."position",
"cms_cmsplugin"."language",
"cms_cmsplugin"."plugin_type",
"cms_cmsplugin"."creation_date",
"cms_cmsplugin"."level",
"cms_cmsplugin"."lft",
"cms_cmsplugin"."rght",
"cms_cmsplugin"."tree_id",
"cmsplugin_text"."cmsplugin_ptr_id",
"cmsplugin_text"."body"
FROM "cmsplugin_text"
INNER JOIN "cms_cmsplugin" ON ("cmsplugin_text"."cmsplugin_ptr_id" = "cms_cmsplugin"."id")
WHERE "cmsplugin_text"."cmsplugin_ptr_id" = 2 ;
SELECT "django_site"."id",
"django_site"."domain",
"django_site"."name"
FROM "django_site"
WHERE "django_site"."id" = 1 ;
SELECT "cms_page"."id",
"cms_page"."publisher_is_draft",
"cms_page"."publisher_public_id",
"cms_page"."publisher_state",
"cms_page"."created_by",
"cms_page"."changed_by",
"cms_page"."parent_id",
"cms_page"."creation_date",
"cms_page"."publication_date",
"cms_page"."publication_end_date",
"cms_page"."in_navigation",
"cms_page"."soft_root",
"cms_page"."reverse_id",
"cms_page"."navigation_extenders",
"cms_page"."published",
"cms_page"."template",
"cms_page"."site_id",
"cms_page"."moderator_state",
"cms_page"."level",
"cms_page"."lft",
"cms_page"."rght",
"cms_page"."tree_id",
"cms_page"."login_required",
"cms_page"."limit_visibility_in_menu"
FROM "cms_page"
LEFT OUTER JOIN "cms_page" T3 ON ("cms_page"."parent_id" = T3."id")
WHERE ("cms_page"."publisher_is_draft" = FALSE
AND "cms_page"."site_id" = 1
AND "cms_page"."published" = TRUE
AND T3."id" IS NULL)
ORDER BY "cms_page"."tree_id" ASC LIMIT 1;
SELECT "cms_page"."id",
"cms_page"."publisher_is_draft",
"cms_page"."publisher_public_id",
"cms_page"."publisher_state",
"cms_page"."created_by",
"cms_page"."changed_by",
"cms_page"."parent_id",
"cms_page"."creation_date",
"cms_page"."publication_date",
"cms_page"."publication_end_date",
"cms_page"."in_navigation",
"cms_page"."soft_root",
"cms_page"."reverse_id",
"cms_page"."navigation_extenders",
"cms_page"."published",
"cms_page"."template",
"cms_page"."site_id",
"cms_page"."moderator_state",
"cms_page"."level",
"cms_page"."lft",
"cms_page"."rght",
"cms_page"."tree_id",
"cms_page"."login_required",
"cms_page"."limit_visibility_in_menu"
FROM "cms_page"
WHERE ("cms_page"."publisher_is_draft" = FALSE
AND "cms_page"."site_id" = 1
AND "cms_page"."published" = TRUE
AND "cms_page"."site_id" = 1)
ORDER BY "cms_page"."tree_id" ASC, "cms_page"."lft" ASC;
SELECT "django_site"."id",
"django_site"."domain",
"django_site"."name"
FROM "django_site"
WHERE "django_site"."id" = 1 ;
SELECT "cms_title"."id",
"cms_title"."publisher_is_draft",
"cms_title"."publisher_public_id",
"cms_title"."publisher_state",
"cms_title"."language",
"cms_title"."title",
"cms_title"."menu_title",
"cms_title"."slug",
"cms_title"."path",
"cms_title"."has_url_overwrite",
"cms_title"."application_urls",
"cms_title"."redirect",
"cms_title"."meta_description",
"cms_title"."meta_keywords",
"cms_title"."page_title",
"cms_title"."page_id",
"cms_title"."creation_date"
FROM "cms_title"
WHERE ("cms_title"."publisher_is_draft" = FALSE
AND "cms_title"."language" = en
AND "cms_title"."page_id" IN (2));
SELECT "sampleapp_category"."id",
"sampleapp_category"."parent_id",
"sampleapp_category"."name",
"sampleapp_category"."description_id",
"sampleapp_category"."lft",
"sampleapp_category"."rght",
"sampleapp_category"."tree_id",
"sampleapp_category"."level"
FROM "sampleapp_category";
SELECT "cms_placeholder"."id",
"cms_placeholder"."slot",
"cms_placeholder"."default_width"
FROM "cms_placeholder"
INNER JOIN "cms_page_placeholders" ON ("cms_placeholder"."id" = "cms_page_placeholders"."placeholder_id")
WHERE "cms_page_placeholders"."page_id" = 2 ;
SELECT "cms_cmsplugin"."id",
"cms_cmsplugin"."publisher_is_draft",
"cms_cmsplugin"."publisher_public_id",
"cms_cmsplugin"."publisher_state",
"cms_cmsplugin"."placeholder_id",
"cms_cmsplugin"."parent_id",
"cms_cmsplugin"."position",
"cms_cmsplugin"."language",
"cms_cmsplugin"."plugin_type",
"cms_cmsplugin"."creation_date",
"cms_cmsplugin"."level",
"cms_cmsplugin"."lft",
"cms_cmsplugin"."rght",
"cms_cmsplugin"."tree_id"
FROM "cms_cmsplugin"
LEFT OUTER JOIN "cms_cmsplugin" T3 ON ("cms_cmsplugin"."parent_id" = T3."id")
WHERE ("cms_cmsplugin"."publisher_is_draft" = FALSE
AND "cms_cmsplugin"."placeholder_id" = 7
AND "cms_cmsplugin"."language" = en
AND T3."id" IS NULL)
ORDER BY "cms_cmsplugin"."placeholder_id" ASC, "cms_cmsplugin"."position" ASC;
SELECT "cms_cmsplugin"."id",
"cms_cmsplugin"."publisher_is_draft",
"cms_cmsplugin"."publisher_public_id",
"cms_cmsplugin"."publisher_state",
"cms_cmsplugin"."placeholder_id",
"cms_cmsplugin"."parent_id",
"cms_cmsplugin"."position",
"cms_cmsplugin"."language",
"cms_cmsplugin"."plugin_type",
"cms_cmsplugin"."creation_date",
"cms_cmsplugin"."level",
"cms_cmsplugin"."lft",
"cms_cmsplugin"."rght",
"cms_cmsplugin"."tree_id"
FROM "cms_cmsplugin"
LEFT OUTER JOIN "cms_cmsplugin" T3 ON ("cms_cmsplugin"."parent_id" = T3."id")
WHERE ("cms_cmsplugin"."publisher_is_draft" = FALSE
AND "cms_cmsplugin"."placeholder_id" = 8
AND "cms_cmsplugin"."language" = en
AND T3."id" IS NULL)
ORDER BY "cms_cmsplugin"."placeholder_id" ASC, "cms_cmsplugin"."position" ASC;
SELECT "cms_cmsplugin"."id",
"cms_cmsplugin"."publisher_is_draft",
"cms_cmsplugin"."publisher_public_id",
"cms_cmsplugin"."publisher_state",
"cms_cmsplugin"."placeholder_id",
"cms_cmsplugin"."parent_id",
"cms_cmsplugin"."position",
"cms_cmsplugin"."language",
"cms_cmsplugin"."plugin_type",
"cms_cmsplugin"."creation_date",
"cms_cmsplugin"."level",
"cms_cmsplugin"."lft",
"cms_cmsplugin"."rght",
"cms_cmsplugin"."tree_id"
FROM "cms_cmsplugin"
LEFT OUTER JOIN "cms_cmsplugin" T3 ON ("cms_cmsplugin"."parent_id" = T3."id")
WHERE ("cms_cmsplugin"."publisher_is_draft" = FALSE
AND "cms_cmsplugin"."placeholder_id" = 9
AND "cms_cmsplugin"."language" = en
AND T3."id" IS NULL)
ORDER BY "cms_cmsplugin"."placeholder_id" ASC, "cms_cmsplugin"."position" ASC;
SELECT "cms_cmsplugin"."id",
"cms_cmsplugin"."publisher_is_draft",
"cms_cmsplugin"."publisher_public_id",
"cms_cmsplugin"."publisher_state",
"cms_cmsplugin"."placeholder_id",
"cms_cmsplugin"."parent_id",
"cms_cmsplugin"."position",
"cms_cmsplugin"."language",
"cms_cmsplugin"."plugin_type",
"cms_cmsplugin"."creation_date",
"cms_cmsplugin"."level",
"cms_cmsplugin"."lft",
"cms_cmsplugin"."rght",
"cms_cmsplugin"."tree_id"
FROM "cms_cmsplugin"
WHERE "cms_cmsplugin"."placeholder_id" = 9 ;
SELECT "cms_cmsplugin"."id",
"cms_cmsplugin"."publisher_is_draft",
"cms_cmsplugin"."publisher_public_id",
"cms_cmsplugin"."publisher_state",
"cms_cmsplugin"."placeholder_id",
"cms_cmsplugin"."parent_id",
"cms_cmsplugin"."position",
"cms_cmsplugin"."language",
"cms_cmsplugin"."plugin_type",
"cms_cmsplugin"."creation_date",
"cms_cmsplugin"."level",
"cms_cmsplugin"."lft",
"cms_cmsplugin"."rght",
"cms_cmsplugin"."tree_id",
"cmsplugin_text"."cmsplugin_ptr_id",
"cmsplugin_text"."body"
FROM "cmsplugin_text"
INNER JOIN "cms_cmsplugin" ON ("cmsplugin_text"."cmsplugin_ptr_id" = "cms_cmsplugin"."id")
WHERE "cmsplugin_text"."cmsplugin_ptr_id" = 2 ;
SELECT "cms_page"."id",
"cms_page"."publisher_is_draft",
"cms_page"."publisher_public_id",
"cms_page"."publisher_state",
"cms_page"."created_by",
"cms_page"."changed_by",
"cms_page"."parent_id",
"cms_page"."creation_date",
"cms_page"."publication_date",
"cms_page"."publication_end_date",
"cms_page"."in_navigation",
"cms_page"."soft_root",
"cms_page"."reverse_id",
"cms_page"."navigation_extenders",
"cms_page"."published",
"cms_page"."template",
"cms_page"."site_id",
"cms_page"."moderator_state",
"cms_page"."level",
"cms_page"."lft",
"cms_page"."rght",
"cms_page"."tree_id",
"cms_page"."login_required",
"cms_page"."limit_visibility_in_menu"
FROM "cms_page"
INNER JOIN "cms_page_placeholders" ON ("cms_page"."id" = "cms_page_placeholders"."page_id")
WHERE "cms_page_placeholders"."placeholder_id" = 9 ;
SELECT "cms_cmsplugin"."id",
"cms_cmsplugin"."publisher_is_draft",
"cms_cmsplugin"."publisher_public_id",
"cms_cmsplugin"."publisher_state",
"cms_cmsplugin"."placeholder_id",
"cms_cmsplugin"."parent_id",
"cms_cmsplugin"."position",
"cms_cmsplugin"."language",
"cms_cmsplugin"."plugin_type",
"cms_cmsplugin"."creation_date",
"cms_cmsplugin"."level",
"cms_cmsplugin"."lft",
"cms_cmsplugin"."rght",
"cms_cmsplugin"."tree_id",
"cmsplugin_text"."cmsplugin_ptr_id",
"cmsplugin_text"."body"
FROM "cmsplugin_text"
INNER JOIN "cms_cmsplugin" ON ("cmsplugin_text"."cmsplugin_ptr_id" = "cms_cmsplugin"."id")
WHERE "cmsplugin_text"."cmsplugin_ptr_id" = 2 ;
SELECT "cms_placeholder"."id",
"cms_placeholder"."slot",
"cms_placeholder"."default_width"
FROM "cms_placeholder"
WHERE "cms_placeholder"."id" = 9 ;
SELECT "cms_page"."id",
"cms_page"."publisher_is_draft",
"cms_page"."publisher_public_id",
"cms_page"."publisher_state",
"cms_page"."created_by",
"cms_page"."changed_by",
"cms_page"."parent_id",
"cms_page"."creation_date",
"cms_page"."publication_date",
"cms_page"."publication_end_date",
"cms_page"."in_navigation",
"cms_page"."soft_root",
"cms_page"."reverse_id",
"cms_page"."navigation_extenders",
"cms_page"."published",
"cms_page"."template",
"cms_page"."site_id",
"cms_page"."moderator_state",
"cms_page"."level",
"cms_page"."lft",
"cms_page"."rght",
"cms_page"."tree_id",
"cms_page"."login_required",
"cms_page"."limit_visibility_in_menu"
FROM "cms_page"
INNER JOIN "cms_page_placeholders" ON ("cms_page"."id" = "cms_page_placeholders"."page_id")
WHERE "cms_page_placeholders"."placeholder_id" = 9 ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment