♀♂

SELECT COUNT(*) AS n FROM e107.e107_user INNER JOIN guild_members ON ( uid = user_id ) WHERE rank < 0 AND user_lastvisit = 0 [close]

SELECT user_id,user_name,user_join,user_lastvisit,user_currentvisit,rank FROM e107.e107_user INNER JOIN guild_members ON ( uid = user_id ) WHERE rank < 0 AND user_lastvisit = 0 ORDER BY user_join LIMIT 0,100 [close]

Accounts Not Activated (or banned)

User Name	Joined	Current Visit Time	Guild Rank
:D_4808_heloxgoodbye	Apr 3, 2011	Apr 3, 2011	-3
Matthewop	May 3, 2011	May 3, 2011	-1
lucus5	May 6, 2011	May 6, 2011	-1
lingmingrui	May 10, 2011	May 10, 2011	-1
msj00	Jun 22, 2011	Jun 22, 2011	-1
yiyad123	Jun 23, 2011	Jun 23, 2011	-1
enkeli2901	Jun 27, 2011	Jun 27, 2011	-1
dreamhigh	Jul 11, 2011	Jul 11, 2011	-1
guccishopg	Aug 16, 2011	Aug 16, 2011	-1
longyou	Sep 8, 2011	Sep 8, 2011	-1
Greenland	Sep 8, 2011	Sep 8, 2011	-1
Cierlmeyrin	Sep 12, 2011	Sep 12, 2011	-1
nianwushang	Sep 14, 2011	Sep 14, 2011	-1
nianzhizhi	Sep 14, 2011	Sep 14, 2011	-1
yinianzhizuo	Sep 14, 2011	Sep 14, 2011	-1
gogoo11	Sep 14, 2011	Sep 14, 2011	-1
panniai	Sep 19, 2011	Sep 19, 2011	-1
gogoo111	Sep 19, 2011	Sep 19, 2011	-1
moncler0108	Sep 20, 2011	Sep 20, 2011	-1
womendeyanghuo	Sep 20, 2011	Sep 20, 2011	-1
moncleroutlet14	Sep 21, 2011	Sep 21, 2011	-1
Paul	Sep 21, 2011	Sep 21, 2011	-1
nekokosuzu	Sep 24, 2011	Sep 24, 2011	-1
cef17930	Sep 25, 2011	Sep 25, 2011	-1
MAYUANI	Sep 25, 2011	Sep 25, 2011	-1
doudounemoncler3	Sep 28, 2011	Sep 28, 2011	-1
doudounemoncler4	Sep 29, 2011	Sep 29, 2011	-1
bottesugg	Oct 1, 2011	Oct 1, 2011	-1
bottesuggsales	Oct 2, 2011	Oct 2, 2011	-1
doudounemoncler5	Oct 4, 2011	Oct 4, 2011	-1
doudounemoncler6	Oct 5, 2011	Oct 5, 2011	-1
doudounemoncler7	Oct 6, 2011	Oct 6, 2011	-1
jobsstevs	Oct 8, 2011	Oct 8, 2011	-1
doudounemoncler8	Oct 9, 2011	Oct 9, 2011	-1
gogoo1111	Oct 13, 2011	Oct 13, 2011	-1
Mandy12	Oct 18, 2011	Oct 18, 2011	-1
nicezz	Oct 26, 2011	Oct 26, 2011	-1
Bella2011	Oct 29, 2011	Oct 29, 2011	-1
chilling	Oct 31, 2011	Oct 31, 2011	-1
doudounemoncler3i	Nov 4, 2011	Nov 4, 2011	-1
pinkie	Nov 4, 2011	Nov 4, 2011	-1
tsutsuji	Nov 11, 2011	Nov 11, 2011	-1
animeneverdie	Nov 14, 2011	Nov 14, 2011	-5
hong123456	Nov 14, 2011	Nov 14, 2011	-5
WhatTheFuuck	Nov 14, 2011	Nov 14, 2011	-1
Imp3rf3ctAng3lXOXO	Nov 14, 2011	Nov 14, 2011	-5
catske	Nov 14, 2011	Nov 14, 2011	-5
misakitakahashi	Nov 15, 2011	Nov 15, 2011	-5
jjlove33	Nov 16, 2011	Nov 16, 2011	-5
bageyalu	Nov 17, 2011	Nov 17, 2011	-5
Jumping Boy	Nov 17, 2011	Nov 17, 2011	-5
vincentbston	Nov 17, 2011	Nov 17, 2011	-1
rafaellsilvas	Nov 17, 2011	Nov 17, 2011	-5
Yoshikatzi	Nov 17, 2011	Nov 17, 2011	-5
Basokun	Nov 17, 2011	Nov 17, 2011	-5
Yoshikatzimi	Nov 17, 2011	Nov 17, 2011	-5
LoliRuri	Nov 17, 2011	Nov 17, 2011	-5
iammomiko	Nov 18, 2011	Nov 18, 2011	-5
xMisaex	Nov 18, 2011	Nov 18, 2011	-5
HayotoMisaki	Nov 18, 2011	Nov 18, 2011	-5
miley4	Nov 18, 2011	Nov 18, 2011	-5
sjcodan	Nov 18, 2011	Nov 18, 2011	-5
vegasmazza3	Nov 19, 2011	Nov 19, 2011	-5
zul	Nov 19, 2011	Nov 19, 2011	-5
haibara	Nov 19, 2011	Nov 19, 2011	-5
margelle	Nov 19, 2011	Nov 19, 2011	-5
遥遠's曙光	Nov 19, 2011	Nov 19, 2011	-5
Angelkitty28	Nov 19, 2011	Nov 19, 2011	-5
遥远的曙光	Nov 19, 2011	Nov 19, 2011	-5
2jy	Nov 19, 2011	Nov 19, 2011	-5
bobmf	Nov 19, 2011	Nov 19, 2011	-5
andidontgiveafuck	Nov 19, 2011	Nov 19, 2011	-1
TheTeardropsOfHope	Nov 19, 2011	Nov 19, 2011	-5
Scarlette	Nov 19, 2011	Nov 19, 2011	-5
liu22orz	Nov 20, 2011	Nov 20, 2011	-5
ApricotLily	Nov 20, 2011	Nov 20, 2011	-5
bh6060	Nov 21, 2011	Nov 21, 2011	-5
helex80	Nov 21, 2011	Nov 21, 2011	-5
STARHELEX	Nov 21, 2011	Nov 21, 2011	-5
linjia0312	Nov 21, 2011	Nov 21, 2011	-5
tora	Nov 21, 2011	Nov 21, 2011	-5
fakkith	Nov 21, 2011	Nov 21, 2011	-5
uuno33	Nov 21, 2011	Nov 21, 2011	-5
hzhasnal	Nov 21, 2011	Nov 21, 2011	-5
dausjasman	Nov 22, 2011	Nov 22, 2011	-5
Vhenjun410	Nov 22, 2011	Nov 22, 2011	-5
monclerdonna86	Nov 22, 2011	Nov 22, 2011	-5
sbirulostregone	Nov 22, 2011	Nov 22, 2011	-5
Lau Cheuk Lun	Nov 22, 2011	Nov 22, 2011	-5
omfichan	Nov 22, 2011	Nov 22, 2011	-5
polokill	Nov 22, 2011	Nov 22, 2011	-5
pxywvqxb	Nov 23, 2011	Nov 23, 2011	-5
yuzquepena	Nov 23, 2011	Nov 23, 2011	-5
meechemax	Nov 23, 2011	Nov 23, 2011	-5
kelebing	Nov 24, 2011	Nov 24, 2011	-5
monclerdonna106	Nov 24, 2011	Nov 24, 2011	-5
pointghost	Nov 24, 2011	Nov 24, 2011	-5
Raziff Azwiera	Nov 24, 2011	Nov 24, 2011	-5
weirdo_person5	Nov 24, 2011	Nov 24, 2011	-5
seichi_akahara	Nov 24, 2011	Nov 24, 2011	-5

1 2 3 4 5 92

Accounts Not Activated (or banned)

Dark Theme

Ads