Created
September 30, 2013 07:03
-
-
Save meilhard/6760224 to your computer and use it in GitHub Desktop.
Forum SQL
This file contains hidden or 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; | |
| SELECT u.userid, COUNT(t.`threadid`) FROM thread t, `user` u WHERE FROM_UNIXTIME(u.joindate) > "2013-09-25" AND u.`userid` = t.`postuserid` GROUP BY u.userid ORDER BY u.userid; | |
| SELECT * FROM post p WHERE p.`userid` = 298934 | |
| SELECT * FROM thread t WHERE t.postuserid = 297439 | |
| SELECT * FROM `user` WHERE username = 'zmmoiuwawn' | |
| SELECT * FROM post WHERE userid = 297439 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment