This is a SCRIPT-8 cassette.
I hereby claim:
- I am meilhard on github.
- I am eilhard (https://keybase.io/eilhard) on keybase.
- I have a public key ASDBi9PSbWFCNNpD0O3uiLNkgbzmYPjp2Ato45uxIWdGbwo
To claim this, I am signing this object:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT u.userid, u.username, t.title FROM `user` u, thread t | |
WHERE FROM_UNIXTIME(u.joindate) > "2013-09-25" | |
AND u.userid = t.postuserid | |
GROUP BY u.userid, u.username | |
SELECT u.userid, u.username, COUNT(t.threadid) FROM thread t, `user` u WHERE t.postuserid NOT IN (SELECT userid FROM `user`) GROUP BY u.userid, u.username | |
SELECT u.userid, COUNT(p.postid) FROM post p, `user` u WHERE FROM_UNIXTIME(u.joindate) > "2013-09-20" AND u.`userid` = p.`userid` GROUP BY u.userid ORDER BY u.userid; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
git commit -am "`curl -s http://whatthecommit.com/index.txt`" |