daily pastebin goal


a guest Dec 16th, 2018 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT au.username, DATE(qab.created), count(*)
  2. FROM
  3. (
  4.   SELECT qa.id as id, qa.question_id as qid from questions_answer qa
  5.   GROUP BY qa.question_id
  6. ) as tablea JOIN questions_answer qab ON qab.id = tablea.id
  7. JOIN auth_user au ON qab.creator_id = au.id
  8. WHERE qab.created > '2012-01-01'
  9. GROUP BY au.id, DATE(qab.created)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand