gistfile1.txt

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