December | 2012 | Eli's WordPress Blog

I created this plugin that uses a shortcode to call wp_remote_get with parameters you pass to parsed and display a bit of HTML from a page on another site. You can include this shortcode in your page or post.

Here is an example of the shortcode that will display the Download Stats page for this Plugin on WordPress.org:
[remote_get url="https://wordpress.org/plugins/shortcurl/" start='<div class="entry-meta"' stop='!-- .entry-meta --' length="-1"].
and this is what you get:

Download of SHORTcURL from WordPress.org

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/2012/12/', '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' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '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' => 'ZiqJeGzGeNFcK3aqNoiRUwAAAcA', 'REDIRECT_URL' => '/2012/12/', 'REMOTE_ADDR' => '3.142.197.212', 'REMOTE_PORT' => '41753', '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' => 'ZiqJeGzGeNFcK3aqNoiRUwAAAcA', 'dont_vary' => '1', 'no_gzip' => '1', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1714063736.914784, 'REQUEST_TIME' => 1714063736, );

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 ) = 12 ) ) 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 (410, 406) 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', 66132, 64970, 16079, 3176, '2024-04-25 16:48:57', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2024-04-25 16:48:57', 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 (410) 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	38680 kB
Profiler Noise	0.0038 ms	38680 kB
Profiler Stopped	477.9799 ms	111803 kB

