My New SQL Reports Plugin for Your WordPress Admin

Posted on December 13, 2011 by Eli Scheetz

This plugin allows you to create reports simply by entering in the SQL. You can save multiple reports and they will be listed on the Admin Menu so you can quickly run them again anytime with just one click.

Download of EliSQLReports from WordPress.org

Update 1.1.11.17 of My TERRIBL Plugin

Posted on November 18, 2011 by Eli Scheetz

A week or so ago I started noticing some “sketchy” sites popping up on my TERRIBL Widget. When I checked them out I found no links to my site at all. After looking at my reports and log files and doing some experiments of my own, I figured out that most of these entries were coming from proxies, Perl scripts, and CURL calls and were completely bogus. So I started working on a way to automatically detect and block these and other invalid Referer’s from showing up on the sidebar widget. What I came up with was to do a callback to their site using the file_get_contents() function and scan their page for a link to the page in question. Then, only if the link was verified would the Referer be approved and added to the widget. After some testing on a few different sites using multiple methods for invoking these entries I felt satisfied that my new filtering technique was ready. So download this new version and let me know how it works for you!

Download of TERRIBL from WordPress.org

New! version 1.1.11.08 of My TERRIBL Plugin Just Released

Posted on November 9, 2011 by Eli Scheetz

I just released a new vertion of my TERRIBL WordPress Plugin today. Thanks to a tip from “Futureproject” at silvercyborg.com I was able to track down I and eliminate a bug that caused the whole site to load lowly after installing my TERRIBL Plugin.

I also add a few handy things to the Admin page like a field to change the default path to your site when sharing you link. And thanks to Anthony at securehostinghawaii.com I discovered a need to block certain sites from showing up on the Widget, which is now possible in the new version. You can also manually add a site to be displayed on the Widget, which is helpful for getting started after your firs install when you haven’t gotten any In-Bound Link yet.

As always, if you like my plugins, don’t forget to rate them with 5 Stars at: http://wordpress.org/extend/plugins/profile/scheeeli

If you don’t like my plugins, just quietly let me know and I’ll see what I can do ;-)

Download of TERRIBL from WordPress.org

Fixed lots of bugs in my TERRIBL Widget

Posted on November 3, 2011 by Eli Scheetz

Oooops… So maybe I released this first version too quickly. There were quite a few bugs in my TERRIBL Widget that resulted in the links being empty (I guess it really was a Terrible Widget ;-). I just released version 1.1.11.02 that fixes all these bugs but not before 30 people downloaded the broken one (I hope they upgrade to the fixed version).

Please leave a comment on this blog if you have any feedback or suggestions. I am now working on a built-in Feedback form which I hope to release in later revisions of all my plugins.

Download of TERRIBL from WordPress.org

Added My TERRIBL Widget to the WordPress Repository

Posted on November 2, 2011 by Eli Scheetz

I added my new TERRIBL Widget to the WordPress Repository yesterday and it was accepted today. It’s a simple plugin that tracks every HTTP_REFERER to your site so that you can see where your traffic is coming from.

There is also a Widget included that will display a list of in-bound links. This is a maintenance-free way for you to link back to those sites that already link to you. It sure make link trading easy!

Download of TERRIBL from WordPress.org

Profiler Initiaded	0.0000 ms	38683 kB
Profiler Noise	0.0069 ms	38683 kB
Profiler Stopped	622.3500 ms	111192 kB

