Mallineiden lisäystilasto: perustiedot wikidatassa

SQL

SELECT 
--	count(distinct(r1.rev_id)) as r1_c,
--	count(distinct(r2.rev_id)) as r2_c,
    r1.rev_timestamp as r1_ts,
    r2.rev_timestamp as r2_ts,
    DATEDIFF(STR_TO_DATE(r1.rev_timestamp, "%Y%m%d%H%i%s"), STR_TO_DATE(r2.rev_timestamp, "%Y%m%d%H%i%s")) as ts_diff
FROM 
    page as p,
    actor_revision as a1, 
    comment_revision, 
    revision as r1    
    LEFT JOIN revision as r2 ON r2.rev_page=r1.rev_page AND r2.rev_id>r1.rev_id
    LEFT JOIN actor_revision as a2 ON r2.rev_actor=a2.actor_id AND a2.actor_name NOT LIKE "Zache%"
WHERE 
	r1.rev_comment_id=comment_id 
    AND r1.rev_actor=a1.actor_id 
    AND a1.actor_name="ZacheBot" 
    AND r1.rev_id>21339849
    AND r1.rev_page = page_id
    AND page_namespace = 0
    AND comment_text LIKE "%erustiedot%" 
LIMIT 10
SQL

Checking query status...
