Soca   |  Dancehall   |  Dub   |  Reggae   |  Ragga   |  Wyszukane   |  Komentarze
Binghi Rasta  »  Soca  »  Square One

Najważniejsze albumy Wykonawcy Square One:

Walk of Life
Field Gentian
In Full Bloom
Higher Heights
Superrappin: The Album
Round One
Fast Forward
Champions
Sweetness
Soca Gold 1998
Freerange Records Colour Series: Blue 02
Dj Thomilla - Genuine Draft
Soca Gold 1998
Jump Start
Masterblaster (disc 2)
New Jazz Deluxe 2 (disc 1)
Limited Edition
Soca Gold 2000
Fiesta Latina 2001
Hotter Than Hot
KSS Caribbean Sessions
Criacao
4 Sides
Mugshot
Walk on Life
Takin' You Underground
Sweetness - Sweet'ness
Dance 2004 (disc 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 Square One

When Lights Are Low
Applause
Knowledge is Knowledge
Countdown
From the Soul
Criacao
Unorthodox
Paradise Lost
Gangsta
Can't Mess
Taste of Life
Music & mobement
They Say...
Twilight
Loose Cannons
Last Words
Allah Power U
Skippy
Vesuvius (Justin Martin’s ‘i Hope It Doesn’t Blow’ Mix)
Nuttin' Changed
Dayz to Come
Swell Sounds
Vesuvius (Justin Martin's 'I Hope It Doesn't Blow' Mix)
Faluma
Nuttin Changed
Turn It Around
Cry
One World feat. Ali Vegas
Analyze
Wavelength
Parallel Fifths
Dreams
Music & Movement
Vesuvius (Justin Martin's I Hope It Doesn't Blow Mix)
Quick Step
New Worlds
Fallen Angels (feat. Patrice)
Vesuvius
Fallen Angels
Go Girls
One World (feat. Ali Vegas)
Dreams (feat. Izz)
Dreams feat. Izz
High Rise (Deepchild's Lil Mo' Booty Dub)
Nu England
Loose Cannons (feat. Providence & Yinka)
Breakaway
Innervision
Iron Bazodee
They Say
Params
array(5) {
  ["module"]=>
  string(5) "index"
  ["controller"]=>
  string(5) "index"
  ["action"]=>
  string(6) "artist"
  ["id"]=>
  string(3) "148"
  ["name"]=>
  string(10) "square-one"
}
Post
array(0) {
}
Session
object(ArrayObject)#238 (1) {
  ["lang"]=>
  string(2) "pl"
}
Authorisation
NULL
QueryExec timeParams
connect0.00021''
SET NAMES latin23E-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.02088''
SELECT * FROM (SELECT * FROM vert_categories i WHERE i.id = ? ORDER BY i.lang DESC) ic 0.00036'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 = '148' LIMIT 1 0.00021''
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.0004'148', 'artists'
SELECT * FROM vert_connections c WHERE c.first_type = ? AND c.second_type = ? ORDER BY c.first_priority DESC0.00054'categories', 'categories'
SELECT * FROM vert_categories i WHERE i.id IN (1, 165, 195) and i.lang = ? 0.00017'pl'
SELECT * FROM vert_connections c WHERE c.second_id = ? and c.second_type = ? ORDER BY c.second_priority DESC0.00037'148', 'artists'
select * from (select c.* from vert_categories c where id = ? order by lang = ? desc) a group by a.id LIMIT 1 0.00032'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 = '148' ORDER BY a.id ASC 0.00171''
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 = '148' ORDER BY t.id ASC 0.01421''
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.00095''
Total: 13, Total queries time: 0.0403597354889
TimestampMessageFrom last
1268358377 start getting matrix from dbcategories categories 1 -0.318243980408
1268358377 get all connection ids 0
1268358377 make matrix 0
1268358377 matrix done 0
Total: 0.759341955185 sec