0.2110 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;`
0.1118 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;`
0.2789 [ms]	SELECT * FROM `wp_posts` WHERE post_type = 'gotmls_results' AND post_name = '4de7d57b7adb1ed27549432ed38751a6';
0.2100 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;`
0.2470 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;`
0.0889 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_default_handler' LIMIT 1;`
0.0849 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_level_threshold' LIMIT 1;`
0.0899 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_data_sync_enabled' LIMIT 1;`
0.0739 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_background_sync_mode' LIMIT 1;`
0.1431 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wc_installing' LIMIT 1;`
0.0920 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wc_installing' LIMIT 1;`
0.0651 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_feature_marketplace_enabled' LIMIT 1;`
0.2189 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_check_subscriptions_eligibility_after_onboarding' LIMIT 1;`
0.1409 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;`
0.1280 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;`
0.1490 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;`
0.1380 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;`
0.2460 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'has_jetpack_search_product' LIMIT 1;`
0.1819 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'instant_search_enabled' LIMIT 1;`
0.1121 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_blocks_disabled' LIMIT 1;`
0.0811 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;`
0.0708 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;`
0.2120 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;`
0.2120 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;`
0.0961 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;`
0.2151 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;`
0.2151 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;`
0.2141 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;`
0.1340 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;`
0.1569 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;`
0.0880 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;`
2.5930 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;`
0.1621 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_upe_appearance_theme' LIMIT 1;`
0.0958 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_upe_appearance_theme' LIMIT 1;`
0.0949 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_woocommerce_payments_woopay_available_countries' LIMIT 1;`
0.1760 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_woopay_direct_checkout' LIMIT 1;`
0.1099 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_stripe_billing' LIMIT 1;`
0.1800 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;`
0.1380 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_onboarding' LIMIT 1;`
0.2282 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;`
0.2720 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;`
0.1259 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_task_list_tracked_completed_actions' LIMIT 1;`
0.2530 [ms]	`SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;`
0.1421 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cheque_settings' LIMIT 1;`
0.0930 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;`
0.1249 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;`
0.0949 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;`
0.2630 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;`
0.1240 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;`
0.1059 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;`
0.1161 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;`
0.3030 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.2291 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.2279 [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.1490 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;`
0.1090 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;`
0.1321 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_onboarding_test_mode' LIMIT 1;`
0.1221 [ms]	`SELECT * FROM wp_posts WHERE ID = 1678 LIMIT 1;`
0.1121 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;`
0.1149 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;`
0.1221 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;`
0.1109 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;`
0.1659 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.1130 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.1152 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.1099 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.1061 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0679 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.1061 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;`
0.2019 [ms]	`SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;`
0.0908 [ms]	`SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;`
0.0780 [ms]	`SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;`
0.1209 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;`
0.0720 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;`
0.0651 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;`
0.0780 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;`
0.0691 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;`
0.3989 [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 ('category') AND t.slug IN ('my-plugins') ;`
0.1180 [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 (22);`
0.2079 [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 ('category') AND t.term_id IN ( 21,24,35,41,44,45,48,55,56,73,80,84,103,106,22 ) ;`
0.3810 [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 (21,24,35,41,44,45,48,55,56,73,80,84,103,106);`
0.1528 [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 ('category') AND t.slug IN ('my-plugins') LIMIT 1;`
0.5388 [ms]	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 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 (24,25,27,38,44,47,48,51,58,59,76,83,87,106,109) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 30, 10;`
0.0830 [ms]	`SELECT FOUND_ROWS();`
0.1860 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (171,151,121,123,114,99,82,77,71,68);`
0.4151 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (171,151,121,123,114,99,82,77,71,68) ORDER BY meta_id ASC;`
0.6459 [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 (171, 151, 121, 123, 114, 99, 82, 77, 71, 68) ORDER BY t.name ASC ;`
0.2110 [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 (16,36,20,108);`
0.1581 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '3.15.174.76';`
1.0419 [ms]	SHOW FULL COLUMNS FROM `wp_shareable_meta`;
0.4730 [ms]	INSERT INTO `wp_shareable_meta` (`meta_type`, `meta_value`) VALUES ('REMOTE_ADDR', '3.15.174.76');
0.1791 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_USER_AGENT' AND meta_value = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)';`
0.1271 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';`
0.1390 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/category/my-plugins/page/4/';`
0.3731 [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', 66300, 64970, 16079, 196, '2024-04-26 18:09:56', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2024-04-26 18:09:56', wp_user = 0, hit_count = hit_count + 1;
0.1411 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;`
0.1590 [ms]	`SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;`
0.1979 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;`
0.1390 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;`
0.2029 [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.3111 [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.4871 [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.4640 [ms]	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;`
0.1471 [ms]	`SELECT * FROM wp_users WHERE ID IN (1);`
0.3400 [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 (171) ORDER BY t.name ASC ;`
0.3870 [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 (151) ORDER BY t.name ASC ;`
0.3610 [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 (121) ORDER BY t.name ASC ;`
0.2570 [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 (123) ORDER BY t.name ASC ;`
0.4981 [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 (114) ORDER BY t.name ASC ;`
0.4761 [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 (99) ORDER BY t.name ASC ;`
0.3800 [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 (82) ORDER BY t.name ASC ;`
0.2658 [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 (77) ORDER BY t.name ASC ;`
0.2708 [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 (71) ORDER BY t.name ASC ;`
0.2360 [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 (68) ORDER BY t.name ASC ;`
0.2749 [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.2160 [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.1891 [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.1760 [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.3092 [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.

Category Archives: My Plugins

My New SQL Reports Plugin for Your WordPress Admin

Update 1.1.11.17 of My TERRIBL Plugin

New! version 1.1.11.08 of My TERRIBL Plugin Just Released

Fixed lots of bugs in my TERRIBL Widget

Added My TERRIBL Widget to the WordPress Repository