Topic on Talk:Quarry

This is resolved.

I have over 350,000 en.Wikipedia edits, so Xtools won't show me how many articles I have created. Can I get a count (or a tool to get a count) here? ~~~~

Yes, if you know your user_id, you can query like this:

select count(*)
  from revision
 where rev_user = <<your-user-id>>
   and rev_parent_id = 0

When rev_parent_id is 0, that means that's the first revision on the page, so it's the creation of the page. The rev_user field is the editor responsible for the revision.

I'll give it a try, thanks.

The query suggested by Milimetric will count all page creations (i.e. not just mainspace). Annoyingly, 'revision' doesn't have a mainspace field so this needs to be gotten from another table. Then we also need to exclude redirects by setting setting a limit on 'rev_len' and hoping that you didn't create many articles with a very small first revision. I'm working on this at https://quarry.wmflabs.org/query/24690

So I think my query there is right, but unfortunately it took > 30 mins to execute so doesn't produce any results. :(

I have given up worrying about this.