0.5269 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'ninja_forms_oauth_client_id'
LIMIT 1
|
0.4380 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'ninja_forms_db_version'
LIMIT 1
|
0.3901 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'nf_sub_expiration'
LIMIT 1
|
0.4082 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-revisions-retention-enabled'
LIMIT 1
|
0.3879 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-revisions-retention-count'
LIMIT 1
|
0.5538 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-logging'
LIMIT 1
|
0.5081 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-logging-additional'
LIMIT 1
|
0.4480 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-compression_server'
LIMIT 1
|
0.4430 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-show_smush_metabox'
LIMIT 1
|
0.4418 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-webp_conversion'
LIMIT 1
|
0.3910 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'redux_pro_license_key'
LIMIT 1
|
0.5200 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'carousel_slider_settings'
LIMIT 1
|
0.4792 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'medium_crop'
LIMIT 1
|
0.4530 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'medium_large_crop'
LIMIT 1
|
0.4370 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'large_crop'
LIMIT 1
|
0.5059 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_activation_timestamp'
LIMIT 1
|
0.3550 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_notice_enable_notify_timestamp'
LIMIT 1
|
0.3550 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_show_warning_badge'
LIMIT 1
|
1.1070 |
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
|
0.5870 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (173)
|
2.7800 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (173)
ORDER BY meta_id ASC
|
0.5009 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'can_compress_scripts'
LIMIT 1
|
0.3650 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'litespeed.placeholder._summary'
LIMIT 1
|
0.4220 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gf_previous_db_version'
LIMIT 1
|
0.4439 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'rg_form_version'
LIMIT 1
|
0.3660 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gf_db_version'
LIMIT 1
|
0.6070 |
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.2968 |
SELECT FOUND_ROWS()
|
0.6769 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (5,271)
|
1.0481 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (5,271)
ORDER BY meta_id ASC
|
0.7188 |
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
|
0.4971 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (3553)
|
1.6489 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3553)
ORDER BY meta_id ASC
|
0.3619 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_imagify_activation'
LIMIT 1
|
0.3529 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_imagify_activation'
LIMIT 1
|
0.3388 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_less_version'
LIMIT 1
|
0.3669 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'vc_automapped_shortcodes'
LIMIT 1
|
0.8581 |
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.6900 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
LIMIT 1
|
0.4182 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
0.7739 |
SHOW FULL COLUMNS
FROM `wp_trfjh19zpf_options`
|
1.2240 |
DELETE
FROM `wp_trfjh19zpf_options`
WHERE `option_name` = '_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
0.5040 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
1.0281 |
DELETE
FROM `wp_trfjh19zpf_options`
WHERE `option_name` = '_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
0.8659 |
SELECT form_id, count(id) as entry_count
FROM wp_trfjh19zpf_gf_entry l
WHERE status='active'
GROUP BY form_id
|
0.4690 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
LIMIT 1
|
0.4301 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
LIMIT 1
|
1.0591 |
INSERT INTO `wp_trfjh19zpf_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29', '1679799522', 'no')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
0.8910 |
INSERT INTO `wp_trfjh19zpf_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29', 'a:0:{}', 'no')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
0.4802 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd'
LIMIT 1
|
0.4380 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
1.0791 |
DELETE
FROM `wp_trfjh19zpf_options`
WHERE `option_name` = '_transient_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
0.4730 |
SELECT autoload
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
1.0080 |
DELETE
FROM `wp_trfjh19zpf_options`
WHERE `option_name` = '_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
0.8209 |
SELECT form_id, sum(count) as view_count
FROM wp_trfjh19zpf_gf_form_view
GROUP BY form_id
|
0.4642 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_GFCache_90376ec811243f83cec12e79a99ba3fd'
LIMIT 1
|
0.4492 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd'
LIMIT 1
|
1.1659 |
INSERT INTO `wp_trfjh19zpf_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd', '1679799522', 'no')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
0.9491 |
INSERT INTO `wp_trfjh19zpf_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_GFCache_90376ec811243f83cec12e79a99ba3fd', 'a:0:{}', 'no')
ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
|
1.0509 |
UPDATE `wp_trfjh19zpf_options`
SET `option_value` = '1679799492.6766560077667236328125'
WHERE `option_name` = '_transient_doing_cron'
|
1.1570 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE 1=1
AND wp_trfjh19zpf_posts.post_name = 'backstreetgirls'
AND wp_trfjh19zpf_posts.post_type = 'portfolio'
ORDER BY wp_trfjh19zpf_posts.post_date DESC
|
0.6781 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (4315)
|
2.2769 |
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 (4315)
ORDER BY t.name ASC
|
0.7811 |
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 (117,122)
|
1.3239 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4315)
ORDER BY meta_id ASC
|
0.4780 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_use_custom'
LIMIT 1
|
0.5751 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'auto_update_redux_google_fonts'
LIMIT 1
|
1.0450 |
SELECT *
FROM wp_trfjh19zpf_users
WHERE ID = '11'
LIMIT 1
|
1.3640 |
SELECT user_id, meta_key, meta_value
FROM wp_trfjh19zpf_usermeta
WHERE user_id IN (11)
ORDER BY umeta_id ASC
|
5.1570 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_id` = '4315'
AND `object_type` = 'post'
LIMIT 1
|
0.5500 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'https_migration_required'
LIMIT 1
|
0.6468 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4329
LIMIT 1
|
0.9470 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4329)
ORDER BY meta_id ASC
|
0.9000 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_type` = 'home-page'
LIMIT 1
|
1.3108 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_id` = '173'
AND `object_type` = 'post'
LIMIT 1
|
11.8110 |
SELECT `ancestor_id`
FROM `wp_trfjh19zpf_yoast_indexable_hierarchy`
WHERE `indexable_id` = '294'
ORDER BY `depth` DESC
|
0.4380 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_site_transient_timeout_theme_roots'
LIMIT 1
|
0.4599 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_site_transient_theme_roots'
LIMIT 1
|
0.6351 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gform_enable_toolbar_menu'
LIMIT 1
|
0.6962 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 1544
LIMIT 1
|
0.8121 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (1544)
ORDER BY meta_id ASC
|
0.4990 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'site_logo'
LIMIT 1
|
0.4821 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_not_responsive_css'
LIMIT 1
|
0.5171 |
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
|
0.9780 |
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
|
0.5369 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (550,580,582,554)
|
0.9320 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (550,554,580,582)
ORDER BY meta_id ASC
|
0.9880 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (478,128,449)
|
4.1058 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (128,449,478)
ORDER BY meta_id ASC
|
0.7820 |
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 (4315)
ORDER BY t.name ASC
|
0.8309 |
SELECT term_id, meta_key, meta_value
FROM wp_trfjh19zpf_termmeta
WHERE term_id IN (122)
ORDER BY meta_id ASC
|
0.6850 |
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 (4315)
ORDER BY t.name ASC
|
0.4320 |
SELECT term_id, meta_key, meta_value
FROM wp_trfjh19zpf_termmeta
WHERE term_id IN (117)
ORDER BY meta_id ASC
|
0.7288 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4317
LIMIT 1
|
0.9069 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4317)
ORDER BY meta_id ASC
|
0.5350 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4316
LIMIT 1
|
0.6931 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4316)
ORDER BY meta_id ASC
|
0.5350 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4318
LIMIT 1
|
0.7930 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4318)
ORDER BY meta_id ASC
|
0.4559 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4320
LIMIT 1
|
0.6421 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4320)
ORDER BY meta_id ASC
|
0.4671 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4319
LIMIT 1
|
0.6831 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4319)
ORDER BY meta_id ASC
|
0.5150 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4321
LIMIT 1
|
0.6149 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4321)
ORDER BY meta_id ASC
|
0.4921 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4322
LIMIT 1
|
0.6940 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4322)
ORDER BY meta_id ASC
|
0.5989 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4325
LIMIT 1
|
0.6840 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4325)
ORDER BY meta_id ASC
|
0.5422 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4323
LIMIT 1
|
0.6928 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4323)
ORDER BY meta_id ASC
|
0.4790 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4326
LIMIT 1
|
0.6800 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4326)
ORDER BY meta_id ASC
|
0.5851 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4324
LIMIT 1
|
0.6909 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4324)
ORDER BY meta_id ASC
|
0.4830 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4327
LIMIT 1
|
0.6740 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (4327)
ORDER BY meta_id ASC
|
0.8359 |
SELECT post_status, COUNT( * ) AS num_posts
FROM wp_trfjh19zpf_posts
WHERE post_type = 'portfolio'
GROUP BY post_status
|
0.5541 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date > '2018-11-28 12:00:01'
AND p.post_type = 'portfolio'
AND p.post_status = 'publish'
ORDER BY p.post_date ASC
LIMIT 1
|
0.5682 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3599
LIMIT 1
|
0.5860 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date < '2018-11-28 12:00:01'
AND p.post_type = 'portfolio'
AND p.post_status = 'publish'
ORDER BY p.post_date DESC
LIMIT 1
|
0.5879 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 385
LIMIT 1
|
0.6061 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date < '2018-11-28 12:00:01'
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.7379 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date > '2018-11-28 12:00:01'
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.5140 |
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
|
0.9990 |
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.5481 |
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
|