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 Clipez - Sensual Listen Song
1 Days 2 Hrs. ago
2 video: jj - Inner Light
17 Hrs. ago
3 Basement Jaxx Listen Song
16 Hrs. ago
4 Basement Jaxx Listen Song
16 Hrs. ago
5 QT (SOPHIE & A. G. Cook) - Hey QT (full version)
16 Hrs. ago
6 15 Rapper/Producer Collaborations That We Never Would Have Predicted Listen Song
15 Hrs. ago
7 Merely - princess hervor
15 Hrs. ago
8 listen to SOPHIE's Boiler Room LA set
14 Hrs. ago
9 Premiere: King Fantastic - "Los Angeles International" Listen Song
14 Hrs. ago
10 Premiere: K. Rudd ft. Danny Seth - "Waiting to Exhale" Listen Song
13 Hrs. ago
11 Emile Haynie ft. Charlotte Gainsbourg, Devonté Hynes and Sampha - "A Kiss Goodbye" Listen Song
13 Hrs. ago
12 Slow Magic - "Waited 4 U" Listen Song
12 Hrs. ago
13 This is How Rick Rubin Does the Ice Bucket Challenge Listen Song
12 Hrs. ago
14 The Rural Alberta Advantage - "On The Rocks"
12 Hrs. ago
15 RAC - "Cheap Sunglasses" Ft. Matthew Koma (The Knocks Remix)
12 Hrs. ago
16 A Beautiful Drive: In Conversation With Rome Fortune, One of Atlanta's Most Creative Artists Listen Song
12 Hrs. ago
17 Golden Coast - "Dream And An MPC"
12 Hrs. ago
18 Watch Raury Discuss Signing a Deal With Columbia Records Listen Song
11 Hrs. ago
19 Ryan Hemsworth ft. Tomggg - "Cream Soda" Listen Song
11 Hrs. ago
20 SomeKindaWonerful Google Hangout today! + Album Stream
11 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 6 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` 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.82.58.13', 'indie', 'United States', '2014-08-27 14:55:22', '2014-08-27 14:55:22')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` = 18 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` = 22 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` = 34 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` = 34 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` = 22 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` = 22 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` = 22 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` = 41 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` = 41 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` = 26 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` = 41 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` = 41 LIMIT 1110