SELECT config_id
FROM mt_config
;
SELECT config_id, config_data
FROM mt_config
WHERE (config_id IN ('1'))
;
SELECT field_id
FROM mt_field
;
SELECT author_id
FROM mt_author
WHERE (author_auth_type = 'MT') AND (author_name = 'username') AND (author_type = '1')
;
SELECT author_id, author_api_password, author_auth_type, author_basename, author_can_create_blog, author_can_view_log, author_created_by, author_created_on, author_email, author_entry_prefs, author_external_id, author_hint, author_is_superuser, author_modified_by, author_modified_on, author_name, author_nickname, author_password, author_preferred_language, author_public_key, author_remote_auth_token, author_remote_auth_username, author_status, author_text_format, author_type, author_url, author_userpic_asset_id
FROM mt_author
WHERE (author_id IN ('1'))
;
SELECT session_id
FROM mt_session
WHERE (session_kind = 'US') AND (session_id = 'pzwjvV81hDYyBa7Z9TInLQAxuOvNaOTvzNgzx1kJ')
LIMIT 1
;
SELECT session_id, session_data, session_email, session_kind, session_name, session_start
FROM mt_session
WHERE (session_id IN ('pzwjvV81hDYyBa7Z9TInLQAxuOvNaOTvzNgzx1kJ'))
;
SELECT session_id
FROM mt_session
WHERE (session_kind = 'UA') AND (session_name = '1')
LIMIT 1
;
SELECT session_id, session_data, session_email, session_kind, session_name, session_start
FROM mt_session
WHERE (session_id IN ('h7h6oHyCz4N7VneEC28xhnKFnlBMUBDlM8mgeqWq'))
;
SELECT 1 FROM mt_session
WHERE (session_id = 'h7h6oHyCz4N7VneEC28xhnKFnlBMUBDlM8mgeqWq')
;
SELECT blog_id, blog_allow_anon_comments, blog_allow_comment_html, blog_allow_commenter_regist, blog_allow_comments_default, blog_allow_pings, blog_allow_pings_default, blog_allow_reg_comments, blog_allow_unreg_comments, blog_archive_path, blog_archive_tmpl_category, blog_archive_tmpl_daily, blog_archive_tmpl_individual, blog_archive_tmpl_monthly, blog_archive_tmpl_weekly, blog_archive_type, blog_archive_type_preferred, blog_archive_url, blog_autodiscover_links, blog_autolink_urls, blog_basename_limit, blog_cc_license, blog_children_modified_on, blog_convert_paras, blog_convert_paras_comments, blog_created_by, blog_created_on, blog_custom_dynamic_templates, blog_days_on_index, blog_description, blog_email_new_comments, blog_email_new_pings, blog_entries_on_index, blog_file_extension, blog_google_api_key, blog_internal_autodiscovery, blog_is_dynamic, blog_junk_folder_expiry, blog_junk_score_threshold, blog_language, blog_manual_approve_commenters, blog_moderate_pings, blog_moderate_unreg_comments, blog_modified_by, blog_modified_on, blog_mt_update_key, blog_name, blog_old_style_archive_links, blog_ping_blogs, blog_ping_google, blog_ping_others, blog_ping_technorati, blog_ping_weblogs, blog_remote_auth_token, blog_require_comment_emails, blog_sanitize_spec, blog_server_offset, blog_site_path, blog_site_url, blog_sort_order_comments, blog_sort_order_posts, blog_status_default, blog_use_comment_confirmation, blog_welcome_msg, blog_words_in_excerpt
FROM mt_blog
WHERE (blog_id = '1')
LIMIT 1
;
SELECT permission_id
FROM mt_permission
WHERE (permission_author_id = '1') AND (permission_blog_id IN ('0','1'))
;
SELECT permission_id, permission_author_id, permission_blog_id, permission_blog_prefs, permission_created_by, permission_created_on, permission_entry_prefs, permission_modified_by, permission_modified_on, permission_permissions, permission_restrictions, permission_role_mask, permission_template_prefs
FROM mt_permission
WHERE (permission_id IN ('1','2'))
;
SELECT field_id
FROM mt_field
;
SELECT permission_id
FROM mt_permission
WHERE (permission_author_id = '1') AND (permission_blog_id = '0')
;
SELECT blog_meta_blog_id, blog_meta_type, blog_meta_vchar, blog_meta_vchar_idx, blog_meta_vdatetime, blog_meta_vdatetime_idx, blog_meta_vinteger, blog_meta_vinteger_idx, blog_meta_vfloat, blog_meta_vfloat_idx, blog_meta_vblob, blog_meta_vclob
FROM mt_blog_meta
WHERE (blog_meta_blog_id = '1')
;
SELECT author_meta_author_id, author_meta_type, author_meta_vchar, author_meta_vchar_idx, author_meta_vdatetime, author_meta_vdatetime_idx, author_meta_vinteger, author_meta_vinteger_idx, author_meta_vfloat, author_meta_vfloat_idx, author_meta_vblob, author_meta_vclob
FROM mt_author_meta
WHERE (author_meta_author_id = '1')
;
SELECT blog_id
FROM mt_blog, mt_permission
WHERE (permission_author_id = '1') AND (permission_permissions != '\'comment\'') AND (blog_id = permission_blog_id)
LIMIT 11
;
SELECT COUNT(*)
FROM mt_blog
;
SELECT config_id
FROM mt_config
LIMIT 1
;
SELECT config_id, config_data
FROM mt_config
WHERE (config_id IN ('1'))
;
SELECT 1 FROM mt_config
WHERE (config_id = '1')
;
SELECT config_id
FROM mt_config
;
SELECT config_id, config_data
FROM mt_config
WHERE (config_id IN ('1'))
;
SELECT field_id
FROM mt_field
;
SELECT author_id
FROM mt_author
WHERE (author_auth_type = 'MT') AND (author_name = 'username') AND (author_type = '1')
;
SELECT author_id, author_api_password, author_auth_type, author_basename, author_can_create_blog, author_can_view_log, author_created_by, author_created_on, author_email, author_entry_prefs, author_external_id, author_hint, author_is_superuser, author_modified_by, author_modified_on, author_name, author_nickname, author_password, author_preferred_language, author_public_key, author_remote_auth_token, author_remote_auth_username, author_status, author_text_format, author_type, author_url, author_userpic_asset_id
FROM mt_author
WHERE (author_id IN ('1'))
;
SELECT session_id
FROM mt_session
WHERE (session_kind = 'US') AND (session_id = 'pzwjvV81hDYyBa7Z9TInLQAxuOvNaOTvzNgzx1kJ')
LIMIT 1
;
SELECT session_id, session_data, session_email, session_kind, session_name, session_start
FROM mt_session
WHERE (session_id IN ('pzwjvV81hDYyBa7Z9TInLQAxuOvNaOTvzNgzx1kJ'))
;
SELECT session_id
FROM mt_session
WHERE (session_kind = 'UA') AND (session_name = '1')
LIMIT 1
;
SELECT session_id, session_data, session_email, session_kind, session_name, session_start
FROM mt_session
WHERE (session_id IN ('h7h6oHyCz4N7VneEC28xhnKFnlBMUBDlM8mgeqWq'))
;
SELECT 1 FROM mt_session
WHERE (session_id = 'h7h6oHyCz4N7VneEC28xhnKFnlBMUBDlM8mgeqWq')
;
SELECT blog_id, blog_allow_anon_comments, blog_allow_comment_html, blog_allow_commenter_regist, blog_allow_comments_default, blog_allow_pings, blog_allow_pings_default, blog_allow_reg_comments, blog_allow_unreg_comments, blog_archive_path, blog_archive_tmpl_category, blog_archive_tmpl_daily, blog_archive_tmpl_individual, blog_archive_tmpl_monthly, blog_archive_tmpl_weekly, blog_archive_type, blog_archive_type_preferred, blog_archive_url, blog_autodiscover_links, blog_autolink_urls, blog_basename_limit, blog_cc_license, blog_children_modified_on, blog_convert_paras, blog_convert_paras_comments, blog_created_by, blog_created_on, blog_custom_dynamic_templates, blog_days_on_index, blog_description, blog_email_new_comments, blog_email_new_pings, blog_entries_on_index, blog_file_extension, blog_google_api_key, blog_internal_autodiscovery, blog_is_dynamic, blog_junk_folder_expiry, blog_junk_score_threshold, blog_language, blog_manual_approve_commenters, blog_moderate_pings, blog_moderate_unreg_comments, blog_modified_by, blog_modified_on, blog_mt_update_key, blog_name, blog_old_style_archive_links, blog_ping_blogs, blog_ping_google, blog_ping_others, blog_ping_technorati, blog_ping_weblogs, blog_remote_auth_token, blog_require_comment_emails, blog_sanitize_spec, blog_server_offset, blog_site_path, blog_site_url, blog_sort_order_comments, blog_sort_order_posts, blog_status_default, blog_use_comment_confirmation, blog_welcome_msg, blog_words_in_excerpt
FROM mt_blog
WHERE (blog_id = '1')
LIMIT 1
;
SELECT permission_id
FROM mt_permission
WHERE (permission_author_id = '1') AND (permission_blog_id IN ('0','1'))
;
SELECT permission_id, permission_author_id, permission_blog_id, permission_blog_prefs, permission_created_by, permission_created_on, permission_entry_prefs, permission_modified_by, permission_modified_on, permission_permissions, permission_restrictions, permission_role_mask, permission_template_prefs
FROM mt_permission
WHERE (permission_id IN ('1','2'))
;
SELECT permission_id
FROM mt_permission
WHERE (permission_author_id = '1') AND (permission_blog_id = '0')
;
SELECT template_id
FROM mt_template
WHERE (template_type = 'index') AND (template_blog_id = '1')
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('7','8','12','27','37','40','44'))
;
SELECT fileinfo_id, fileinfo_archive_type, fileinfo_author_id, fileinfo_blog_id, fileinfo_category_id, fileinfo_entry_id, fileinfo_file_path, fileinfo_startdate, fileinfo_template_id, fileinfo_templatemap_id, fileinfo_url, fileinfo_virtual
FROM mt_fileinfo
WHERE (fileinfo_template_id = '7') AND (fileinfo_blog_id = '1')
;
SELECT field_id
FROM mt_field
;
SELECT blog_meta_blog_id, blog_meta_type, blog_meta_vchar, blog_meta_vchar_idx, blog_meta_vdatetime, blog_meta_vdatetime_idx, blog_meta_vinteger, blog_meta_vinteger_idx, blog_meta_vfloat, blog_meta_vfloat_idx, blog_meta_vblob, blog_meta_vclob
FROM mt_blog_meta
WHERE (blog_meta_blog_id = '1')
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '7')
;
SELECT fileinfo_id, fileinfo_archive_type, fileinfo_author_id, fileinfo_blog_id, fileinfo_category_id, fileinfo_entry_id, fileinfo_file_path, fileinfo_startdate, fileinfo_template_id, fileinfo_templatemap_id, fileinfo_url, fileinfo_virtual
FROM mt_fileinfo
WHERE (fileinfo_template_id = '8') AND (fileinfo_blog_id = '1')
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '8')
;
SELECT fileinfo_id, fileinfo_archive_type, fileinfo_author_id, fileinfo_blog_id, fileinfo_category_id, fileinfo_entry_id, fileinfo_file_path, fileinfo_startdate, fileinfo_template_id, fileinfo_templatemap_id, fileinfo_url, fileinfo_virtual
FROM mt_fileinfo
WHERE (fileinfo_template_id = '12') AND (fileinfo_blog_id = '1')
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '12')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'feed_recent') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT entry_id
FROM mt_entry
WHERE (entry_status = '2') AND (entry_blog_id = '1') AND (entry_class = 'entry')
ORDER BY entry_authored_on DESC
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id IN ('1263'))
;
SELECT entry_id
FROM mt_entry
WHERE (entry_status = '2') AND (entry_blog_id = '1') AND (entry_class = 'entry')
ORDER BY entry_authored_on DESC
LIMIT 15
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id IN ('1262','1261','1260','1259','1258','1257','1256','1255','1254','1253','1252','1251','1250','1249'))
;
SELECT templatemap_id, templatemap_archive_type, templatemap_blog_id, templatemap_build_interval, templatemap_build_type, templatemap_file_template, templatemap_is_preferred, templatemap_template_id
FROM mt_templatemap
WHERE (templatemap_is_preferred = '1') AND (templatemap_archive_type = 'Individual') AND (templatemap_blog_id = '1')
LIMIT 1
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1263')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('16'))
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1263') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1262')
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1262') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1261')
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1261') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1260')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('4'))
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1260') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1259')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('1','3'))
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1259') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1258')
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1258') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1257')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('34'))
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1257') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1256')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('31'))
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1256') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1255')
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1255') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1254')
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1254') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1253')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('28'))
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1253') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1252')
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1252') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1251')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('2'))
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1251') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1250')
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1250') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1249')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('11'))
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (objecttag_object_id = '1249') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT fileinfo_id, fileinfo_archive_type, fileinfo_author_id, fileinfo_blog_id, fileinfo_category_id, fileinfo_entry_id, fileinfo_file_path, fileinfo_startdate, fileinfo_template_id, fileinfo_templatemap_id, fileinfo_url, fileinfo_virtual
FROM mt_fileinfo
WHERE (fileinfo_template_id = '27') AND (fileinfo_blog_id = '1')
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '27')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'ヘッダー') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('76'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '76')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'styles') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'feed_recent') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'javascript') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('37'))
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'ナビゲーション') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('71'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '71')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'main_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('44'))
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'archive_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('40'))
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'サインイン') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('55'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '55')
;
SELECT template_id
FROM mt_template
WHERE (template_name = '検索') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('59'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '59')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'ブログ記事フォーム') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('29'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '29')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'フォームフィールド') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('77'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '77')
;
SELECT COUNT(*)
FROM mt_category
WHERE (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '0') AND (category_class = 'category') AND (category_blog_id = '1')
ORDER BY category_label ASC
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id IN ('36','8','15','10','23','37','26','9','20','12','29','17','39','5','21','32','18','24','19','35','30','38','27','33','6','22','14','7','13','25','40'))
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '36') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '8') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '15') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '10') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '23') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '37') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '3') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '26') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '34') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '9') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '11') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '20') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '12') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '29') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '17') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '39') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '5') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '21') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '32') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '18') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '24') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '16') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '19') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '35') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '30') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '38') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '27') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '2') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '28') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '33') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '6') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '22') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '31') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '14') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '7') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '1') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '13') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '25') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '4') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '40') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT field_id
FROM mt_field
WHERE (field_blog_id IN ('1','0')) AND (field_obj_type = 'entry')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'フッター') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('61'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '61')
;
SELECT fileinfo_id, fileinfo_archive_type, fileinfo_author_id, fileinfo_blog_id, fileinfo_category_id, fileinfo_entry_id, fileinfo_file_path, fileinfo_startdate, fileinfo_template_id, fileinfo_templatemap_id, fileinfo_url, fileinfo_virtual
FROM mt_fileinfo
WHERE (fileinfo_template_id = '37') AND (fileinfo_blog_id = '1')
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '37')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'GlobalJavaScript') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('52'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '52')
;
SELECT blog_id, blog_allow_anon_comments, blog_allow_comment_html, blog_allow_commenter_regist, blog_allow_comments_default, blog_allow_pings, blog_allow_pings_default, blog_allow_reg_comments, blog_allow_unreg_comments, blog_archive_path, blog_archive_tmpl_category, blog_archive_tmpl_daily, blog_archive_tmpl_individual, blog_archive_tmpl_monthly, blog_archive_tmpl_weekly, blog_archive_type, blog_archive_type_preferred, blog_archive_url, blog_autodiscover_links, blog_autolink_urls, blog_basename_limit, blog_cc_license, blog_children_modified_on, blog_convert_paras, blog_convert_paras_comments, blog_created_by, blog_created_on, blog_custom_dynamic_templates, blog_days_on_index, blog_description, blog_email_new_comments, blog_email_new_pings, blog_entries_on_index, blog_file_extension, blog_google_api_key, blog_internal_autodiscovery, blog_is_dynamic, blog_junk_folder_expiry, blog_junk_score_threshold, blog_language, blog_manual_approve_commenters, blog_moderate_pings, blog_moderate_unreg_comments, blog_modified_by, blog_modified_on, blog_mt_update_key, blog_name, blog_old_style_archive_links, blog_ping_blogs, blog_ping_google, blog_ping_others, blog_ping_technorati, blog_ping_weblogs, blog_remote_auth_token, blog_require_comment_emails, blog_sanitize_spec, blog_server_offset, blog_site_path, blog_site_url, blog_sort_order_comments, blog_sort_order_posts, blog_status_default, blog_use_comment_confirmation, blog_welcome_msg, blog_words_in_excerpt
FROM mt_blog
WHERE (blog_id = '1')
LIMIT 1
;
SELECT blog_meta_blog_id, blog_meta_type, blog_meta_vchar, blog_meta_vchar_idx, blog_meta_vdatetime, blog_meta_vdatetime_idx, blog_meta_vinteger, blog_meta_vinteger_idx, blog_meta_vfloat, blog_meta_vfloat_idx, blog_meta_vblob, blog_meta_vclob
FROM mt_blog_meta
WHERE (blog_meta_blog_id = '1')
;
SELECT fileinfo_id, fileinfo_archive_type, fileinfo_author_id, fileinfo_blog_id, fileinfo_category_id, fileinfo_entry_id, fileinfo_file_path, fileinfo_startdate, fileinfo_template_id, fileinfo_templatemap_id, fileinfo_url, fileinfo_virtual
FROM mt_fileinfo
WHERE (fileinfo_template_id = '40') AND (fileinfo_blog_id = '1')
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '40')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'styles') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'feed_recent') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'javascript') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'main_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'archive_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1')
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT templatemap_id, templatemap_archive_type, templatemap_blog_id, templatemap_build_interval, templatemap_build_type, templatemap_file_template, templatemap_is_preferred, templatemap_template_id
FROM mt_templatemap
WHERE (templatemap_is_preferred = '1') AND (templatemap_archive_type = 'Monthly') AND (templatemap_blog_id = '1')
LIMIT 1
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '0') AND (category_class = 'category') AND (category_blog_id = '1')
ORDER BY category_label ASC
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '36') AND (entry_id = placement_entry_id)
;
SELECT templatemap_id, templatemap_archive_type, templatemap_blog_id, templatemap_build_interval, templatemap_build_type, templatemap_file_template, templatemap_is_preferred, templatemap_template_id
FROM mt_templatemap
WHERE (templatemap_is_preferred = '1') AND (templatemap_archive_type = 'Category') AND (templatemap_blog_id = '1')
LIMIT 1
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '8') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '15') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '10') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '23') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '37') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '3') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '26') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '34') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '9') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '11') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '20') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '12') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '29') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '17') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '39') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '5') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '21') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '32') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '18') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '24') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '16') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '19') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '35') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '30') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '38') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '27') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '2') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '28') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '33') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '6') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '22') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '31') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '14') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '7') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '1') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '13') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '25') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '4') AND (entry_id = placement_entry_id)
;
SELECT COUNT(*)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '40') AND (entry_id = placement_entry_id)
;
SELECT category_id
FROM mt_category
WHERE (category_class = 'category') AND (category_blog_id = '1')
ORDER BY category_label ASC
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '36') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '8') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '15') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '10') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '23') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '37') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '3') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '26') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '34') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '9') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '11') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '20') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '12') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '29') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '17') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '39') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '5') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '21') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '32') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '18') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '24') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '16') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '19') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '35') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '30') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '38') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '27') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '2') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '28') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '33') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '6') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '22') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '31') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '14') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '7') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '1') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '13') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '25') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '4') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry, mt_placement
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (placement_category_id = '40') AND (entry_id = placement_entry_id)
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT templatemap_id, templatemap_archive_type, templatemap_blog_id, templatemap_build_interval, templatemap_build_type, templatemap_file_template, templatemap_is_preferred, templatemap_template_id
FROM mt_templatemap
WHERE (templatemap_is_preferred = '1') AND (templatemap_archive_type = 'Category-Monthly') AND (templatemap_blog_id = '1')
LIMIT 1
;
SELECT DISTINCT author_id, author_name
FROM mt_author, mt_entry
WHERE (entry_status = '2') AND (entry_blog_id = '1') AND (author_id = entry_author_id)
ORDER BY author_name ASC
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry
WHERE (entry_author_id = '1') AND (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1')
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT templatemap_id, templatemap_archive_type, templatemap_blog_id, templatemap_build_interval, templatemap_build_type, templatemap_file_template, templatemap_is_preferred, templatemap_template_id
FROM mt_templatemap
WHERE (templatemap_is_preferred = '1') AND (templatemap_archive_type = 'Author-Monthly') AND (templatemap_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'コンテンツのナビゲーション') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('10'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '10')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'entry_create') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'main_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'サイドバー') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('20'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '20')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'アーカイブウィジェット') AND (template_blog_id IN ('0','1')) AND (template_type = 'widgetset')
LIMIT 1
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('46'))
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'アーカイブウィジェットグループ') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('34'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '34')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'カテゴリアーカイブ') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('14'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '14')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '0') AND (category_class = 'category') AND (category_blog_id = '1')
ORDER BY category_label ASC
;
SELECT template_id
FROM mt_template
WHERE (template_name = '月別アーカイブ') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('15'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '15')
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1')
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'archive_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'ページ一覧') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('19'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '19')
;
SELECT COUNT(*)
FROM mt_entry
WHERE (entry_status = '2') AND (entry_class = 'page') AND (entry_blog_id = '1')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'OpenID対応') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('26'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '26')
;
SELECT template_id
FROM mt_template
WHERE (template_name = '購読') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('36'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '36')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'feed_recent') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'アクティビティウィジェット') AND (template_blog_id IN ('0','1')) AND (template_type = 'widgetset')
LIMIT 1
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('45'))
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'ホームページウィジェットグループ') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('41'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '41')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'About') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('25'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '25')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'archive_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT fileinfo_id, fileinfo_archive_type, fileinfo_author_id, fileinfo_blog_id, fileinfo_category_id, fileinfo_entry_id, fileinfo_file_path, fileinfo_startdate, fileinfo_template_id, fileinfo_templatemap_id, fileinfo_url, fileinfo_virtual
FROM mt_fileinfo
WHERE (fileinfo_template_id = '44') AND (fileinfo_blog_id = '1')
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '44')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'rsd') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'styles') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'feed_recent') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'javascript') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'main_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'archive_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT entry_id
FROM mt_entry
WHERE (entry_status = '2') AND (entry_blog_id = '1') AND (entry_class = 'entry')
ORDER BY entry_authored_on DESC
LIMIT 10
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'ブログ記事の概要') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('2'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '2')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1263')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1261'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1263')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '16')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'ブログ記事のメタデータ') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('33'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '33')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'プロフィール画像') AND (template_type = 'custom') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('73'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '73')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1263')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1263')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1262')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1260'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1262')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '16')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1262')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1262')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1261')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1259'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1261')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '16')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1261')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1261')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1260')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1258'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1260')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '4')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1260')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1260')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1259')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1257'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1259')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '1')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1259')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1259')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1258')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1256'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1258')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '4')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1258')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1258')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1257')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1255'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1257')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '34')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1257')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1257')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1256')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1254'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1256')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '3')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1256')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1256')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1255')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1253'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1255')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '3')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1255')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1255')
;
SELECT trackback_id
FROM mt_trackback
WHERE (trackback_entry_id = '1254')
LIMIT 1
;
SELECT trackback_id, trackback_blog_id, trackback_category_id, trackback_created_by, trackback_created_on, trackback_description, trackback_entry_id, trackback_is_disabled, trackback_modified_by, trackback_modified_on, trackback_passphrase, trackback_rss_file, trackback_title, trackback_url
FROM mt_trackback
WHERE (trackback_id IN ('1252'))
;
SELECT placement_id, placement_blog_id, placement_category_id, placement_entry_id, placement_is_primary
FROM mt_placement
WHERE (placement_entry_id = '1254')
;
SELECT category_id, category_allow_pings, category_author_id, category_basename, category_blog_id, category_class, category_created_by, category_created_on, category_description, category_label, category_modified_by, category_modified_on, category_parent, category_ping_urls
FROM mt_category
WHERE (category_id = '3')
LIMIT 1
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1254')
;
SELECT objectscore_id
FROM mt_objectscore
WHERE (objectscore_object_ds = 'entry') AND (objectscore_namespace = 'community_pack_recommend') AND (objectscore_object_id = '1254')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'entry_create') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'archive_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'アーカイブウィジェット') AND (template_blog_id IN ('0','1')) AND (template_type = 'widgetset')
LIMIT 1
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '0') AND (category_class = 'category') AND (category_blog_id = '1')
ORDER BY category_label ASC
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '3') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '34') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '16') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '1') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT category_id
FROM mt_category
WHERE (category_parent = '4') AND (category_class = 'category') AND (category_blog_id = '1')
;
SELECT COUNT(*), extract(year from entry_authored_on), extract(month from entry_authored_on)
FROM mt_entry
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1')
GROUP BY extract(year from entry_authored_on), extract(month from entry_authored_on)
ORDER BY extract(year from entry_authored_on) desc, extract(month from entry_authored_on) desc
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'archive_index') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT COUNT(*)
FROM mt_entry
WHERE (entry_status = '2') AND (entry_class = 'page') AND (entry_blog_id = '1')
;
SELECT template_id
FROM mt_template
WHERE (template_identifier = 'feed_recent') AND (template_type = 'index') AND (template_blog_id = '1')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'アクティビティウィジェット') AND (template_blog_id IN ('0','1')) AND (template_type = 'widgetset')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = '最近のコメント') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('43'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '43')
;
SELECT COUNT(*)
FROM mt_comment
WHERE (comment_visible = '1') AND (comment_blog_id = '1')
;
SELECT DISTINCT comment_id, comment_created_on
FROM mt_comment, mt_entry
WHERE (comment_visible = '1') AND (comment_blog_id = '1') AND (entry_status = '2') AND (entry_id =comment_entry_id)
ORDER BY comment_created_on DESC
LIMIT 10
;
SELECT comment_id, comment_author, comment_blog_id, comment_commenter_id, comment_created_by, comment_created_on, comment_email, comment_entry_id, comment_ip, comment_junk_log, comment_junk_score, comment_junk_status, comment_last_moved_on, comment_modified_by, comment_modified_on, comment_parent_id, comment_text, comment_url, comment_visible
FROM mt_comment
WHERE (comment_id IN ('37','36','35','34','33','32','31','30','29','28'))
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '1235')
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '1199')
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '1154')
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '1130')
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '1083')
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '1066')
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '1064')
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '1061')
LIMIT 1
;
SELECT entry_id, entry_allow_comments, entry_allow_pings, entry_atom_id, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_category_id, entry_class, entry_comment_count, entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_keywords, entry_modified_by, entry_modified_on, entry_ping_count, entry_pinged_urls, entry_status, entry_tangent_cache, entry_template_id, entry_text, entry_text_more, entry_title, entry_to_ping_urls, entry_week_number
FROM mt_entry
WHERE (entry_id = '988')
LIMIT 1
;
SELECT template_id
FROM mt_template
WHERE (template_name = '最近のブログ記事') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('18'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '18')
;
SELECT COUNT(*)
FROM mt_entry
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1')
;
SELECT entry_id
FROM mt_entry
WHERE (entry_status = '2') AND (entry_blog_id = '1') AND (entry_class = 'entry')
ORDER BY entry_authored_on DESC
LIMIT 10
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'アイテム') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('6'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '6')
;
SELECT COUNT(*)
FROM mt_asset
WHERE (asset_blog_id = '1')
;
SELECT template_id
FROM mt_template
WHERE (template_name = 'タグクラウド') AND (template_type = 'widget') AND (template_blog_id IN ('1','0'))
ORDER BY template_blog_id DESC
;
SELECT template_id, template_blog_id, template_build_dynamic, template_build_interval, template_build_type, template_created_by, template_created_on, template_identifier, template_linked_file, template_linked_file_mtime, template_linked_file_size, template_modified_by, template_modified_on, template_name, template_outfile, template_rebuild_me, template_text, template_type
FROM mt_template
WHERE (template_id IN ('17'))
;
SELECT template_meta_template_id, template_meta_type, template_meta_vchar, template_meta_vchar_idx, template_meta_vdatetime, template_meta_vdatetime_idx, template_meta_vinteger, template_meta_vinteger_idx, template_meta_vfloat, template_meta_vfloat_idx, template_meta_vblob, template_meta_vclob
FROM mt_template_meta
WHERE (template_meta_template_id = '17')
;
SELECT DISTINCT tag_id, tag_name
FROM mt_tag, mt_objecttag
WHERE (tag_is_private = '0') AND (objecttag_blog_id = '1') AND (objecttag_object_datasource = 'entry') AND (tag_id = objecttag_tag_id)
ORDER BY tag_name ASC
;
SELECT COUNT(*), objecttag_tag_id
FROM mt_entry, mt_objecttag
WHERE (entry_status = '2') AND (entry_class = 'entry') AND (entry_blog_id = '1') AND (objecttag_blog_id = '1') AND (objecttag_object_datasource = 'entry') AND (entry_id = objecttag_object_id)
GROUP BY objecttag_tag_id
;
SELECT author_meta_author_id, author_meta_type, author_meta_vchar, author_meta_vchar_idx, author_meta_vdatetime, author_meta_vdatetime_idx, author_meta_vinteger, author_meta_vinteger_idx, author_meta_vfloat, author_meta_vfloat_idx, author_meta_vblob, author_meta_vclob
FROM mt_author_meta
WHERE (author_meta_author_id = '1')
;
SELECT blog_id
FROM mt_blog, mt_permission
WHERE (permission_author_id = '1') AND (permission_permissions != '\'comment\'') AND (blog_id = permission_blog_id)
LIMIT 11
;
SELECT COUNT(*)
FROM mt_blog
;
SELECT config_id
FROM mt_config
LIMIT 1
;
SELECT config_id, config_data
FROM mt_config
WHERE (config_id IN ('1'))
;
SELECT 1 FROM mt_config
WHERE (config_id = '1')
;