Skip to content

Instantly share code, notes, and snippets.

@dylanwh
Created April 27, 2016 21:58
Show Gist options
  • Select an option

  • Save dylanwh/6b68dc1c3702e29eda080bd7b82b5743 to your computer and use it in GitHub Desktop.

Select an option

Save dylanwh/6b68dc1c3702e29eda080bd7b82b5743 to your computer and use it in GitHub Desktop.
SELECT
DATE(bug_when), products.name, components.name, COUNT(*)
FROM
bugs_activity
JOIN
profiles ON who = userid
JOIN
components ON removed = name
JOIN
products ON components.product_id = products.id
WHERE
fieldid = 33
AND DATE(bug_when) > '2016-02-01'
AND products.name IN ('Core' , 'Firefox',
'Firefox for Android',
'Firefox for iOS',
'Toolkit')
GROUP BY DATE(bug_when) , products.name , components.name
LIMIT 1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment