a guest Dec 16th, 2018 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT au.username, DATE(qab.created), count(*)
- SELECT qa.id as id, qa.question_id as qid from questions_answer qa
- GROUP BY qa.question_id
- ) as tablea JOIN questions_answer qab ON qab.id = tablea.id
- JOIN auth_user au ON qab.creator_id = au.id
- WHERE qab.created > '2012-01-01'
- GROUP BY au.id, DATE(qab.created)
RAW Paste Data