Fixed The “Illegal mix of collations” Error In My TERRIBL WordPress Plugin

Posted on December 30, 2011 by Eli Scheetz

Well, I finally found a server that would reproduce the “Illegal mix of collations” error that MySQL troughs when executing some queries in my TERRIBL Plugin. See, I guess alot of servers use latin1_swedish_ci as the default collation for their MySQL databases. This seems to cause an error in some queries, especially those that use foreign characters. So I have patched my Plugin by explicitly setting all my database collations to utf8_general_ci. I also added an error handler that looks for this error in database table that may have been created by older versions of the Plugin and the new version will now fix the old tables using an “Alter Table” statement. So upgrade to version 1.1.12.21 now.

Download of TERRIBL from WordPress.org

My TERRIBL Plugin Just Got Terribler

Posted on December 21, 2011 by Eli Scheetz

I released an update a couple of days ago with some more stats and another attempt to work around the whole Search String URL problem with Google’s new SSL Search. However, in the process of changing some field aliases in the database queries I inadvertently broke the Widget. So today I released another update to fix the Widget and it all seems to be working.

I really thought this Plugin has a lot of potential to be very popular but it still has less than 700 downloads and my other Plugin, Related Posts Links and Widget already has more than 2,600 downloads. Oh well, Maybe if I find a solution the the SSL Encrypted Search String issue it will be a great Search Engine Optimization Tool.

Download of TERRIBL 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

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/category/my-plugins/terribl-widget/', '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' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'HTTP_ACCEPT_ENCODING' => 'br,gzip', 'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5', 'HTTP_AUTHORIZATION' => '', 'HTTP_CONNECTION' => 'Keep-Alive', 'HTTP_HOST' => 'wordpress.ieonly.com', 'HTTP_IF_MODIFIED_SINCE' => 'Sun, 28 May 2023 19:48:10 GMT', 'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', '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' => 'ZWshWcdlohWMUQGaeFjaWgAAAIo', 'REDIRECT_URL' => '/category/my-plugins/terribl-widget/', 'REMOTE_ADDR' => '44.220.249.141', 'REMOTE_PORT' => '47210', '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' => 'ZWshWcdlohWMUQGaeFjaWgAAAIo', 'dont_vary' => '1', 'no_gzip' => '1', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1701519705.358462, 'REQUEST_TIME' => 1701519705, );

INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1701519705.8506050109863281250000', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);

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 (27) ) 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 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 (386, 190, 183, 123, 114, 99, 82) 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 ('2023-12', 46447, 7541, 16079, 327, '2023-12-02 12:21:46', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-12-02 12:21:46', 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 (386) 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 ) = 2022 AND MONTH( wp_posts.post_date ) = 12 ) ) AND ( YEAR( wp_posts.post_date ) < 2023 ) 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	37461 kB
Profiler Noise	0.0041 ms	37461 kB
Profiler Stopped	1,044.8840 ms	96050 kB

0.2449 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;`
0.1390 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;`
0.1552 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/1701519705.4889' LIMIT 1;`
0.3679 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'at_options' LIMIT 1;`
0.1161 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_edit_links_calypso_redirect' LIMIT 1;`
0.1681 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'uninstall_plugins' LIMIT 1;`
0.2589 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;`
0.1600 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;`
0.1209 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;`
0.1001 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;`
0.1030 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;`
0.0842 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;`
0.1869 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_navigation_enabled' LIMIT 1;`
0.1030 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;`
0.0820 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;`
0.2019 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_view_subscriptions_endpoint' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;`
0.1140 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_platform_checkout' LIMIT 1;`
0.1380 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;`
0.1030 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;`
0.1771 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;`
0.0949 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;`
2.4290 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;`
0.1562 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_upe' LIMIT 1;`
0.1991 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;`
0.2320 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;`
0.1180 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;`
0.1190 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_services' LIMIT 1;`
0.0820 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_setup_automated_taxes' LIMIT 1;`
0.1271 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_disabled_plugins' LIMIT 1;`
0.1211 [ms]	`SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;`
0.0930 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcs_do_subscriptions_exist' LIMIT 1;`
0.1111 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcs_do_subscriptions_exist' LIMIT 1;`
0.1149 [ms]	`SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' LIMIT 1;;`
0.1109 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;`
0.0858 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;`
0.2310 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;`
0.1221 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;`
0.1140 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;`
0.1240 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;`
0.1600 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_retrieval_error' LIMIT 1;`
0.1271 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;`
0.1001 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;`
0.0839 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;`
0.0851 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;`
0.0520 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;`
0.0830 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;`
0.0789 [ms]	`SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;`
0.0780 [ms]	`SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;`
0.0792 [ms]	`SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;`
0.0830 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;`
0.0792 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;`
0.0660 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;`
0.0620 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;`
0.0608 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;`
0.0529 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_doing_cron' LIMIT 1;`
0.0629 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_doing_cron' LIMIT 1;`
0.5219 [ms]	INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('_transient_doing_cron', '1701519705.8506050109863281250000', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
0.3099 [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 ('terribl-widget') ;`
0.1452 [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 (24);`
0.1960 [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 ( 24 ) ;`
0.1400 [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 ('terribl-widget') LIMIT 1 ;`
0.2699 [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 (27) ) 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 0, 10 ;`
0.0620 [ms]	`SELECT FOUND_ROWS();`
0.1471 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (386,190,183,123,114,99,82);`
0.2000 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (386,190,183,123,114,99,82) ORDER BY meta_id ASC;`
0.3650 [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 (386, 190, 183, 123, 114, 99, 82) ORDER BY t.name ASC ;`
0.1731 [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 (77,16,76,20,108);`
0.1020 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '44.220.249.141';`
0.0858 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_USER_AGENT' AND meta_value = 'CCBot/2.0 (https://commoncrawl.org/faq/)';`
0.1111 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';`
0.0901 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/category/my-plugins/terribl-widget/';`
0.3989 [ms]	INSERT INTO wp_shareable_hits (`MONTH_OF`, REMOTE_ADDR, HTTP_USER_AGENT, HTTP_REFERER, REQUEST_URI, last_view, wp_user, hit_count) VALUES ('2023-12', 46447, 7541, 16079, 327, '2023-12-02 12:21:46', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2023-12-02 12:21:46', wp_user = 0, hit_count = hit_count + 1;
0.0830 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;`
0.0751 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;`
0.0789 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;`
0.1101 [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.1409 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'sharedaddy_disable_resources' LIMIT 1;`
0.1190 [ms]	`SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;`
0.0780 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;`
0.1061 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;`
0.1309 [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.2651 [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.3030 [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.1872 [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 (44,103,21,84,35);`
0.3128 [ms]	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;`
0.0851 [ms]	`SELECT * FROM wp_users WHERE ID IN (1);`
0.1800 [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 (386) ORDER BY t.name ASC ;`
0.1721 [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 (190) ORDER BY t.name ASC ;`
0.1662 [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 (183) ORDER BY t.name ASC ;`
0.1931 [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.2160 [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.1669 [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.2019 [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.2000 [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.2341 [ms]	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ( ( YEAR( wp_posts.post_date ) = 2022 AND MONTH( wp_posts.post_date ) = 12 ) ) AND ( YEAR( wp_posts.post_date ) < 2023 ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date ASC LIMIT 0, 15 ;`
0.1070 [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.1080 [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.2458 [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: SHAREABLE Widget

Fixed The “Illegal mix of collations” Error In My TERRIBL WordPress Plugin

My TERRIBL Plugin Just Got Terribler

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