Most blocked users?

[ManDownUnder]

There's a common theme in those pics. Clearly you prefer brunettes.

Or shaven...

[SpankMe]

mysql> select user.username as username, count(userlist.relationid) as count from userlist left join user on(user.userid = userlist.relationid) where type = 'ignore' group by username order by count desc limit 10;

+-----------------+-------+

| username        | count |

+-----------------+-------+

| skidMark        |    29 |

| Katman          |    16 |

| Sidewinder      |    14 |

| renegade master |    14 |

| dipshit         |    11 |

| carver          |    11 |

| boomer          |    11 |

| mikey           |     7 |

| Boob Johnson    |     6 |

| Patch           |     6 |

+-----------------+-------+

10 rows in set (0.04 sec)



mysql>

[SpankMe]

and most friends.

mysql> select user.username as username, count(userlist.relationid) as count from userlist left join user on(user.userid = userlist.relationid) where type = 'buddy' and friend = 'yes' group by username order by count desc limit 10;

+-------------+-------+

| username    | count |

+-------------+-------+

| Pussy       |   168 |

| DMNTD       |   162 |

| Zuki lover  |   157 |

| kiwifruit   |   127 |

| DUCATI*HARD |   121 |

| naphazoline |   116 |

| McJim       |   109 |

| TOTO        |   108 |

| Kittyhawk   |   107 |

| MyGSXF      |   102 |

+-------------+-------+

10 rows in set (0.09 sec)



mysql>

[Starky307]

mysql> select user.username as username, count(userlist.relationid) as count from userlist left join user on(user.userid = userlist.relationid) where type = 'ignore' group by username order by count desc limit 10;

+-----------------+-------+

| username        | count |

+-----------------+-------+

| skidMark        |    29 |

| Katman          |    16 |

| Sidewinder      |    14 |

| renegade master |    14 |

| dipshit         |    11 |

| carver          |    11 |

| boomer          |    11 |

| mikey           |     7 |

| Boob Johnson    |     6 |

| Patch           |     6 |

+-----------------+-------+

10 rows in set (0.04 sec)



mysql>

I have yet to ignore anyone, but the top three of this list are on my pay no attention too list.

[Maha]

So with the ignore list?
Does the name represent thier ignore list or, how many ignore lists they are on?

[SARGE]

Size isn't everything

... bastard...

yes it is...


i may need a coffee next week btw

[SARGE]

mysql> select user.username as username, count(userlist.relationid) as count from userlist left join user on(user.userid = userlist.relationid) where type = 'ignore' group by username order by count desc limit 10;

+-----------------+-------+

| username        | count |

+-----------------+-------+

| skidMark        |    29 |

| Katman          |    16 |

| Sidewinder      |    14 |

| renegade master |    14 |

| dipshit         |    11 |

| carver          |    11 |

| boomer          |    11 |

| mikey           |     7 |

| Boob Johnson    |     6 |

| Patch           |     6 |

+-----------------+-------+

10 rows in set (0.04 sec)



mysql>

wow .. skidmark on top!!!..


whoda thunk it?

[Trudes]

I've just realised there are some real whores on this site!!!

[Katman]

Woohoo!

Podium at last!

[The Stranger:Me]

your life is so sad bro

We have a winner!

Oh well, close. Keep trying.

[NighthawkNZ:Me]

I ignore every one... without using my ignore list

[Mom]

Laughing like hell about Zuki Lover having the 3rd highest number of friends on here. Joined the forum 19 days ago and has 20 posts to his credit. Spammed the members with membership requests, voila! He is in the top three for member friends.

Seriously, there has to be a few members that need to review that friends list...LOL

[Katman]

Laughing like hell about Zuki Lover having the 3rd highest number of friends on here. Joined the forum 19 days ago and has 20 posts to his credit. Spammed the members with membership requests, voila! He is in the top three for member friends.

Seriously, there has to be a few members that need to review that friends list...LOL

I'm surprised as a fellow Taupo resident that he hasn't targeted me. I must smell or something.

I'm still trying to figure out who he is.

[Mom]

I'm surprised as a fellow Taupo resident that he hasn't targeted me. I must smell or something.

I'm still trying to figure out who he is.

Hah, he knows all about you

Dont bother trying to work it out, I gave up on him when I did not get an invite

[psycho22]

I'm still trying to figure out who he is.

You and me both.Don't think I have even seen his bike around.