| 1 | SELECT autoload FROM il52_options WHERE option_name = 'rewrite_rules' | 0.5 |
| 2 | DELETE FROM il52_options WHERE option_name = 'rewrite_rules' | 0.4 |
| 3 | SELECT option_value FROM il52_options WHERE option_name = 'rewrite_rules' LIMIT 1 | 0.2 |
| 4 | INSERT INTO `il52_options` (`option_name`, `option_value`, `autoload`) VALUES ('rewrite_rules', 'a:85:{s:12:\"robots\\.txt$\";s:18:\"index.php?robots=1\";s:14:\".*wp-atom.php$\";s:19:\"index.php?feed=atom\";s:13:\".*wp-rdf.php$\";s:18:\"index.php?feed=rdf\";s:13:\".*wp-rss.php$\";s:18:\"index.php?feed=rss\";s:14:\".*wp-rss2.php$\";s:19:\"index.php?feed=rss2\";s:14:\".*wp-feed.php$\";s:19:\"index.php?feed=feed\";s:22:\".*wp-commentsrss2.php$\";s:34:\"index.php?feed=rss2&withcomments=1\";s:32:\"feed/(feed|rdf|rss|rss2|atom)/?$\";s:27:\"index.php?&feed=$matches[1]\";s:27:\"(feed|rdf|rss|rss2|atom)/?$\";s:27:\"index.php?&feed=$matches[1]\";s:20:\"page/?([0-9]{1,})/?$\";s:28:\"index.php?&paged=$matches[1]\";s:14:\"all(/(.*))?/?$\";s:26:\"index.php?&all=$matches[2]\";s:41:\"comments/feed/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?&feed=$matches[1]&withcomments=1\";s:36:\"comments/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?&feed=$matches[1]&withcomments=1\";s:29:\"comments/page/?([0-9]{1,})/?$\";s:28:\"index.php?&paged=$matches[1]\";s:23:\"comments/all(/(.*))?/?$\";s:26:\"index.php?&all=$matches[2]\";s:44:\"search/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:40:\"index.php?s=$matches[1]&feed=$matches[2]\";s:39:\"search/(.+)/(feed|rdf|rss|rss2|atom)/?$\";s:40:\"index.php?s=$matches[1]&feed=$matches[2]\";s:32:\"search/(.+)/page/?([0-9]{1,})/?$\";s:41:\"index.php?s=$matches[1]&paged=$matches[2]\";s:26:\"search/(.+)/all(/(.*))?/?$\";s:39:\"index.php?s=$matches[1]&all=$matches[3]\";s:14:\"search/(.+)/?$\";s:23:\"index.php?s=$matches[1]\";s:47:\"category/(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:52:\"index.php?category_name=$matches[1]&feed=$matches[2]\";s:42:\"category/(.+?)/(feed|rdf|rss|rss2|atom)/?$\";s:52:\"index.php?category_name=$matches[1]&feed=$matches[2]\";s:35:\"category/(.+?)/page/?([0-9]{1,})/?$\";s:53:\"index.php?category_name=$matches[1]&paged=$matches[2]\";s:29:\"category/(.+?)/all(/(.*))?/?$\";s:51:\"index.php?category_name=$matches[1]&all=$matches[3]\";s:17:\"category/(.+?)/?$\";s:35:\"index.php?category_name=$matches[1]\";s:42:\"tag/(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?tag=$matches[1]&feed=$matches[2]\";s:37:\"tag/(.+?)/(feed|rdf|rss|rss2|atom)/?$\";s:42:\"index.php?tag=$matches[1]&feed=$matches[2]\";s:30:\"tag/(.+?)/page/?([0-9]{1,})/?$\";s:43:\"index.php?tag=$matches[1]&paged=$matches[2]\";s:24:\"tag/(.+?)/all(/(.*))?/?$\";s:41:\"index.php?tag=$matches[1]&all=$matches[3]\";s:12:\"tag/(.+?)/?$\";s:25:\"index.php?tag=$matches[1]\";s:47:\"author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:50:\"index.php?author_name=$matches[1]&feed=$matches[2]\";s:42:\"author/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:50:\"index.php?author_name=$matches[1]&feed=$matches[2]\";s:35:\"author/([^/]+)/page/?([0-9]{1,})/?$\";s:51:\"index.php?author_name=$matches[1]&paged=$matches[2]\";s:29:\"author/([^/]+)/all(/(.*))?/?$\";s:49:\"index.php?author_name=$matches[1]&all=$matches[3]\";s:17:\"author/([^/]+)/?$\";s:33:\"index.php?author_name=$matches[1]\";s:69:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]\";s:64:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]\";s:57:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&paged=$matches[4]\";s:51:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/all(/(.*))?/?$\";s:79:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&all=$matches[5]\";s:39:\"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$\";s:63:\"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]\";s:56:\"([0-9]{4})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:64:\"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]\";s:51:\"([0-9]{4})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$\";s:64:\"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]\";s:44:\"([0-9]{4})/([0-9]{1,2})/page/?([0-9]{1,})/?$\";s:65:\"index.php?year=$matches[1]&monthnum=$matches[2]&paged=$matches[3]\";s:38:\"([0-9]{4})/([0-9]{1,2})/all(/(.*))?/?$\";s:63:\"index.php?year=$matches[1]&monthnum=$matches[2]&all=$matches[4]\";s:26:\"([0-9]{4})/([0-9]{1,2})/?$\";s:47:\"index.php?year=$matches[1]&monthnum=$matches[2]\";s:43:\"([0-9]{4})/feed/(feed|rdf|rss|rss2|atom)/?$\";s:43:\"index.php?year=$matches[1]&feed=$matches[2]\";s:38:\"([0-9]{4})/(feed|rdf|rss|rss2|atom)/?$\";s:43:\"index.php?year=$matches[1]&feed=$matches[2]\";s:31:\"([0-9]{4})/page/?([0-9]{1,})/?$\";s:44:\"index.php?year=$matches[1]&paged=$matches[2]\";s:25:\"([0-9]{4})/all(/(.*))?/?$\";s:42:\"index.php?year=$matches[1]&all=$matches[3]\";s:13:\"([0-9]{4})/?$\";s:26:\"index.php?year=$matches[1]\";s:47:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:57:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:77:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:72:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:72:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:44:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/trackback/?$\";s:69:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&tb=1\";s:64:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&feed=$matches[4]\";s:59:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&feed=$matches[4]\";s:52:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/page/?([0-9]{1,})/?$\";s:82:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&paged=$matches[4]\";s:59:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/comment-page-([0-9]{1,})/?$\";s:82:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&cpage=$matches[4]\";s:46:\"([0-9]{4})/([0-9]{1,2})/([^/]+)/all(/(.*))?/?$\";s:80:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&all=$matches[5]\";s:48:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/all(/(.*))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:59:\"[0-9]{4}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/all(/(.*))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:44:\"([0-9]{4})/([0-9]{1,2})/([^/]+)(/[0-9]+)?/?$\";s:81:\"index.php?year=$matches[1]&monthnum=$matches[2]&name=$matches[3]&page=$matches[4]\";s:36:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:46:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:66:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:61:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:61:\"[0-9]{4}/[0-9]{1,2}/[^/]+/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:51:\"([0-9]{4})/([0-9]{1,2})/comment-page-([0-9]{1,})/?$\";s:65:\"index.php?year=$matches[1]&monthnum=$matches[2]&cpage=$matches[3]\";s:38:\"([0-9]{4})/comment-page-([0-9]{1,})/?$\";s:44:\"index.php?year=$matches[1]&cpage=$matches[2]\";s:25:\".+?/attachment/([^/]+)/?$\";s:32:\"index.php?attachment=$matches[1]\";s:35:\".+?/attachment/([^/]+)/trackback/?$\";s:37:\"index.php?attachment=$matches[1]&tb=1\";s:55:\".+?/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:50:\".+?/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$\";s:49:\"index.php?attachment=$matches[1]&feed=$matches[2]\";s:50:\".+?/attachment/([^/]+)/comment-page-([0-9]{1,})/?$\";s:50:\"index.php?attachment=$matches[1]&cpage=$matches[2]\";s:18:\"(.+?)/trackback/?$\";s:35:\"index.php?pagename=$matches[1]&tb=1\";s:38:\"(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$\";s:47:\"index.php?pagename=$matches[1]&feed=$matches[2]\";s:33:\"(.+?)/(feed|rdf|rss|rss2|atom)/?$\";s:47:\"index.php?pagename=$matches[1]&feed=$matches[2]\";s:26:\"(.+?)/page/?([0-9]{1,})/?$\";s:48:\"index.php?pagename=$matches[1]&paged=$matches[2]\";s:33:\"(.+?)/comment-page-([0-9]{1,})/?$\";s:48:\"index.php?pagename=$matches[1]&cpage=$matches[2]\";s:20:\"(.+?)/all(/(.*))?/?$\";s:46:\"index.php?pagename=$matches[1]&all=$matches[3]\";s:26:\".+?/([^/]+)/all(/(.*))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:37:\".+?/attachment/([^/]+)/all(/(.*))?/?$\";s:48:\"index.php?attachment=$matches[1]&all=$matches[2]\";s:18:\"(.+?)(/[0-9]+)?/?$\";s:47:\"index.php?pagename=$matches[1]&page=$matches[2]\";}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) | 0.8 |
| 5 | SELECT option_value FROM il52_options WHERE option_name = 'polldaddy_multiple_accounts' LIMIT 1 | 0.4 |
| 6 | SELECT SQL_CALC_FOUND_ROWS il52_posts.* FROM il52_posts WHERE 1=1 AND YEAR(il52_posts.post_date)='2009' AND MONTH(il52_posts.post_date)='8' AND il52_posts.post_type = 'post' AND (il52_posts.post_status = 'publish') ORDER BY il52_posts.post_date DESC LIMIT 0, 30 | 12.5 |
| 7 | SELECT FOUND_ROWS() | 0.2 |
| 8 | SELECT t.*, tt.*, tr.object_id FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN il52_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (1230, 1226, 1224, 1222, 1219, 1216, 1213, 1210, 1204, 1196, 1194, 1192, 1189, 1185, 1182, 1179, 1176, 1173, 1168, 1165, 1155, 1151, 1139, 1131, 1126, 1122, 1119, 1116, 1113, 1110) ORDER BY t.name ASC | 5.7 |
| 9 | SELECT post_id, meta_key, meta_value FROM il52_postmeta WHERE post_id IN (1230,1226,1224,1222,1219,1216,1213,1210,1204,1196,1194,1192,1189,1185,1182,1179,1176,1173,1168,1165,1155,1151,1139,1131,1126,1122,1119,1116,1113,1110) | 23.9 |
| 10 | SELECT * FROM il52_users WHERE ID = 2 LIMIT 1 | 0.3 |
| 11 | SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 2 | 0.3 |
| 12 | select count(id) from il52_yhc_ip_logger_block where agent like '%ccbot/1.0 (+http://www.commoncrawl.org/bot.html)%' | 0.4 |
| 13 | select count(id) from il52_yhc_ip_logger_block where fullhost like '%38.107.191.115%' | 0.2 |
| 14 | select count(id) from il52_yhc_ip_logger_block where Code3 = 'USA' | 0.1 |
| 15 | select count(id) from il52_yhc_ip_logger_block where ip_v4 = '38.107.191.115' | 0.1 |
| 16 | insert into il52_yhc_ip_logger (ip_v4,url,host,user_agent,accept_language,accept_encoding,accept_charset,http_accept,
CountryCode,Code3,Country,Region,City,Latitude,Longitude,ZipCode,dmacode,areacode,provider,http_referer,blocked)
values ('38.107.191.115','/2009/08/','www.hardwareslave.com','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)','en-us,en;q=0.5','gzip','ISO-8859-1,utf-8;q=0.7,*;q=0.7','text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5','US','USA','United States','','','38','-97','','','','38.107.191.115','','N') | 0.3 |
| 17 | SELECT t.*, tt.* FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC | 0.2 |
| 18 | SELECT * FROM il52_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order, post_title ASC | 0.1 |
| 19 | SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM il52_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC | 0.1 |
| 20 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1230
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.7 |
| 21 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_display_in_posts' LIMIT 1 | 0.2 |
| 22 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_display_in_posts_on_front_page' LIMIT 1 | 0.1 |
| 23 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_active_services' LIMIT 1 | 0.1 |
| 24 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_button_opens_new_window' LIMIT 1 | 0.1 |
| 25 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_button' LIMIT 1 | 0.1 |
| 26 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_onclick' LIMIT 1 | 0.1 |
| 27 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_hide_embeds' LIMIT 1 | 0.1 |
| 28 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_show_title' LIMIT 1 | 0.1 |
| 29 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_additional_js_variables' LIMIT 1 | 0.1 |
| 30 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1230
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 31 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1226
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.6 |
| 32 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1226
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 33 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1224
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.8 |
| 34 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1224
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 35 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1222
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.7 |
| 36 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1222
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 37 | SELECT * FROM il52_users WHERE ID = 1 LIMIT 1 | 0.1 |
| 38 | SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 1 | 0.1 |
| 39 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1219
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.6 |
| 40 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1219
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 41 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1216
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.6 |
| 42 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1216
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 43 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1213
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.7 |
| 44 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1213
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 45 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1210
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.7 |
| 46 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1210
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 47 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1204
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.7 |
| 48 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1204
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 49 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1196
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.6 |
| 50 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1196
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 51 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1194
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.5 |
| 52 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1194
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 53 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1192
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.4 |
| 54 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1192
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 55 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1189
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.4 |
| 56 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1189
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 57 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1185
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 58 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1185
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 59 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1182
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 60 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1182
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 61 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1179
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 62 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1179
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 63 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1176
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 64 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1176
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 65 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1173
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 66 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1173
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 67 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1168
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.4 |
| 68 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1168
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 69 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1165
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.4 |
| 70 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1165
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 71 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1155
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 72 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1155
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 73 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1151
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 74 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1151
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 75 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1139
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 76 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1139
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 77 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1131
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 78 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1131
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 79 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1126
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 80 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1126
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 81 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1122
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 82 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1122
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 83 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1119
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 84 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1119
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 85 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1116
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 86 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1116
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 87 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1113
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.2 |
| 88 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1113
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 89 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1110
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.3 |
| 90 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1110
AND instances.source_type = 'post'
AND instances.instance_type = 'link'
AND instances.link_id = links.link_id
AND links.check_count > 0
AND ( links.http_code < 200 OR links.http_code >= 400 OR links.timeout = 1 )
AND links.http_code <> 1 | 0.1 |
| 91 | SELECT t.*, tt.* FROM il52_terms AS t INNER JOIN il52_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('post_tag') AND tt.count > 0 ORDER BY tt.count DESC LIMIT 45 | 0.1 |
