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: Ciara f. Nicki Minaj, "I'm Out"
9 Hrs. ago
2 Thao & The Get Down Stay Down - "Holy Roller" Video
9 Hrs. ago
3 Photos: The National @ Public Assembly, Brooklyn 5/21/13
9 Hrs. ago
4 Watch Coliseum Cover Eddie Money
9 Hrs. ago
5 TV Girl - "She Smokes In Bed" (Stereogum Premiere) Listen Song
10 Hrs. ago
6 An Interview With DMX's Son: Xavier Simmons Opens Up
10 Hrs. ago
7 Paris Hilton is Cash Money Records' Latest Signee
11 Hrs. ago
8 Stream: Las Rosas, "Black Cherry" + "Supposed 2 B"
11 Hrs. ago
9 Watch Empire Of The Sun Play "Alive" In Dallas
11 Hrs. ago
10 Backtrack: Woods At Rear House
11 Hrs. ago
11 Edward Sharpe and the Magnetic Zeros - "Better Days"
11 Hrs. ago
12 Mixtape Of The Week: Tree Sunday School II: When Church Lets Out
12 Hrs. ago
13 Video: Atmosphere - "Ain't Nobody"
12 Hrs. ago
14 The Lonely Island - "SEMICOLON" (Feat. Solange) Lyric Video
12 Hrs. ago
15 The 10 Best Rappers From Westchester County
13 Hrs. ago
16 Hear Ryan Hemsworth and A$AP DJs NYC Boiler Room 70 Minute Mix
13 Hrs. ago
17 Watch A New Boards Of Canada Video Screened In Tokyo Yesterday
13 Hrs. ago
18 Watch The xx and Jessie Ware Perform Together in Berlin
14 Hrs. ago
19 Deconstructing: Daft Punk, Will Oldham, And Two Decades Of Mysterious Musicianship
14 Hrs. ago
20 Watch Jessie Ware & The xx Cover Modjo & Stardust In Berlin
14 Hrs. ago
Previous
1 | 2 | 3 Next 1 of 3 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.226.5.29', 'indie', 'United States', '2013-05-23 14:39:34', '2013-05-23 14:39:34')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` = 21 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` = 21 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` = 21 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` = 21 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` = 32 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` = 21 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` = 21 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` = 21 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` = 21 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` = 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` = 21 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` = 21 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` = 21 LIMIT 1110