use tewiki_p;

SELECT substr(rev_timestamp,1,8) as datee,COUNT(substr(rev_timestamp,1,8)) as mainspace_edits

FROM revision,actor,page,user,user_groups

WHERE actor_id=rev_actor

    and page_id=rev_page

    and page_namespace=0

    and user_id=actor_user

    and ug_user=user_id

    and ug_group!="bot"

    and substr(rev_timestamp,1,4)="2006"

GROUP BY substr(rev_timestamp,1,8)

ORDER BY substr(rev_timestamp,1,8)