0.8140 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'litespeed.conf.object-transients'
LIMIT 1
|
0.3638 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'ninja_forms_oauth_client_id'
LIMIT 1
|
0.4711 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'ninja_forms_db_version'
LIMIT 1
|
0.8519 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'nf_sub_expiration'
LIMIT 1
|
1.1852 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-revisions-retention-enabled'
LIMIT 1
|
0.5741 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-revisions-retention-count'
LIMIT 1
|
0.3891 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-logging'
LIMIT 1
|
0.3371 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-logging-additional'
LIMIT 1
|
0.3669 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-compression_server'
LIMIT 1
|
0.5920 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-show_smush_metabox'
LIMIT 1
|
0.4299 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wp-optimize-webp_conversion'
LIMIT 1
|
0.3471 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'redux_pro_license_key'
LIMIT 1
|
0.5579 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'carousel_slider_settings'
LIMIT 1
|
0.5889 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'medium_crop'
LIMIT 1
|
0.3369 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'medium_large_crop'
LIMIT 1
|
0.4051 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'large_crop'
LIMIT 1
|
0.6020 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_hide_dashboard_widget'
LIMIT 1
|
0.6108 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_activation_timestamp'
LIMIT 1
|
0.4990 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_notice_enable_notify_timestamp'
LIMIT 1
|
1.5628 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_show_top_bar_menu_item'
LIMIT 1
|
1.0531 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_show_warning_badge'
LIMIT 1
|
0.5240 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'limit_login_active_app'
LIMIT 1
|
1.3530 |
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
|
3.4730 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (173)
ORDER BY meta_id ASC
|
0.6239 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'litespeed.placeholder._summary'
LIMIT 1
|
0.5591 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'can_compress_scripts'
LIMIT 1
|
0.5322 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gf_previous_db_version'
LIMIT 1
|
0.6530 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'rg_form_version'
LIMIT 1
|
0.4041 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gf_db_version'
LIMIT 1
|
0.8020 |
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.3831 |
SELECT FOUND_ROWS()
|
1.3340 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (5,271)
|
1.2660 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (5,271)
ORDER BY meta_id ASC
|
1.3268 |
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
|
1.4331 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3553)
ORDER BY meta_id ASC
|
0.4129 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_imagify_activation'
LIMIT 1
|
0.6070 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_imagify_activation'
LIMIT 1
|
0.4389 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_less_version'
LIMIT 1
|
0.6020 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'vc_automapped_shortcodes'
LIMIT 1
|
1.0839 |
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.8121 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
LIMIT 1
|
0.6390 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
LIMIT 1
|
0.6530 |
SELECT form_id, count(id) as entry_count
FROM wp_trfjh19zpf_gf_entry l
WHERE status='active'
GROUP BY form_id
|
2.4760 |
SHOW FULL COLUMNS
FROM `wp_trfjh19zpf_options`
|
1.3800 |
UPDATE `wp_trfjh19zpf_options`
SET `option_value` = '1714314205'
WHERE `option_name` = '_transient_timeout_GFCache_15126df070a4d4be31d0dfa8e1c4cc29'
|
0.4799 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd'
LIMIT 1
|
0.4251 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_transient_GFCache_90376ec811243f83cec12e79a99ba3fd'
LIMIT 1
|
0.8988 |
SELECT form_id, sum(count) as view_count
FROM wp_trfjh19zpf_gf_form_view
GROUP BY form_id
|
1.5721 |
UPDATE `wp_trfjh19zpf_options`
SET `option_value` = '1714314205'
WHERE `option_name` = '_transient_timeout_GFCache_90376ec811243f83cec12e79a99ba3fd'
|
1.6329 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE 1=1
AND wp_trfjh19zpf_posts.post_name = 'tommybahama'
AND wp_trfjh19zpf_posts.post_type = 'portfolio'
ORDER BY wp_trfjh19zpf_posts.post_date DESC
|
1.8981 |
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 (1243)
ORDER BY t.name ASC
|
0.8461 |
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 (129,121)
|
2.2929 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (1243)
ORDER BY meta_id ASC
|
0.6411 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'disabled_hit_count'
LIMIT 1
|
1.6379 |
UPDATE `wp_trfjh19zpf_options`
SET `option_value` = 'a:60:{s:10:\"2024-02-29\";i:76;s:10:\"2024-03-01\";i:56;s:10:\"2024-03-02\";i:50;s:10:\"2024-03-03\";i:26;s:10:\"2024-03-04\";i:21;s:10:\"2024-03-05\";i:39;s:10:\"2024-03-06\";i:59;s:10:\"2024-03-07\";i:154;s:10:\"2024-03-08\";i:20;s:10:\"2024-03-09\";i:95;s:10:\"2024-03-10\";i:100;s:10:\"2024-03-11\";i:10;s:10:\"2024-03-12\";i:151;s:10:\"2024-03-13\";i:57;s:10:\"2024-03-14\";i:63;s:10:\"2024-03-15\";i:87;s:10:\"2024-03-16\";i:31;s:10:\"2024-03-17\";i:39;s:10:\"2024-03-18\";i:16;s:10:\"2024-03-19\";i:93;s:10:\"2024-03-20\";i:58;s:10:\"2024-03-21\";i:78;s:10:\"2024-03-22\";i:57;s:10:\"2024-03-23\";i:52;s:10:\"2024-03-24\";i:40;s:10:\"2024-03-25\";i:140;s:10:\"2024-03-26\";i:49;s:10:\"2024-03-27\";i:132;s:10:\"2024-03-28\";i:37;s:10:\"2024-03-29\";i:96;s:10:\"2024-03-30\";i:25;s:10:\"2024-03-31\";i:115;s:10:\"2024-04-01\";i:77;s:10:\"2024-04-02\";i:78;s:10:\"2024-04-03\";i:38;s:10:\"2024-04-04\";i:80;s:10:\"2024-04-05\";i:31;s:10:\"2024-04-06\";i:89;s:10:\"2024-04-07\";i:46;s:10:\"2024-04-08\";i:141;s:10:\"2024-04-09\";i:29;s:10:\"2024-04-10\";i:79;s:10:\"2024-04-11\";i:143;s:10:\"2024-04-12\";i:93;s:10:\"2024-04-13\";i:258;s:10:\"2024-04-14\";i:81;s:10:\"2024-04-15\";i:53;s:10:\"2024-04-16\";i:96;s:10:\"2024-04-17\";i:89;s:10:\"2024-04-18\";i:43;s:10:\"2024-04-19\";i:46;s:10:\"2024-04-20\";i:64;s:10:\"2024-04-21\";i:137;s:10:\"2024-04-22\";i:144;s:10:\"2024-04-23\";i:30;s:10:\"2024-04-24\";i:57;s:10:\"2024-04-25\";i:29;s:10:\"2024-04-26\";i:40;s:10:\"2024-04-27\";i:167;s:10:\"2024-04-28\";i:71;}', `autoload` = 'yes'
WHERE `option_name` = 'user_hit_count'
|
0.3889 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_use_custom'
LIMIT 1
|
0.5569 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'auto_update_redux_google_fonts'
LIMIT 1
|
1.0972 |
SELECT *
FROM wp_trfjh19zpf_users
WHERE ID = '3'
LIMIT 1
|
2.0092 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_id` = '1243'
AND `object_type` = 'post'
LIMIT 1
|
0.4590 |
SELECT *
FROM wp_trfjh19zpf_users
WHERE ID = '3'
LIMIT 1
|
0.9251 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3299
LIMIT 1
|
1.3261 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3299)
ORDER BY meta_id ASC
|
0.4601 |
SELECT *
FROM wp_trfjh19zpf_users
WHERE ID = '3'
LIMIT 1
|
0.8991 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_type` = 'home-page'
LIMIT 1
|
1.1010 |
SELECT *
FROM `wp_trfjh19zpf_yoast_indexable`
WHERE `object_id` = '173'
AND `object_type` = 'post'
LIMIT 1
|
0.8180 |
SELECT `ancestor_id`
FROM `wp_trfjh19zpf_yoast_indexable_hierarchy`
WHERE `indexable_id` = '602'
ORDER BY `depth` DESC
|
0.5059 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_site_transient_timeout_theme_roots'
LIMIT 1
|
0.4501 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = '_site_transient_theme_roots'
LIMIT 1
|
0.5300 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'gform_enable_toolbar_menu'
LIMIT 1
|
3.2730 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 1544
LIMIT 1
|
13.2420 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (1544)
ORDER BY meta_id ASC
|
0.5801 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'https_migration_required'
LIMIT 1
|
0.4311 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'site_logo'
LIMIT 1
|
0.5310 |
SELECT option_value
FROM wp_trfjh19zpf_options
WHERE option_name = 'wpb_js_not_responsive_css'
LIMIT 1
|
0.6049 |
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.4780 |
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.9691 |
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.4338 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE ID IN (478,128,449)
|
7.8568 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (478,128,449)
ORDER BY meta_id ASC
|
1.0781 |
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 (1243)
ORDER BY t.name ASC
|
0.7560 |
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 (1243)
ORDER BY t.name ASC
|
0.5462 |
SELECT *
FROM wp_trfjh19zpf_users
WHERE ID = '3'
LIMIT 1
|
0.9170 |
SELECT user_id, meta_key, meta_value
FROM wp_trfjh19zpf_usermeta
WHERE user_id IN (3)
ORDER BY umeta_id ASC
|
0.4330 |
SELECT *
FROM wp_trfjh19zpf_users
WHERE ID IN (3)
|
0.4110 |
SELECT *
FROM wp_trfjh19zpf_users
WHERE ID = '3'
LIMIT 1
|
1.0500 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3456
LIMIT 1
|
1.1261 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3456)
ORDER BY meta_id ASC
|
0.6852 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3461
LIMIT 1
|
0.7489 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3461)
ORDER BY meta_id ASC
|
0.5200 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3460
LIMIT 1
|
0.7670 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3460)
ORDER BY meta_id ASC
|
0.5140 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3459
LIMIT 1
|
0.6902 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3459)
ORDER BY meta_id ASC
|
0.6628 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3458
LIMIT 1
|
0.6690 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3458)
ORDER BY meta_id ASC
|
0.4959 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3457
LIMIT 1
|
1.0180 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3457)
ORDER BY meta_id ASC
|
1.6739 |
SELECT wp_trfjh19zpf_posts.*
FROM wp_trfjh19zpf_posts
WHERE 1=1
AND wp_trfjh19zpf_posts.post_name = '2ca0885c47e2fcd74e8e0980e9e9b1a5'
AND wp_trfjh19zpf_posts.post_type = 'oembed_cache'
AND ((wp_trfjh19zpf_posts.post_status = 'publish'))
ORDER BY wp_trfjh19zpf_posts.post_date DESC
|
0.8221 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3463
LIMIT 1
|
0.9189 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3463)
ORDER BY meta_id ASC
|
0.9880 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3470
LIMIT 1
|
1.5411 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3470)
ORDER BY meta_id ASC
|
0.7770 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3471
LIMIT 1
|
0.9301 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3471)
ORDER BY meta_id ASC
|
0.7689 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3472
LIMIT 1
|
0.6649 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3472)
ORDER BY meta_id ASC
|
0.4802 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 3473
LIMIT 1
|
0.9458 |
SELECT post_id, meta_key, meta_value
FROM wp_trfjh19zpf_postmeta
WHERE post_id IN (3473)
ORDER BY meta_id ASC
|
0.5720 |
SELECT post_status, COUNT( * ) AS num_posts
FROM wp_trfjh19zpf_posts
WHERE post_type = 'portfolio'
GROUP BY post_status
|
0.5231 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date > '2014-01-03 10:19:01'
AND p.post_type = 'portfolio'
AND p.post_status = 'publish'
ORDER BY p.post_date ASC
LIMIT 1
|
1.3471 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4245
LIMIT 1
|
0.5779 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date < '2014-01-03 10:19:01'
AND p.post_type = 'portfolio'
AND p.post_status = 'publish'
ORDER BY p.post_date DESC
LIMIT 1
|
0.5341 |
SELECT *
FROM wp_trfjh19zpf_posts
WHERE ID = 4262
LIMIT 1
|
0.6189 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date < '2014-01-03 10:19: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.6459 |
SELECT p.ID
FROM wp_trfjh19zpf_posts AS p
WHERE p.post_date > '2014-01-03 10:19: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.5188 |
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.8130 |
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.6480 |
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
|