BLOGOLATOR Latest Items Display

Member Login

Lost your password?

Not a member yet? Sign Up!

 
LOG IN | REGISTER
Facebook BlogolatorMyspace BlogolatorTwitter Blogolator

[Grab This/Embed] | More Topics | Create Your Blogolator
(default) 18 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `items`11111
2DESCRIBE `sites`881
3SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `status` = 1 AND `preset` = 'indie' 23230
4SELECT COUNT(*) AS `count` FROM `items` AS `Item` INNER JOIN `sites` AS `Site` ON (`Item`.`site_id` = `Site`.`id`) WHERE `Item`.`site_id` IN (46,45,16,18,19,20,21,22,23,24,25,26,27,28,29,30,32,33,34,43,44,42,41) AND `Item`.`pubDate` >= DATE_SUB(CURDATE(),INTERVAL 1 DAY) 111
5SELECT `Item`.`id`, `Item`.`title`, `Item`.`link`, `Item`.`pubDate`, `Item`.`description`, `Item`.`contentenCoded`, `Item`.`image`, `Item`.`enclosureUrl`, `Item`.`enclosureLength`, `Item`.`enclosureType`, `Item`.`site_id`, `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `items` AS `Item` INNER JOIN `sites` AS `Site` ON (`Item`.`site_id` = `Site`.`id`) WHERE `Item`.`site_id` IN (46,45,16,18,19,20,21,22,23,24,25,26,27,28,29,30,32,33,34,43,44,42,41) AND `Item`.`pubDate` >= DATE_SUB(CURDATE(),INTERVAL 1 DAY) ORDER BY `Item`.`pubDate` DESC LIMIT 2010101
6DESCRIBE `reports`10101
7INSERT INTO `reports` (`user_id`, `name`, `blog_source`, `pubDate`, `ipaddress`, `type`, `country`, `modified`, `created`) VALUES (NULL, 'listview', NULL, NULL, '54.91.82.25', 'indie', 'United States', '2014-09-02 17:37:13', '2014-09-02 17:37:13')10
8SELECT LAST_INSERT_ID() AS insertID110
9SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
10SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
11SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
12SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
13SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
14SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
15SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
16SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
17SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110
18SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_url`, `Site`.`site_rss`, `Site`.`status`, `Site`.`flag`, `Site`.`comments`, `Site`.`preset` FROM `sites` AS `Site` WHERE `Site`.`id` = 26 LIMIT 1110