| sql | time |
|
select *,
abs(0.669641627311 - randomNum) `r`
from r_TopCelebNews
order by r;
| 0.252961874008 |
|
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.16833615303 |
|
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.16850399971 |
| SELECT m.id_message,m.id_player,m.time,m.message,u.playername,NOW() as curtime FROM messages as m,players as u WHERE m.id_player=u.id_player AND m.id_game=-1 AND UNIX_TIMESTAMP(m.time)>0 ORDER BY m.time DESC LIMIT 50 | 0.168120145798 |
|
select * from Event e
where length(e.text) > 0
order by e.date desc
limit 5
;
| 0.653218984604 |
Controller : default
Event : Go
View : vertical
View : vertical
View : topcelebnews
View : toptable
View : toptable
View : adSquare
View : horizontal
View : recentchat
View : recentnews
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 : 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
View : Tmaster
script : scripts/main.css
script : scripts/main.css
script : scripts/main.css
script : scripts/main.css
script : _ajdd.addTarget('txtCelebFooter', 'celebs', {dir: 1});
View : table