SELECT CAST(DATE_FORMAT(`blog_post`.`date`,
         '%Y-%m-01 00:00:00') AS DATETIME) 
FROM   `blog_post`
WHERE  (`blog_post`.`is_draft` = False
        AND `blog_post`.`date` <= 2008-05-14 06:06:40.702234
        AND `blog_post`.`date` BETWEEN 2008-01-01 00:00:00
        AND 2008-12-31 23:59:59.999999) GROUP BY 1
ORDER  BY 1 ASC

SELECT `comment_nodes`.`id`,
        `comment_nodes`.`user_id`,
        `comment_nodes`.`pub_date`,
        `comment_nodes`.`upd_date`,
        `comment_nodes`.`body`,
        `comment_nodes`.`body_html`,
        `comment_nodes`.`reply_to_id`,
        `comment_nodes`.`approved`,
        `comment_nodes`.`content_type_id`,
        `comment_nodes`.`object_id`,
        `comment_nodes`.`lft`,
        `comment_nodes`.`rght`,
        `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`,
        `auth_user`.`site`,
        `auth_user`.`email_new`,
        `django_content_type`.`id`,
        `django_content_type`.`name`,
        `django_content_type`.`app_label`,
        `django_content_type`.`model`
FROM   `comment_nodes` ,
         `auth_user`,
         `django_content_type`
WHERE  (`comment_nodes`.`approved` = True
        AND `comment_nodes`.`approved` = True)
        AND `comment_nodes`.`user_id` = `auth_user`.`id`
        AND `comment_nodes`.`content_type_id` = `django_content_type`.`id`
ORDER  BY `comment_nodes`.`pub_date` DESC LIMIT 5 

SELECT `blog_post`.`id`,
        `blog_post`.`author_id`,
        `blog_post`.`name`,
        `blog_post`.`slug`,
        `blog_post`.`teaser`,
        `blog_post`.`text`,
        `blog_post`.`render_method`,
        `blog_post`.`html`,
        `blog_post`.`date`,
        `blog_post`.`upd_date`,
        `blog_post`.`is_draft`,
        `blog_post`.`is_featured`,
        `blog_post`.`enable_comments`,
        `blog_post`.`tags`,
        (SELECT COUNT(*)
FROM   comment_nodes,
         django_content_type
WHERE  comment_nodes.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND comment_nodes.object_id = blog_post.id
        AND comment_nodes.approved) AS `approved_comments_count`,
        (SELECT COUNT(*)
FROM   pingback,
         django_content_type
WHERE  pingback.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND pingback.object_id = blog_post.id) AS `pingback_count`
FROM   `blog_post`
WHERE  (`blog_post`.`id` = 39)

SELECT `blog_post`.`id`,
        `blog_post`.`author_id`,
        `blog_post`.`name`,
        `blog_post`.`slug`,
        `blog_post`.`teaser`,
        `blog_post`.`text`,
        `blog_post`.`render_method`,
        `blog_post`.`html`,
        `blog_post`.`date`,
        `blog_post`.`upd_date`,
        `blog_post`.`is_draft`,
        `blog_post`.`is_featured`,
        `blog_post`.`enable_comments`,
        `blog_post`.`tags`,
        (SELECT COUNT(*)
FROM   comment_nodes,
         django_content_type
WHERE  comment_nodes.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND comment_nodes.object_id = blog_post.id
        AND comment_nodes.approved) AS `approved_comments_count`,
        (SELECT COUNT(*)
FROM   pingback,
         django_content_type
WHERE  pingback.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND pingback.object_id = blog_post.id) AS `pingback_count`
FROM   `blog_post`
WHERE  (`blog_post`.`id` = 37)

SELECT `blog_post`.`id`,
        `blog_post`.`author_id`,
        `blog_post`.`name`,
        `blog_post`.`slug`,
        `blog_post`.`teaser`,
        `blog_post`.`text`,
        `blog_post`.`render_method`,
        `blog_post`.`html`,
        `blog_post`.`date`,
        `blog_post`.`upd_date`,
        `blog_post`.`is_draft`,
        `blog_post`.`is_featured`,
        `blog_post`.`enable_comments`,
        `blog_post`.`tags`,
        (SELECT COUNT(*)
FROM   comment_nodes,
         django_content_type
WHERE  comment_nodes.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND comment_nodes.object_id = blog_post.id
        AND comment_nodes.approved) AS `approved_comments_count`,
        (SELECT COUNT(*)
FROM   pingback,
         django_content_type
WHERE  pingback.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND pingback.object_id = blog_post.id) AS `pingback_count`
FROM   `blog_post`
WHERE  (`blog_post`.`id` = 36)

