BLOGOLATOR Latest Items Display

Member Login

Lost your password?

Not a member yet? Sign Up!

 
LOG IN | REGISTER
Facebook BlogolatorMyspace BlogolatorTwitter Blogolator

Song Title/Artist Blog Source Recent
1 Stream: Lykke Li, "Gunshot"
11 Hrs. ago
2 Download The Devil's VIOLENCE Mixtape
12 Hrs. ago
3 Stream: Jazmin Sisters f. Iamsu!, "You"
12 Hrs. ago
4 Blitz The Ambassador ft. Nneka - "Love On The Run" Listen Song
15 Hrs. ago
5 Glass Animals - "Pools" Listen Song
16 Hrs. ago
6 Watch the Dreamy Video for Deadboy's New Track "Return" Listen Song
16 Hrs. ago
7 FADER Mix: Tycho
18 Hrs. ago
8 Nelly - "Ride Wit Me" (Viceroy "Jet Life" Remix)
18 Hrs. ago
9 Pharrell, Hans Zimmer, & Johnny Marr - "Here" Listen Song
18 Hrs. ago
10 Listen to Lykke Li's New Song "Gunshot" Listen Song
18 Hrs. ago
11 Download The Boondocks Free Mixtape ft. Killer Mike & Alchemist Listen Song
18 Hrs. ago
12 Premiere: Montreal Sex Machine - "Blackout" Listen Song
18 Hrs. ago
13 Sd Laika - "Great God Pan" Listen Song
19 Hrs. ago
14 Watch the Cinematic Video for Jon Waltz's "Bang" Listen Song
20 Hrs. ago
15 Daily Discovery: Kidepo, a 23-Year-Old Singer/Producer With a Knack For Understated Soul Listen Song
20 Hrs. ago
16 Put It On - Big L (J1K remix) Listen Song
21 Hrs. ago
17 Stream: Ablebody, "After Hours"
21 Hrs. ago
18 Stream: Mirage, "Do You Remember"
22 Hrs. ago
19 Stream: Cancer, "Same Color as Digital Photography"
23 Hrs. ago
20 Download a Stormy Mix from Darkstar Ahead of Their US Tour
23 Hrs. ago
Previous
Next
1 of 1 More than 24 hrs
[Grab This/Embed] | More Topics | Create Your Blogolator
(default) 28 queries took 7 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) 112
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 2020202
6DESCRIBE `reports`10101
7INSERT INTO `reports` (`user_id`, `name`, `blog_source`, `pubDate`, `ipaddress`, `type`, `country`, `modified`, `created`) VALUES (NULL, 'listview', NULL, NULL, '54.211.153.104', 'indie', 'United States', '2014-04-17 22:07:21', '2014-04-17 22:07:21')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` = 32 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` = 32 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` = 32 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` = 32 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` = 41 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
19SELECT `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
20SELECT `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
21SELECT `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
22SELECT `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
23SELECT `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
24SELECT `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` = 18 LIMIT 1110
25SELECT `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` = 32 LIMIT 1110
26SELECT `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` = 32 LIMIT 1110
27SELECT `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` = 32 LIMIT 1110
28SELECT `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` = 32 LIMIT 1110