0.5569 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'litespeed.conf.object-transients'
LIMIT 1
|
0.5121 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'ninja_forms_oauth_client_id'
LIMIT 1
|
0.5062 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'ninja_forms_db_version'
LIMIT 1
|
0.4890 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'nf_sub_expiration'
LIMIT 1
|
1.4679 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-revisions-retention-enabled'
LIMIT 1
|
0.4299 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-revisions-retention-count'
LIMIT 1
|
0.4630 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-logging'
LIMIT 1
|
0.4070 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-logging-additional'
LIMIT 1
|
0.4690 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-compression_server'
LIMIT 1
|
0.4210 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-show_smush_metabox'
LIMIT 1
|
0.4570 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-webp_conversion'
LIMIT 1
|
0.4380 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'redux_pro_license_key'
LIMIT 1
|
0.4570 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'carousel_slider_settings'
LIMIT 1
|
0.4199 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'medium_crop'
LIMIT 1
|
0.4289 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'medium_large_crop'
LIMIT 1
|
0.4201 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'large_crop'
LIMIT 1
|
0.5741 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_hide_dashboard_widget'
LIMIT 1
|
0.4990 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_activation_timestamp'
LIMIT 1
|
0.4740 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_notice_enable_notify_timestamp'
LIMIT 1
|
0.4499 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_show_top_bar_menu_item'
LIMIT 1
|
0.4530 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_show_warning_badge'
LIMIT 1
|
0.4370 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_active_app'
LIMIT 1
|
4.0820 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE 1=1
AND wp_trfjh19zpf_posts.ID = 173
AND wp_trfjh19zpf_posts.post_type = 'page'
ORDER BY wp_trfjh19zpf_posts.post_date DESC
|
6.6440 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (173)
ORDER BY meta_id ASC
|
0.5500 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'litespeed.placeholder._summary'
LIMIT 1
|
0.6731 |
SELECT option_name, option_value
FROM wp_trfjh19zpf_options
WHERE option_name IN ('_site_transient_wp_theme_files_patterns-d59890635dcd572fb276898f8c470dfe','_site_transient_timeout_wp_theme_files_patterns-d59890635dcd572fb276898f8c470dfe')
|
0.4718 |
SELECT option_name, option_value
FROM wp_trfjh19zpf_options
WHERE option_name IN ('_site_transient_wp_theme_files_patterns-18f4096d37f3b291c2d5d6dae86c3fc1','_site_transient_timeout_wp_theme_files_patterns-18f4096d37f3b291c2d5d6dae86c3fc1')
|
0.5102 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'can_compress_scripts'
LIMIT 1
|
0.4292 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gf_previous_db_version'
LIMIT 1
|
0.4351 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'rg_form_version'
LIMIT 1
|
0.4029 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gf_db_version'
LIMIT 1
|
0.9911 |
SELECT SQL_CALC_FOUND_ROWS wp_trfjh19zpf_posts.ID
FROM wp_trfjh19zpf_posts
WHERE 1=1
AND wp_trfjh19zpf_posts.post_type = 'wpcf7_contact_form'
AND ((wp_trfjh19zpf_posts.post_status <> 'trash'
AND wp_trfjh19zpf_posts.post_status <> 'auto-draft'))
ORDER BY wp_trfjh19zpf_posts.ID ASC
LIMIT 0, 20
|
0.3350 |
SELECT FOUND_ROWS()
|
2.1999 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (5,271)
|
4.1940 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (5,271)
ORDER BY meta_id ASC
|
1.8342 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE 1=1
AND wp_trfjh19zpf_posts.post_type = 'carousels'
AND ((wp_trfjh19zpf_posts.post_status = 'publish'))
ORDER BY wp_trfjh19zpf_posts.post_date DESC
|
2.2180 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3553)
ORDER BY meta_id ASC
|
0.6552 |
SELECT option_name, option_value
FROM wp_trfjh19zpf_options
WHERE option_name IN ('_transient_imagify_activation','_transient_timeout_imagify_activation')
|
0.5212 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_less_version'
LIMIT 1
|
0.4082 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'vc_automapped_shortcodes'
LIMIT 1
|
2.3172 |
SELECT f.id, f.title, f.date_created, f.is_active, 0 as entry_count, 0 view_count
FROM wp_trfjh19zpf_gf_form f
WHERE is_trash=0
AND is_active=1
ORDER BY title ASC
|
0.5970 |
SELECT option_name, option_value
FROM wp_trfjh19zpf_options
WHERE option_name IN ('_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29','_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29')
|
3.7849 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
4.4470 |
SHOW FULL COLUMNS
FROM `wp_trfjh19zpf_options`
|
1.1621 |
DELETE
FROM `wp_trfjh19zpf_options`
WHERE `option_name` = '_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
0.4468 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
1.0469 |
DELETE
FROM `wp_trfjh19zpf_options`
WHERE `option_name` = '_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
2.3870 |
SELECT form_id, count(id) as entry_count
FROM wp_trfjh19zpf_gf_entry l
WHERE status='active'
GROUP BY form_id
|
1.3440 |
INSERT INTO `wp_trfjh19zpf_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29', '1737089660', 'off')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
1.0378 |
INSERT INTO `wp_trfjh19zpf_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29', 'a:0:{}', 'off')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
0.5701 |
SELECT option_name, option_value
FROM wp_trfjh19zpf_options
WHERE option_name IN ('_transient_GFCache_90376ec811243f83cec12e79a99ba3fd','_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd')
|
0.4408 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
0.9990 |
DELETE
FROM `wp_trfjh19zpf_options`
WHERE `option_name` = '_transient_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
0.3989 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
0.8030 |
DELETE
FROM `wp_trfjh19zpf_options`
WHERE `option_name` = '_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
2.2430 |
SELECT form_id, sum(count) as view_count
FROM wp_trfjh19zpf_gf_form_view
GROUP BY form_id
|
1.1270 |
INSERT INTO `wp_trfjh19zpf_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd', '1737089660', 'off')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
0.9279 |
INSERT INTO `wp_trfjh19zpf_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_GFCache_90376ec811243f83cec12e79a99ba3fd', 'a:0:{}', 'off')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
0.4830 |
SELECT option_name, option_value
FROM wp_trfjh19zpf_options
WHERE option_name IN ('_transient_timeout_doing_cron')
|
0.4129 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_doing_cron'
LIMIT 1
|
1.0269 |
UPDATE `wp_trfjh19zpf_options`
SET `option_value` = '1737089630.7401371002197265625000'
WHERE `option_name` = '_transient_doing_cron'
|
1.0641 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE 1=1
AND wp_trfjh19zpf_posts.post_name = 'citizen-kane-2'
AND wp_trfjh19zpf_posts.post_type = 'portfolio'
ORDER BY wp_trfjh19zpf_posts.post_date DESC
|
5.7242 |
SELECT DISTINCT t.term_id, tr.object_id
FROM wp_trfjh19zpf_terms AS t
INNER JOIN wp_trfjh19zpf_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN wp_trfjh19zpf_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('project-category', 'project-attribute')
AND tr.object_id IN (4510)
ORDER BY t.name ASC
|
0.7498 |
SELECT t.*, tt.*
FROM wp_trfjh19zpf_terms AS t
INNER JOIN wp_trfjh19zpf_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id IN (123,119)
|
2.0730 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4510)
ORDER BY meta_id ASC
|
0.8249 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'disabled_hit_count'
LIMIT 1
|
1.5030 |
UPDATE `wp_trfjh19zpf_options`
SET `option_value` = 'a:60:{s:10:\"2024-11-19\";i:297;s:10:\"2024-11-20\";i:269;s:10:\"2024-11-21\";i:392;s:10:\"2024-11-22\";i:387;s:10:\"2024-11-23\";i:392;s:10:\"2024-11-24\";i:568;s:10:\"2024-11-25\";i:598;s:10:\"2024-11-26\";i:414;s:10:\"2024-11-27\";i:460;s:10:\"2024-11-28\";i:467;s:10:\"2024-11-29\";i:431;s:10:\"2024-11-30\";i:422;s:10:\"2024-12-01\";i:506;s:10:\"2024-12-02\";i:413;s:10:\"2024-12-03\";i:411;s:10:\"2024-12-04\";i:429;s:10:\"2024-12-05\";i:389;s:10:\"2024-12-06\";i:368;s:10:\"2024-12-07\";i:383;s:10:\"2024-12-08\";i:367;s:10:\"2024-12-09\";i:409;s:10:\"2024-12-10\";i:359;s:10:\"2024-12-11\";i:447;s:10:\"2024-12-12\";i:434;s:10:\"2024-12-13\";i:413;s:10:\"2024-12-14\";i:434;s:10:\"2024-12-15\";i:352;s:10:\"2024-12-16\";i:343;s:10:\"2024-12-17\";i:382;s:10:\"2024-12-18\";i:348;s:10:\"2024-12-19\";i:374;s:10:\"2024-12-20\";i:687;s:10:\"2024-12-21\";i:515;s:10:\"2024-12-22\";i:395;s:10:\"2024-12-23\";i:436;s:10:\"2024-12-24\";i:484;s:10:\"2024-12-25\";i:400;s:10:\"2024-12-26\";i:451;s:10:\"2024-12-27\";i:471;s:10:\"2024-12-28\";i:475;s:10:\"2024-12-29\";i:395;s:10:\"2024-12-30\";i:407;s:10:\"2024-12-31\";i:458;s:10:\"2025-01-01\";i:424;s:10:\"2025-01-02\";i:434;s:10:\"2025-01-03\";i:422;s:10:\"2025-01-04\";i:506;s:10:\"2025-01-05\";i:447;s:10:\"2025-01-06\";i:429;s:10:\"2025-01-07\";i:400;s:10:\"2025-01-08\";i:441;s:10:\"2025-01-09\";i:424;s:10:\"2025-01-10\";i:485;s:10:\"2025-01-11\";i:403;s:10:\"2025-01-12\";i:579;s:10:\"2025-01-13\";i:545;s:10:\"2025-01-14\";i:594;s:10:\"2025-01-15\";i:420;s:10:\"2025-01-16\";i:407;s:10:\"2025-01-17\";i:88;}', `autoload` = 'on'
WHERE `option_name` = 'user_hit_count'
|
0.4849 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_use_custom'
LIMIT 1
|
0.4709 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'auto_update_redux_google_fonts'
LIMIT 1
|
3.4599 |
SELECT *
FROM wp_trfjh19zpf_users
WHERE ID = '8'
LIMIT 1
|
3.9001 |
SELECT user_id, meta_key, meta_value
FROM wp_trfjh19zpf_usermeta
WHERE user_id IN (8)
ORDER BY umeta_id ASC
|
5.8510 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_id` = '4510'
AND `object_type` = 'post'
LIMIT 1
|
0.4430 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'https_migration_required'
LIMIT 1
|
0.6309 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4512
LIMIT 1
|
0.9699 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4512)
ORDER BY meta_id ASC
|
0.9310 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_type` = 'home-page'
LIMIT 1
|
0.9592 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_id` = '173'
AND `object_type` = 'post'
LIMIT 1
|
3.9840 |
SELECT `ancestor_id`
FROM `wp_trfjh19zpf_yoast_indexable_hierarchy`
WHERE `indexable_id` = '636'
ORDER BY `depth` DESC
|
0.5779 |
SELECT option_name, option_value
FROM wp_trfjh19zpf_options
WHERE option_name IN ('_site_transient_theme_roots','_site_transient_timeout_theme_roots')
|
0.5510 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gform_enable_toolbar_menu'
LIMIT 1
|
1.0049 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 1544
LIMIT 1
|
1.4708 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (1544)
ORDER BY meta_id ASC
|
0.4539 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'site_logo'
LIMIT 1
|
0.4568 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_not_responsive_css'
LIMIT 1
|
0.6182 |
SELECT t.*, tt.*
FROM wp_trfjh19zpf_terms AS t
INNER JOIN wp_trfjh19zpf_term_taxonomy AS tt ON t.term_id = tt.term_id
WHERE t.term_id = 3
|
1.1299 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts LEFT JOIN wp_trfjh19zpf_term_relationships ON (wp_trfjh19zpf_posts.ID = wp_trfjh19zpf_term_relationships.object_id)
WHERE 1=1
AND ( wp_trfjh19zpf_term_relationships.term_taxonomy_id IN (3) )
AND wp_trfjh19zpf_posts.post_type = 'nav_menu_item'
AND ((wp_trfjh19zpf_posts.post_status = 'publish'))
GROUP BY wp_trfjh19zpf_posts.ID
ORDER BY wp_trfjh19zpf_posts.menu_order ASC
|
1.1840 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (550,580,582,554)
ORDER BY meta_id ASC
|
1.1089 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (478,128,449)
|
4.7169 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (478,128,449)
ORDER BY meta_id ASC
|
0.7401 |
SELECT DISTINCT t.term_id
FROM wp_trfjh19zpf_terms AS t
INNER JOIN wp_trfjh19zpf_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN wp_trfjh19zpf_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('project-category')
AND tr.object_id IN (4510)
ORDER BY t.name ASC
|
1.2579 |
SELECT DISTINCT t.term_id
FROM wp_trfjh19zpf_terms AS t
INNER JOIN wp_trfjh19zpf_term_taxonomy AS tt ON t.term_id = tt.term_id
INNER JOIN wp_trfjh19zpf_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN ('project-attribute')
AND tr.object_id IN (4510)
ORDER BY t.name ASC
|
0.5751 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4511
LIMIT 1
|
1.2429 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4511)
ORDER BY meta_id ASC
|
0.5100 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4515
LIMIT 1
|
1.0052 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4515)
ORDER BY meta_id ASC
|
0.6540 |
SELECT post_status, COUNT( * ) AS num_posts
FROM wp_trfjh19zpf_posts
WHERE post_type = 'portfolio'
GROUP BY post_status
|
0.5109 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date > '2002-01-07 11:52:05'
AND p.post_type = 'portfolio'
AND p.post_status = 'publish'
ORDER BY p.post_date ASC
LIMIT 1
|
0.8450 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4267
LIMIT 1
|
0.5820 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date < '2002-01-07 11:52:05'
AND p.post_type = 'portfolio'
AND p.post_status = 'publish'
ORDER BY p.post_date DESC
LIMIT 1
|
1.2760 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4486
LIMIT 1
|
0.6940 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date < '2002-01-07 11:52:05'
AND p.post_type = 'portfolio'
AND p.post_excerpt NOT like 'excludePost'
AND p.post_status = 'publish'
ORDER BY p.post_date DESC
LIMIT 1
|
0.7989 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date > '2002-01-07 11:52:05'
AND p.post_type = 'portfolio'
AND p.post_excerpt NOT like 'excludePost'
AND p.post_status = 'publish'
ORDER BY p.post_date ASC
LIMIT 1
|
0.5391 |
SELECT wp_trfjh19zpf_posts.ID
FROM wp_trfjh19zpf_posts
WHERE 1=1
AND wp_trfjh19zpf_posts.post_type = 'post'
AND ((wp_trfjh19zpf_posts.post_status = 'publish'))
ORDER BY wp_trfjh19zpf_posts.post_date DESC
LIMIT 0, 5
|
4.2171 |
SELECT wp_trfjh19zpf_comments.comment_ID
FROM wp_trfjh19zpf_comments JOIN wp_trfjh19zpf_posts ON wp_trfjh19zpf_posts.ID = wp_trfjh19zpf_comments.comment_post_ID
WHERE ( comment_approved = '1' )
AND wp_trfjh19zpf_posts.post_status IN ('publish')
ORDER BY wp_trfjh19zpf_comments.comment_date_gmt DESC
LIMIT 0,5
|
0.6900 |
SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts
FROM wp_trfjh19zpf_posts
WHERE post_type = 'post'
AND post_status = 'publish'
GROUP BY YEAR(post_date), MONTH(post_date)
ORDER BY post_date DESC
|