Get daily anonymous edits from Italian Wikipedia

SQL

USE itwiki_p;
SELECT
    date,
    mobile_edits.count,
    edits.count,
    mobile_edits.count/edits.count AS proportion
FROM (
    SELECT 
        LEFT(rev_timestamp, 8) AS date,
        COUNT(*) AS count
    FROM revision_userindex
    INNER JOIN tag_summary ON 
        ts_rev_id = rev_id AND
        ts_tags LIKE "%mobile edit%" AND 
        ts_tags NOT LIKE "%mobile app edit%"
    WHERE 
        rev_timestamp BETWEEN "20141028" AND "20141114" AND
        rev_user = 0
    GROUP BY date
) AS mobile_edits
INNER JOIN (
    SELECT 
        LEFT(rev_timestamp, 8) AS date,
        COUNT(*) AS count
    FROM revision_userindex
    WHERE 
        rev_timestamp BETWEEN "20141101" AND "20141114" AND
        rev_user = 0
    GROUP BY date
) AS edits USING (date);
SQL

Checking query status...
