Soca   |  Dancehall   |  Dub   |  Reggae   |  Ragga   |  Wyszukane   |  Komentarze

Najważniejsze albumy Wykonawcy Mighty Sparrow:

Volume Four
The Calypso King Of Trinidad
First Flight: Early Calypsos from the Emory Cook Collection
Volume One
Hot and Sweet
Volume Two
Soca Lover
Hot + Sweet
Soca 101 Vol. 3
Man in de Bedroom
The Supreme Serenader
Zesty
Hot Like Fire
Only a Fool
Rainbow Raani
Volume Three
Klassic Kitchener Vol 1
Klassic Kitchener
The Rough Guide to Calypso and Soca
Classic Kitchener, Vol. 1
Klassic Kitchener, Vol. 2
Caribana
Rough Trade Shops-Counter Cult
Island 40 Volume 1: 1959-1964 - Ska's The Limit
Klassic Kitchener, Volume 3
Longevity
Rough Trade Shops: Counter Culture 2002 (disc 2)
Klassic Kitchener Vol 2
Foul Play: The Best of Atmospheric Drum & Bass
Summer in the City: Latin Party
Ultra.Dance 06 (disc 1: Vic.Latino)
Fetenhits: Best of 2004 (disc 2)
Crossfade Dancehall Party 2004 (disc 1)
Festivalbar 2004 Compilation Blu (disc 1)
Hit 40 UK (disc 2)
Hot 97: Gold and Platinum Reggae, Volume 3
R&B Anthems 2005 (disc 1)
Bravo Black Hits, Volume 10 (disc 1)
Bravo Hits 44 (disc 1)
R&B Love (disc 1)
Pure Urban Essentials 2 (disc 1)
You, Me And She
Romantic Reggae
Dancehall 101 Vol. 2
Universal Smash Hits 2
Riddim Driven: Applause
Bisous Bisous (Pink)
Rodigan's 25th Anniversary (disc 1)
Liquid Riddim
Bling (disc 1)

Najpopulartniejsze utwoty Wykonawcy Mighty Sparrow

