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 Shift K3Y - "I Know" (Bee's Knees Remix)
1 Days 5 Hrs. ago
2 Too Many Sebastians July Chart 2014
23 Hrs. ago
3 Paperwhite - "Take Me Back"
23 Hrs. ago
4 [PREMIERE] Cassicus - "All Wrapped Up"
23 Hrs. ago
5 Listen to a New Artist from the UK Label That Debuted Koreless and Lapalux
23 Hrs. ago
6 Video: Vaults - "Lifespan" Listen Song
21 Hrs. ago
7 Lil Silva and BANKS Collaborate on Slow-Burning "Don't You Love"
21 Hrs. ago
8 Premiere: Alison Valentine - "Pixie Dust" Listen Song
21 Hrs. ago
9 Ratking - "Canal (Ad-Rock Remix)" Listen Song
21 Hrs. ago
10 Download Fool's Gold's Draft Picks Compilation, with Brenmar, Salva and More
21 Hrs. ago
11 Fredo Santana & Childish Gambino Are a Shrewd Sight on "Riot"
20 Hrs. ago
12 William Arcane - "Stay A While" Listen Song
20 Hrs. ago
13 Banks - Drowning (Glass Animals Remix) Listen Song
20 Hrs. ago
14 Video: Lowell - "The Bells" Listen Song
19 Hrs. ago
15 Listen to Fredo Santana and Childish Gambino's "Riot," Produced by Young Chop Listen Song
19 Hrs. ago
16 Listen to Recycle Culture's Drown Me Up, Feel Better for 18 Minutes
18 Hrs. ago
17 While We Wait for Remy Ma to Come Home, Stream Mister Cee's #TBT Tribute Set
18 Hrs. ago
18 Snakehips - "After I Met U" Listen Song
18 Hrs. ago
19 Kendrick Lamar Will Be Debuting His Short Film m.A.A.d. at the Sundance NEXT Fest Listen Song
17 Hrs. ago
20 Video: Marz Leon - "Fire" Listen Song
17 Hrs. ago
Previous
1 | 2 Next 1 of 2 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` asc 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.198.132.223', 'indie', 'United States', '2014-08-01 22:27:36', '2014-08-01 22:27:36')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` = 41 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` = 28 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` = 41 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` = 41 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` = 32 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` = 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` = 32 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` = 32 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` = 18 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` = 32 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` = 26 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` = 26 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` = 26 LIMIT 1110