| 1 | SELECT autoload FROM il52_options WHERE option_name = 'rewrite_rules' | 0.3 |
| 2 | DELETE FROM il52_options WHERE option_name = 'rewrite_rules' | 0.3 |
| 3 | SELECT option_value FROM il52_options WHERE option_name = 'rewrite_rules' LIMIT 1 | 0.1 |
| 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.7 |
| 5 | SELECT option_value FROM il52_options WHERE option_name = 'polldaddy_multiple_accounts' LIMIT 1 | 0.1 |
| 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)='11' AND il52_posts.post_type = 'post' AND (il52_posts.post_status = 'publish') ORDER BY il52_posts.post_date DESC LIMIT 0, 30 | 11.7 |
| 7 | SELECT FOUND_ROWS() | 0.1 |
| 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 (1744, 1735, 1731, 1720, 1699, 1692, 1684, 1681, 1675, 1668, 1663, 1660, 1657, 1650, 1647, 1644, 1639, 1636, 1632, 1424, 1568, 1564, 1539, 1534, 1531, 1528, 1525, 1472, 1427, 1420) ORDER BY t.name ASC | 4.2 |
| 9 | SELECT post_id, meta_key, meta_value FROM il52_postmeta WHERE post_id IN (1744,1735,1731,1720,1699,1692,1684,1681,1675,1668,1663,1660,1657,1650,1647,1644,1639,1636,1632,1424,1568,1564,1539,1534,1531,1528,1525,1472,1427,1420) | 35.2 |
| 10 | SELECT * FROM il52_users WHERE ID = 1 LIMIT 1 | 0.1 |
| 11 | SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 1 | 0.1 |
| 12 | select count(id) from il52_yhc_ip_logger_block where agent like '%ccbot/1.0 (+http://www.commoncrawl.org/bot.html)%' | 0.7 |
| 13 | select count(id) from il52_yhc_ip_logger_block where fullhost like '%38.107.191.117%' | 0.2 |
| 14 | select count(id) from il52_yhc_ip_logger_block where Code3 = 'USA' | 0 |
| 15 | select count(id) from il52_yhc_ip_logger_block where ip_v4 = '38.107.191.117' | 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.117','/2009/11/','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.117','','N') | 0.2 |
| 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.1 |
| 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 = 1744
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 |
| 21 | SELECT option_value FROM il52_options WHERE option_name = 'A2A_SHARE_SAVE_display_in_posts' LIMIT 1 | 0.1 |
| 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 = 1744
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 | 1 |
| 31 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1735
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 |
| 32 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1735
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 = 1731
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 |
| 34 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1731
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 = 1720
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 |
| 36 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1720
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 = 2 LIMIT 1 | 0.1 |
| 38 | SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 2 | 0.2 |
| 39 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1699
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 |
| 40 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1699
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 = 1692
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 |
| 42 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1692
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 = 1684
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 |
| 44 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1684
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 = 1681
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 |
| 46 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1681
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 = 1675
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 |
| 48 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1675
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 = 1668
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 |
| 50 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1668
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 = 1663
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 |
| 52 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1663
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 = 1660
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 |
| 54 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1660
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 = 1657
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 |
| 56 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1657
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 = 1650
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 = 1650
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 = 1647
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 | 3 |
| 60 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1647
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 = 1644
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 |
| 62 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1644
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 = 1639
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 |
| 64 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1639
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 = 1636
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 = 1636
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 = 1632
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 | 1.2 |
| 68 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1632
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 = 1424
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 | 1.1 |
| 70 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1424
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 = 1568
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 |
| 72 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1568
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 = 1564
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 |
| 74 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1564
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 = 1539
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 |
| 76 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1539
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 = 1534
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 |
| 78 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1534
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 = 1531
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 |
| 80 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1531
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 |
| 81 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1528
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 |
| 82 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1528
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 |
| 83 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1525
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 |
| 84 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1525
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 |
| 85 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1472
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 |
| 86 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1472
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 |
| 87 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1427
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 |
| 88 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1427
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 |
| 89 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1420
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 |
| 90 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1420
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 |
| 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.4 |
