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 | Last Logged In | 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 |
Please know that cookies are required to operate and enhance our services as well as for advertising purposes. We value your privacy. If you are not comfortable with us using this information, please review your settings before continuing your visit. [close]