SELECT `blog_post`.`id`,
        `blog_post`.`author_id`,
        `blog_post`.`name`,
        `blog_post`.`slug`,
        `blog_post`.`teaser`,
        `blog_post`.`text`,
        `blog_post`.`render_method`,
        `blog_post`.`html`,
        `blog_post`.`date`,
        `blog_post`.`upd_date`,
        `blog_post`.`is_draft`,
        `blog_post`.`is_featured`,
        `blog_post`.`enable_comments`,
        `blog_post`.`tags`,
        (SELECT COUNT(*)
FROM   comment_nodes,
         django_content_type
WHERE  comment_nodes.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND comment_nodes.object_id = blog_post.id
        AND comment_nodes.approved) AS `approved_comments_count`,
        (SELECT COUNT(*)
FROM   pingback,
         django_content_type
WHERE  pingback.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND pingback.object_id = blog_post.id) AS `pingback_count`
FROM   `blog_post`
WHERE  (`blog_post`.`id` = 36)

SELECT `blog_post`.`id`,
        `blog_post`.`author_id`,
        `blog_post`.`name`,
        `blog_post`.`slug`,
        `blog_post`.`teaser`,
        `blog_post`.`text`,
        `blog_post`.`render_method`,
        `blog_post`.`html`,
        `blog_post`.`date`,
        `blog_post`.`upd_date`,
        `blog_post`.`is_draft`,
        `blog_post`.`is_featured`,
        `blog_post`.`enable_comments`,
        `blog_post`.`tags`,
        (SELECT COUNT(*)
FROM   comment_nodes,
         django_content_type
WHERE  comment_nodes.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND comment_nodes.object_id = blog_post.id
        AND comment_nodes.approved) AS `approved_comments_count`,
        (SELECT COUNT(*)
FROM   pingback,
         django_content_type
WHERE  pingback.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND pingback.object_id = blog_post.id) AS `pingback_count`
FROM   `blog_post`
WHERE  (`blog_post`.`id` = 36)

SELECT `blog_post`.`id`,
        `blog_post`.`author_id`,
        `blog_post`.`name`,
        `blog_post`.`slug`,
        `blog_post`.`teaser`,
        `blog_post`.`text`,
        `blog_post`.`render_method`,
        `blog_post`.`html`,
        `blog_post`.`date`,
        `blog_post`.`upd_date`,
        `blog_post`.`is_draft`,
        `blog_post`.`is_featured`,
        `blog_post`.`enable_comments`,
        `blog_post`.`tags`,
        (SELECT COUNT(*)
FROM   comment_nodes,
         django_content_type
WHERE  comment_nodes.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND comment_nodes.object_id = blog_post.id
        AND comment_nodes.approved) AS `approved_comments_count`,
        (SELECT COUNT(*)
FROM   pingback,
         django_content_type
WHERE  pingback.content_type_id = django_content_type.id
        AND django_content_type.model = 'post'
        AND pingback.object_id = blog_post.id) AS `pingback_count`
FROM   `blog_post`
WHERE  (`blog_post`.`is_draft` = False)
ORDER  BY `blog_post`.`date` DESC LIMIT 5 

        SELECT DISTINCT `tag`.id,
         `tag`.name,
         `tag`.translation,
         COUNT(`blog_post`.`id`)
       
FROM
            `tag`
           
INNER  JOIN `tagged_item`
               
ON     `tag`.id = `tagged_item`.tag_id
           
INNER  JOIN `blog_post`
               
ON     `tagged_item`.object_id = `blog_post`.`id`
            
       
WHERE  `tagged_item`.content_type_id = 12
            
        GROUP BY `tag`.id,
         `tag`.name,
         `tag`.translation
        
       
ORDER  BY `tag`.name ASC

SELECT `blogroll_link`.`id`,
        `blogroll_link`.`url`,
        `blogroll_link`.`name`,
        `blogroll_link`.`relations`,
        `blogroll_link`.`order`,
        `blogroll_link`.`friendship_rel`,
        `blogroll_link`.`physical_rel`,
        `blogroll_link`.`professional_rel`,
        `blogroll_link`.`geographical_rel`,
        `blogroll_link`.`family_rel`,
        `blogroll_link`.`romantic_rel`,
        `blogroll_link`.`identity_rel`
FROM   `blogroll_link`
ORDER  BY `blogroll_link`.`order` ASC