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

Najważniejsze albumy Wykonawcy Lord Kitchener:

London Is The Place For Me
Trojan Calypso Box Set
Mick's Tape (Mixed by Cassetteboy)
Trojan Mod Reggae Box Set
Compilation
Trojan Calypso Box Set (Disc 1)
Grandmaster Of Calypso
Trojan Mod Reggae Box Set (disc 1)
Trojan Calypso Box Set (disc 2)
Trojan Mod Reggae Box Set (disc 3)
London Is The Place For Me - Trinidadian Calypso in London, 1950-1956
Klassic Kitchener, Vol. 3
Klassic Kitchener, Volume 1
Klassic Kitchener, Volume 2
Word Of Mouth - September 2005
Rough Trade Shops Counter Culture [2002]
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 Lord Kitchener

Neighbour, Neighbour
Birth of Ghana
My Landlady
The Underground Train
My Wife's Nightie
Kitch in the Jungle
Sweet Jamaica
Kitch's Bebop Of Calypso
Saxophone No. 2
Kitch's Bebop Calypso
Piccadilly Folk
Saxaphone No. 2
Cricket Champions
If You're Brown
Rock N Roll Calypso
Nora
Smoke a Cigarette
Kitch Take It Easy
Black Pudding
Ah Bernice
Law and Order
Woman's Figure
Magistrate
Params
array(5) {
  ["module"]=>
  string(5) "index"
  ["controller"]=>
  string(5) "index"
  ["action"]=>
  string(6) "artist"
  ["id"]=>
  string(3) "149"
  ["name"]=>
  string(14) "lord-kitchener"
}
Post
array(0) {
}
Session
object(ArrayObject)#238 (1) {
  ["lang"]=>
  string(2) "pl"
}
Authorisation
NULL
QueryExec timeParams
connect0.00552''
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.0434''
SELECT * FROM (SELECT * FROM vert_categories i WHERE i.id = ? ORDER BY i.lang DESC) ic 0.03285'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 = '149' LIMIT 1 0.00048''
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00058'149', 'artists'
SELECT * FROM vert_connections c WHERE c.first_type = ? AND c.second_type = ? ORDER BY c.first_priority DESC0.01249'categories', 'categories'
SELECT * FROM vert_categories i WHERE i.id IN (1, 165, 195) and i.lang = ? 0.00606'pl'
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00057'149', 'artists'
select * from (select c.* from vert_categories c where id = ? order by lang = ? desc) a group by a.id LIMIT 1 0.01175'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 = '149' ORDER BY a.id ASC 0.94039''
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 = '149' ORDER BY t.id ASC 0.00183''
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.00107''
Total: 13, Total queries time: 1.05701446533
TimestampMessageFrom last
1268587776 start getting matrix from dbcategories categories 1 0.195770025253
1268587776 get all connection ids 0
1268587776 make matrix 0
1268587776 matrix done 0
Total: 2.01239514351 sec