Skip to content

Instantly share code, notes, and snippets.

View meilhard's full-sized avatar

Marc Eilhard meilhard

  • Native Instruments
  • Berlin
View GitHub Profile
@meilhard
meilhard / whatthecommit.sh
Created September 27, 2013 15:12
Commit with whatthecommit.com message
git commit -am "`curl -s http://whatthecommit.com/index.txt`"
@meilhard
meilhard / spam.sql
Created September 30, 2013 07:03
Forum SQL
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;

Keybase proof

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:

@meilhard
meilhard / README.md
Created February 18, 2019 09:44
SCRIPT-8