| 1 | SELECT autoload FROM il52_options WHERE option_name = 'rewrite_rules' | 0.4 |
| 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.8 |
| 5 | SELECT option_value FROM il52_options WHERE option_name = 'polldaddy_multiple_accounts' LIMIT 1 | 0.3 |
| 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)='12' AND il52_posts.post_type = 'post' AND (il52_posts.post_status = 'publish') ORDER BY il52_posts.post_date DESC LIMIT 0, 30 | 12.2 |
| 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 (1930, 1924, 1918, 1914, 1910, 1907, 1903, 1901, 1893, 1891, 1889, 1885, 1882, 1879, 1868, 1865, 1860, 1854, 1852, 1849, 1842, 1831, 1823, 1819, 1815, 1812, 1804, 1801, 1798, 1795) ORDER BY t.name ASC | 4.6 |
| 9 | SELECT post_id, meta_key, meta_value FROM il52_postmeta WHERE post_id IN (1930,1924,1918,1914,1910,1907,1903,1901,1893,1891,1889,1885,1882,1879,1868,1865,1860,1854,1852,1849,1842,1831,1823,1819,1815,1812,1804,1801,1798,1795) | 1.4 |
| 10 | SELECT * FROM il52_users WHERE ID = 2 LIMIT 1 | 0.1 |
| 11 | SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 2 | 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.5 |
| 13 | select count(id) from il52_yhc_ip_logger_block where fullhost like '%38.107.191.115%' | 0.1 |
| 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/12/','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.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 = 1930
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 |
| 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 = 1930
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 = 1924
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 |
| 32 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1924
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 * FROM il52_users WHERE ID = 1 LIMIT 1 | 0.1 |
| 34 | SELECT meta_key, meta_value FROM il52_usermeta WHERE user_id = 1 | 0.1 |
| 35 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1918
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 = 1918
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 instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1914
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 |
| 38 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1914
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 |
| 39 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1910
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 |
| 40 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1910
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 = 1907
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 |
| 42 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1907
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 = 1903
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 |
| 44 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1903
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 = 1901
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 |
| 46 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1901
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 = 1893
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 |
| 48 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1893
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 = 1891
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 |
| 50 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1891
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 = 1889
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 = 1889
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 = 1885
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 = 1885
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 = 1882
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 = 1882
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 = 1879
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 = 1879
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 |
| 59 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1868
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 |
| 60 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1868
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 = 1865
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 = 1865
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 = 1860
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 |
| 64 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1860
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 = 1854
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 |
| 66 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1854
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 = 1852
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 = 1852
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 = 1849
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 |
| 70 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1849
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 |
| 71 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1842
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 |
| 72 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1842
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 = 1831
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 = 1831
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 = 1823
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 = 1823
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 = 1819
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 = 1819
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 = 1815
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 = 1815
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 = 1812
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 = 1812
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 = 1804
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 = 1804
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 = 1801
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 = 1801
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 = 1798
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 |
| 88 |
SELECT instances.link_text, links.*
FROM il52_blc_instances AS instances, il52_blc_links AS links
WHERE
instances.source_id = 1798
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 = 1795
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 = 1795
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 |