The disastrous effect of social inequality on health and social stability

Posted on March 28, 2012 by Eli Scheetz

Richard Wilkinson, Professor Emeritus of Social Epidemiology at the University of Nottingham, presented huge amounts of evidence in his book The Spirit Level (co-authored with Kate Pickett) about the disastrous effect of social inequality on health and social stability. This video of his TED Talk gives a summary of some of that research.

Now available in the WordPress Repository

Posted on March 26, 2012 by Eli Scheetz

I just released my new Anti-Malware plugin for WordPress. It is still in BETA but I think it will be very helpful in removing malicious scripts and patching security vulnerabilities.

An example scan that found some threats

Please leave feedback and donate whenever possible.

Download of GOTMLS from WordPress.org

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/2012/03/', 'CONTEXT_DOCUMENT_ROOT' => '/home/elijah/sites/wordpress.ieonly.com/public_html', 'CONTEXT_PREFIX' => '', 'DOCUMENT_ROOT' => '/home/elijah/sites/wordpress.ieonly.com/public_html', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'HTTP_ACCEPT' => '*/*', 'HTTP_AUTHORIZATION' => '', 'HTTP_HOST' => 'wordpress.ieonly.com', 'HTTP_USER_AGENT' => 'claudebot', 'PATH' => '/bin', 'PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins', 'QUERY_STRING' => '', 'REDIRECT_HTTP_AUTHORIZATION' => '', 'REDIRECT_PERL5LIB' => '/usr/share/awstats/lib:/usr/share/awstats/plugins', 'REDIRECT_STATUS' => '200', 'REDIRECT_UNIQUE_ID' => 'ZiFHfH1IqmWDuODW4cw-QwAAAI8', 'REDIRECT_URL' => '/2012/03/', 'REMOTE_ADDR' => '3.135.195.249', 'REMOTE_PORT' => '1936', 'REQUEST_METHOD' => 'GET', 'REQUEST_SCHEME' => 'http', 'SCRIPT_FILENAME' => '/home/elijah/sites/wordpress.ieonly.com/public_html/index.php', 'SCRIPT_NAME' => '/index.php', 'SERVER_ADDR' => '158.69.23.200', 'SERVER_ADMIN' => 'root@localhost', 'SERVER_NAME' => 'wordpress.ieonly.com', 'SERVER_PORT' => '80', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'SERVER_SIGNATURE' => '', 'UNIQUE_ID' => 'ZiFHfH1IqmWDuODW4cw-QwAAAI8', 'dont_vary' => '1', 'no_gzip' => '1', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1713457020.574747, 'REQUEST_TIME' => 1713457020, );

SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'patterns_ai_data' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 1;

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ( ( YEAR( wp_posts.post_date ) = 2012 AND MONTH( wp_posts.post_date ) = 3 ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 10;

SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (271, 286, 280, 276) ORDER BY t.name ASC ;

INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2024-04', 64909, 44284, 16079, 3179, '2024-04-18 16:17:01', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2024-04-18 16:17:01', wp_user = 0, hit_count = hit_count + 1;

SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (108) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC ;

SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (271) ORDER BY t.name ASC ;

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC ;

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ( ( YEAR( wp_posts.post_date ) = 2023 AND MONTH( wp_posts.post_date ) = 4 ) ) AND ( YEAR( wp_posts.post_date ) < 2024 ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date ASC LIMIT 0, 15;

SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category') AND t.term_id IN ( 43 ) AND tt.count > 0 ORDER BY t.name ASC ;

SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 43 ) AND taxonomy = 'link_category' ORDER BY link_name ASC;

Profiler Initiaded	0.0000 ms	38679 kB
Profiler Noise	0.0041 ms	38679 kB
Profiler Stopped	460.7830 ms	111976 kB

0.2441 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;`
0.1440 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;`
0.2439 [ms]	SELECT * FROM `wp_posts` WHERE post_type = 'gotmls_results' AND post_name = '69051547193c68dc1fbda50c8ac38981';
0.2432 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;`
0.1471 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;`
0.2239 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_default_handler' LIMIT 1;`
0.1519 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_level_threshold' LIMIT 1;`
0.1040 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_data_sync_enabled' LIMIT 1;`
0.0751 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_background_sync_mode' LIMIT 1;`
0.0942 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wc_installing' LIMIT 1;`
0.0720 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wc_installing' LIMIT 1;`
0.1199 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_feature_marketplace_enabled' LIMIT 1;`
0.1991 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_check_subscriptions_eligibility_after_onboarding' LIMIT 1;`
0.1130 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;`
0.0958 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;`
0.0911 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;`
0.0911 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'has_jetpack_search_product' LIMIT 1;`
0.1121 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'instant_search_enabled' LIMIT 1;`
0.0901 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_blocks_disabled' LIMIT 1;`
0.0892 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;`
0.0839 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;`
0.0958 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;`
0.2139 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;`
0.1211 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;`
0.1371 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;`
0.1259 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;`
0.1881 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;`
0.1309 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;`
0.1359 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;`
0.1020 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;`
2.4419 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;`
0.1230 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_upe_appearance_theme' LIMIT 1;`
0.1299 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_upe_appearance_theme' LIMIT 1;`
0.1249 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_woocommerce_payments_woopay_available_countries' LIMIT 1;`
0.1340 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_woopay_direct_checkout' LIMIT 1;`
0.1180 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_stripe_billing' LIMIT 1;`
0.2298 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;`
0.1531 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_onboarding' LIMIT 1;`
0.1998 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;`
0.1299 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;`
0.0861 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;`
0.1469 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_task_list_tracked_completed_actions' LIMIT 1;`
0.1910 [ms]	`SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;`
0.1349 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cheque_settings' LIMIT 1;`
0.1218 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;`
0.0851 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;`
0.1149 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;`
0.0899 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;`
0.0920 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;`
0.0699 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;`
0.1149 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;`
0.1211 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;`
0.1509 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.2148 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.1850 [ms]	`SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'patterns_ai_data' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 1;`
0.1609 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;`
0.0980 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;`
0.1340 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_onboarding_test_mode' LIMIT 1;`
0.1230 [ms]	`SELECT * FROM wp_posts WHERE ID = 1678 LIMIT 1;`
0.1290 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;`
0.0710 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;`
0.0639 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;`
0.0629 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;`
0.0479 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;`
0.0980 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.0970 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.0889 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.0749 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.0708 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0701 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0539 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;`
0.0939 [ms]	`SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;`
0.0758 [ms]	`SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;`
0.0601 [ms]	`SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;`
0.0849 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;`
0.0670 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;`
0.0641 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;`
0.0608 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;`
0.0479 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;`
0.2069 [ms]	`SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('2012') AND post_type IN ('post','attachment') ;`
0.2460 [ms]	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ( ( YEAR( wp_posts.post_date ) = 2012 AND MONTH( wp_posts.post_date ) = 3 ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 10;`
0.0792 [ms]	`SELECT FOUND_ROWS();`
0.1419 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (271,286,280,276);`
0.2251 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (271,286,280,276) ORDER BY meta_id ASC;`
0.4010 [ms]	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (271, 286, 280, 276) ORDER BY t.name ASC ;`
0.2899 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (40,50,44,47,17,49,16,21,51,53,20,48,108);`
0.1609 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '3.135.195.249';`
0.1249 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_USER_AGENT' AND meta_value = 'claudebot';`
0.0780 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';`
0.1481 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/2012/03/';`
0.4961 [ms]	INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2024-04', 64909, 44284, 16079, 3179, '2024-04-18 16:17:01', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2024-04-18 16:17:01', wp_user = 0, hit_count = hit_count + 1;
0.0892 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;`
0.2191 [ms]	`SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;`
0.1070 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;`
0.0770 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;`
0.1900 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 105;`
0.3269 [ms]	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (108) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC ;`
0.3471 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (620,623,624,626,628,629) ORDER BY meta_id ASC;`
0.1740 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (103,84,35);`
0.1550 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 22;`
0.3569 [ms]	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;`
0.1180 [ms]	`SELECT * FROM wp_users WHERE ID IN (1);`
0.2210 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (271) ORDER BY t.name ASC ;`
0.1869 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (286) ORDER BY t.name ASC ;`
0.1731 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (287) ORDER BY meta_id ASC;`
0.2232 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (280) ORDER BY t.name ASC ;`
0.2189 [ms]	`SELECT DISTINCT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (276) ORDER BY t.name ASC ;`
0.1671 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (277) ORDER BY meta_id ASC;`
0.2389 [ms]	SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC ;
0.1590 [ms]	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ( ( YEAR( wp_posts.post_date ) = 2023 AND MONTH( wp_posts.post_date ) = 4 ) ) AND ( YEAR( wp_posts.post_date ) < 2024 ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date ASC LIMIT 0, 15;`
0.1519 [ms]	`SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('link_category') AND t.term_id IN ( 43 ) AND tt.count > 0 ORDER BY t.name ASC ;`
0.1531 [ms]	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (43);`
0.2189 [ms]	`SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 43 ) AND taxonomy = 'link_category' ORDER BY link_name ASC;`

Eli's WordPress Blog

My WordPress Plugins, and other stuff.

Monthly Archives: March 2012

The disastrous effect of social inequality on health and social stability

Now available in the WordPress Repository