0.2439 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1;`
0.1421 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1;`
0.2389 [ms]	SELECT * FROM `wp_posts` WHERE post_type = 'gotmls_results' AND post_name = '47761c5b5355de76d1d9ddd28b931d01';
0.2401 [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.2470 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_default_handler' LIMIT 1;`
0.1500 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_logs_level_threshold' LIMIT 1;`
0.1020 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_data_sync_enabled' LIMIT 1;`
0.1280 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_custom_orders_table_background_sync_mode' LIMIT 1;`
0.1390 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wc_installing' LIMIT 1;`
0.1440 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wc_installing' LIMIT 1;`
0.1421 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_feature_marketplace_enabled' LIMIT 1;`
0.2110 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_check_subscriptions_eligibility_after_onboarding' LIMIT 1;`
0.1280 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_error_idc' LIMIT 1;`
0.1349 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_allow_tracking' LIMIT 1;`
0.1681 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'as_has_wp_comment_logs' LIMIT 1;`
0.1121 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_connection_xmlrpc_verified_errors' LIMIT 1;`
0.2120 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'has_jetpack_search_product' LIMIT 1;`
0.2289 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'instant_search_enabled' LIMIT 1;`
0.0858 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_blocks_disabled' LIMIT 1;`
0.1371 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1;`
0.1101 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-replace' LIMIT 1;`
0.1321 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_excluded_extensions' LIMIT 1;`
0.2489 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_settings_enabled' LIMIT 1;`
0.1421 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_show_marketplace_suggestions' LIMIT 1;`
0.2000 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_pickup_location_settings' LIMIT 1;`
0.2029 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_account_data' LIMIT 1;`
0.2460 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_customer_multi_currency' LIMIT 1;`
0.1459 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_currency_format' LIMIT 1;`
0.1910 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_currency_format' LIMIT 1;`
0.1361 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_locale_info' LIMIT 1;`
2.5501 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_locale_info' LIMIT 1;`
0.1771 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_wcpay_upe_appearance_theme' LIMIT 1;`
0.0889 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_wcpay_upe_appearance_theme' LIMIT 1;`
0.1230 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_woocommerce_payments_woopay_available_countries' LIMIT 1;`
0.1519 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_woopay_direct_checkout' LIMIT 1;`
0.1290 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_wcpay_feature_stripe_billing' LIMIT 1;`
0.2451 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_sync_non_blocking' LIMIT 1;`
0.1109 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'jetpack_onboarding' LIMIT 1;`
0.2580 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_product_download_dir_sync_page' LIMIT 1;`
0.2229 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_logging_enabled' LIMIT 1;`
0.1512 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wc_connect_debug_display_enabled' LIMIT 1;`
0.1931 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_task_list_tracked_completed_actions' LIMIT 1;`
0.1760 [ms]	`SELECT * FROM wp_posts WHERE ID = 1676 LIMIT 1;`
0.0980 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cheque_settings' LIMIT 1;`
0.1299 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_bacs_settings' LIMIT 1;`
0.1121 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cod_settings' LIMIT 1;`
0.1869 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_settings' LIMIT 1;`
0.0889 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'webpc_token_data' LIMIT 1;`
0.0968 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_crop' LIMIT 1;`
0.0889 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'medium_large_crop' LIMIT 1;`
0.0849 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'large_crop' LIMIT 1;`
0.0920 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_thumbnail_cropping' LIMIT 1;`
0.1929 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.2110 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_woocommerce_blocks_asset_api_script_data' LIMIT 1;`
0.1922 [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.2489 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_cart_page_id' LIMIT 1;`
0.0989 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_checkout_page_id' LIMIT 1;`
0.2398 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_onboarding_test_mode' LIMIT 1;`
0.1731 [ms]	`SELECT * FROM wp_posts WHERE ID = 1678 LIMIT 1;`
0.2160 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_cached_currencies' LIMIT 1;`
0.1130 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enabled_currencies' LIMIT 1;`
0.0870 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_charm_usd' LIMIT 1;`
0.0861 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_price_rounding_usd' LIMIT 1;`
0.1390 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_exchange_rate_usd' LIMIT 1;`
0.1369 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.1001 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_cart_checkout_content_sources' LIMIT 1;`
0.0639 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.0591 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_cart_page' LIMIT 1;`
0.0591 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_timeout_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0579 [ms]	`SELECT option_value FROM wp_options WHERE option_name = '_transient_jetpack_woocommerce_analytics_additional_blocks_on_checkout_page' LIMIT 1;`
0.0880 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'wcpay_multi_currency_enable_auto_currency' LIMIT 1;`
0.1268 [ms]	`SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;;`
0.1080 [ms]	`SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0;`
0.0958 [ms]	`SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0;`
0.1159 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_flat_rate_settings' LIMIT 1;`
0.0961 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_free_shipping_settings' LIMIT 1;`
0.0939 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_international_delivery_settings' LIMIT 1;`
0.0489 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_delivery_settings' LIMIT 1;`
0.0491 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_local_pickup_settings' LIMIT 1;`
0.2170 [ms]	`SELECT ID, post_name, post_parent, post_type FROM wp_posts WHERE post_name IN ('2012') AND post_type IN ('post','attachment') ;`
0.2661 [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 ) = 12 ) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 10;`
0.0641 [ms]	`SELECT FOUND_ROWS();`
0.1361 [ms]	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (410,406);`
0.1259 [ms]	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (410,406) ORDER BY meta_id ASC;`
0.3581 [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 (410, 406) ORDER BY t.name ASC ;`
0.2329 [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,56,79,90,91,92,86,84,85);`
0.1140 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REMOTE_ADDR' AND meta_value = '3.142.197.212';`
0.1440 [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.0701 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'HTTP_REFERER' AND meta_value = '';`
0.0820 [ms]	`SELECT meta_id FROM wp_shareable_meta WHERE meta_type = 'REQUEST_URI' AND meta_value = '/2012/12/';`
2.4900 [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', 66132, 64970, 16079, 3176, '2024-04-25 16:48:57', 0, 1) ON DUPLICATE KEY UPDATE last_view = '2024-04-25 16:48:57', wp_user = 0, hit_count = hit_count + 1;
0.1190 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_myaccount_page_id' LIMIT 1;`
0.2730 [ms]	`SELECT * FROM wp_posts WHERE ID = 1677 LIMIT 1;`
0.0961 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1;`
0.1249 [ms]	`SELECT option_value FROM wp_options WHERE option_name = 'woocommerce_demo_store' LIMIT 1;`
0.2241 [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.2959 [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.4032 [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.2069 [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,35);`
0.1268 [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.3381 [ms]	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC;`
0.1280 [ms]	`SELECT * FROM wp_users WHERE ID IN (1);`
0.2489 [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 (410) ORDER BY t.name ASC ;`
0.2489 [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 (406) ORDER BY t.name ASC ;`
0.2611 [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.1888 [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.1280 [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.1822 [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.2711 [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: December 2012

My new Plugin for making cURL calls

Ratings

Contributors

Support

Donate

Defend Internet Privacy

Meta

Ratings

Contributors

Support

Donate