![]() |
|
| HOME | PEOPLE/GROUPS | TEAMS | LEAGUES | EVENTS | VIDEOS | PHOTOS | CITY SITES | BLOGS |
| Newest Players | ||
|
select
b.PlayerID 'AddBy',
b.username,
ifnull((select virtualpath from LR_v_UserTinyThumb where playerid=b.playerid),concat('assets/avatars/Default_', b.UserType, '_Tiny.gif')) as TinyAvatar,
case ifnull(Nickname,'') when '' then b.username else b.username end as DisplayName,
b.PlayerTextID
from LR_v_UserInfo b
where b.PlayerID not in (115,1498,159)
and b.usertypeid=1
and b.userstatusid in (1,2)
order by b.adddate desc
limit 6 ------------------- 1242: Subquery returns more than 1 row | ||