Jook For Jook
Monica Dou Dou
Teresa
Royal Jail
Benwood Dick
Russian Satellite
Sailor Man
Well Spoken Moppers
Village Ram
Reply to Melody
Mango Vert
No Money No Love
Harry in the Piggery
Jack Palance
Dan Is The Man (In The Van)
Yankees Gone
Carlton Peeping at Me
Paye
Don't Go Joe
Our Model Nation
Eve
Calypso Twist
Country Girl
Jean Marabunta
Dorothy
Mad Bomber
Robbery With V
Federation
Simpson (The Funeral Agency Man)
Sell the Pussy
Post Card To Sparrow
Gun Slingers
Short Little Shorts
Params
array(5) {
  ["module"]=>
  string(5) "index"
  ["controller"]=>
  string(5) "index"
  ["action"]=>
  string(6) "artist"
  ["id"]=>
  string(3) "156"
  ["name"]=>
  string(14) "mighty-sparrow"
}
Post
array(0) {
}
Session
object(ArrayObject)#238 (1) {
  ["lang"]=>
  string(2) "pl"
}
Authorisation
NULL
QueryExec timeParams
connect0.00041''
SET NAMES latin24E-05''
SELECT items.* FROM ( select * from ( select `vert_categories`.`id` AS `id`,`vert_categories`.`lang` AS `lang`,`vert_categories`.`name` AS `name`,`vert_categories`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_categories`.`edit_by` AS `edit_by`,`vert_categories`.`system` AS `system`,`vert_categories`.`publish_history` AS `publish_history`,`vert_categories`.`publish_start_date` AS `publish_start_date`,`vert_categories`.`publish_stop_date` AS `publish_stop_date`,`vert_categories`.`access` AS `access`,'categories' AS `type`, con0.first_priority AS first_priority, con0.second_type AS second_type from `vert_categories` JOIN vert_connections con0 ON 'categories' = REPLACE(con0.second_type, '_shortcut', '') AND `vert_categories`.`id` = con0.second_id WHERE con0.first_id = '165' and con0.first_type = 'categories' ORDER BY `vert_categories`.`lang` = 'pl' DESC) x0 GROUP BY x0.id UNION select * from ( select `vert_users`.`id` AS `id`,`vert_users`.`lang` AS `lang`,`vert_users`.`name` AS `name`,`vert_users`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_users`.`edit_by` AS `edit_by`,`vert_users`.`system` AS `system`,`vert_users`.`publish_history` AS `publish_history`,`vert_users`.`publish_start_date` AS `publish_start_date`,`vert_users`.`publish_stop_date` AS `publish_stop_date`,`vert_users`.`access` AS `access`,'users' AS `type`, con1.first_priority AS first_priority, con1.second_type AS second_type from `vert_users` JOIN vert_connections con1 ON 'users' = REPLACE(con1.second_type, '_shortcut', '') AND `vert_users`.`id` = con1.second_id WHERE con1.first_id = '165' and con1.first_type = 'categories' ORDER BY `vert_users`.`lang` = 'pl' DESC) x1 GROUP BY x1.id UNION select * from ( select `vert_tags`.`id` AS `id`,`vert_tags`.`lang` AS `lang`,`vert_tags`.`name` AS `name`,`vert_tags`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_tags`.`edit_by` AS `edit_by`,`vert_tags`.`system` AS `system`,`vert_tags`.`publish_history` AS `publish_history`,`vert_tags`.`publish_start_date` AS `publish_start_date`,`vert_tags`.`publish_stop_date` AS `publish_stop_date`,`vert_tags`.`access` AS `access`,'tags' AS `type`, con2.first_priority AS first_priority, con2.second_type AS second_type from `vert_tags` JOIN vert_connections con2 ON 'tags' = REPLACE(con2.second_type, '_shortcut', '') AND `vert_tags`.`id` = con2.second_id WHERE con2.first_id = '165' and con2.first_type = 'categories' ORDER BY `vert_tags`.`lang` = 'pl' DESC) x2 GROUP BY x2.id UNION select * from ( select `vert_artists`.`id` AS `id`,`vert_artists`.`lang` AS `lang`,`vert_artists`.`name` AS `name`,`vert_artists`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_artists`.`edit_by` AS `edit_by`,`vert_artists`.`system` AS `system`,`vert_artists`.`publish_history` AS `publish_history`,`vert_artists`.`publish_start_date` AS `publish_start_date`,`vert_artists`.`publish_stop_date` AS `publish_stop_date`,`vert_artists`.`access` AS `access`,'artists' AS `type`, con3.first_priority AS first_priority, con3.second_type AS second_type from `vert_artists` JOIN vert_connections con3 ON 'artists' = REPLACE(con3.second_type, '_shortcut', '') AND `vert_artists`.`id` = con3.second_id WHERE con3.first_id = '165' and con3.first_type = 'categories' ORDER BY `vert_artists`.`lang` = 'pl' DESC) x3 GROUP BY x3.id UNION select * from ( select `vert_albums`.`id` AS `id`,`vert_albums`.`lang` AS `lang`,`vert_albums`.`name` AS `name`,`vert_albums`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_albums`.`edit_by` AS `edit_by`,`vert_albums`.`system` AS `system`,`vert_albums`.`publish_history` AS `publish_history`,`vert_albums`.`publish_start_date` AS `publish_start_date`,`vert_albums`.`publish_stop_date` AS `publish_stop_date`,`vert_albums`.`access` AS `access`,'albums' AS `type`, con4.first_priority AS first_priority, con4.second_type AS second_type from `vert_albums` JOIN vert_connections con4 ON 'albums' = REPLACE(con4.second_type, '_shortcut', '') AND `vert_albums`.`id` = con4.second_id WHERE con4.first_id = '165' and con4.first_type = 'categories' ORDER BY `vert_albums`.`lang` = 'pl' DESC) x4 GROUP BY x4.id UNION select * from ( select `vert_tracks`.`id` AS `id`,`vert_tracks`.`lang` AS `lang`,`vert_tracks`.`name` AS `name`,`vert_tracks`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_tracks`.`edit_by` AS `edit_by`,`vert_tracks`.`system` AS `system`,`vert_tracks`.`publish_history` AS `publish_history`,`vert_tracks`.`publish_start_date` AS `publish_start_date`,`vert_tracks`.`publish_stop_date` AS `publish_stop_date`,`vert_tracks`.`access` AS `access`,'tracks' AS `type`, con5.first_priority AS first_priority, con5.second_type AS second_type from `vert_tracks` JOIN vert_connections con5 ON 'tracks' = REPLACE(con5.second_type, '_shortcut', '') AND `vert_tracks`.`id` = con5.second_id WHERE con5.first_id = '165' and con5.first_type = 'categories' ORDER BY `vert_tracks`.`lang` = 'pl' DESC) x5 GROUP BY x5.id UNION select * from ( select `vert_comments`.`id` AS `id`,`vert_comments`.`lang` AS `lang`,`vert_comments`.`name` AS `name`,`vert_comments`.`edit_date` AS `edit_date`, substr(edit_by, 1, ';') AS `create_by`,`vert_comments`.`edit_by` AS `edit_by`,`vert_comments`.`system` AS `system`,`vert_comments`.`publish_history` AS `publish_history`,`vert_comments`.`publish_start_date` AS `publish_start_date`,`vert_comments`.`publish_stop_date` AS `publish_stop_date`,`vert_comments`.`access` AS `access`,'comments' AS `type`, con6.first_priority AS first_priority, con6.second_type AS second_type from `vert_comments` JOIN vert_connections con6 ON 'comments' = REPLACE(con6.second_type, '_shortcut', '') AND `vert_comments`.`id` = con6.second_id WHERE con6.first_id = '165' and con6.first_type = 'categories' ORDER BY `vert_comments`.`lang` = 'pl' DESC) x6 GROUP BY x6.id) as items ORDER BY items.first_priority DESC 0.01408''
SELECT * FROM (SELECT * FROM vert_categories i WHERE i.id = ? ORDER BY i.lang DESC) ic 0.00051'176'
SELECT a.* FROM vert_artists a JOIN vert_connections c ON a.id = c.second_id AND REPLACE(c.second_type, '_shortcut', '') = 'artists' WHERE a.id = '156' LIMIT 1 0.00038''
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00055'156', 'artists'
SELECT * FROM vert_connections c WHERE c.first_type = ? AND c.second_type = ? ORDER BY c.first_priority DESC0.00066'categories', 'categories'
SELECT * FROM vert_categories i WHERE i.id IN (1, 165, 195) and i.lang = ? 0.00028'pl'
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.08436'156', 'artists'
select * from (select c.* from vert_categories c where id = ? order by lang = ? desc) a group by a.id LIMIT 1 0.00055'195', 'pl'
SELECT a.* FROM vert_albums a JOIN vert_connections c ON a.id = c.second_id AND c.second_type = 'albums' WHERE c.first_type = 'artists_attachments' AND c.first_id = '156' ORDER BY a.id ASC 0.00196''
SELECT t.* FROM vert_tracks t JOIN vert_connections c ON t.id = c.second_id AND c.second_type = 'tracks' WHERE c.first_type = 'artists_attachments' AND c.first_id = '156' ORDER BY t.id ASC 0.00195''
SELECT a.* FROM vert_artists a JOIN vert_connections c ON a.id = c.second_id AND REPLACE(c.second_type, '_shortcut', '') = 'artists' WHERE c.first_id = '195' AND c.first_type = 'categories' 0.00104''
Total: 13, Total queries time: 0.106765270233
TimestampMessageFrom last
1268254193 start getting matrix from dbcategories categories 1 -0.507847070694
1268254193 get all connection ids 0
1268254193 make matrix 0
1268254193 matrix done 0
Total: 0.957109928131 sec