| sql | time |
|
select id_celeb,nameceleb, ifnull(curscore,0) as score, ifnull((curscore-prevscore1),ifnull(curscore,0)) as scorediff, ifnull(prevscore1,0) as previous from r_Celeb order by curscore desc LIMIT 8
| 0.171304941177 |
|
select ugws.score,ugws.id_player,p.playername from r_UserGameWeekScore ugws
join usergame ug on ugws.id_usergame=ug.id_usergame
join players p on p.id_player=ug.id_player
where
date(adddate('2010-09-05', 0)) = ugws.weekdate
order by score desc
LIMIT 0,8
;
| 0.170537948608 |
Controller : register
Event : Go
View : register
View : vertical
View : toptable
View : toptable
View : adSquare
View : home
script : include/prototype-1.6.0.2.js
script : include/ajaxDropdown.js
script : scripts/gameselect.css
script : scripts/main.css
View : header_public
script : scripts/main.css
script : scripts/header_public.css
script : scripts/main.js
View : Tmaster
View : footer
script : scripts/gameselect.css
script : include/chat.js
script : include/ProtoChart.js
script : include/trade.js
script : include/ajaxdropdownB.js
script : test/ajaxr.js
script : include/footer2.css
script : scripts/main.css
script : scripts/main.css
script : scripts/main.css
script : _ajdd.addTarget('txtCelebFooter', 'celebs', {dir: 1});
View : table