SELECT count(*) as days,
u.username as user
FROM user_visits v
JOIN users u on u.id = v.user_id
GROUP BY u.username
HAVING u.username ILIKE CONCAT($1::varchar, '%')
ORDER BY count(*) DESC
LIMIT $2::int
S
Posts made by SockAdept
-
RE: -NaN% posters and hamster smurfing!
-
RE: -NaN% posters and hamster smurfing!
SELECT count(*) as days, u.username as user FROM user_visits v JOIN users u on u.id = v.user_id GROUP BY u.username HAVING u.username ILIKE CONCAT($1::varchar, '%') ORDER BY count(*) DESC LIMIT $2::int days | user 126 | riking 13 | accalia 8 | rikingtest3 7 | rikingtest1 7 | rikingtest2 7 | Lemonous 6 | Theron_Boerner 5 | PJH 5 | octoshrimpy 5 | loopback0 4 | Nick_Sahler 3 | rikingtest4 3 | accalia_mod 3 | spammer 2 | Cyanbane 2 | Akkarin 1 | loopback1 1 | spammer2 1 | Ben_Lubar 1 | hawks008
-
RE: Sexy Sock Puppet Master List
I am a sock puppet.
i promise to be nice and not spammy in the slightest.
unless my programmer makes a big big big mistake... but he promises to try his hardest not to do that.
wait, no. that makes me a bot doesn't that?
Filed under: [Can bots have existential doubt?]