Topic on Talk:Quarry

Jump to navigation Jump to search

Articles written by a single editor

Syced (talkcontribs)

I want to find all enwiki articles whose revisions have all been written by a unique editor (excluding editors with case-insensitive "bot" in their name).

How would you write such a query?

I get Unknown column 'rev_user' in 'where clause' when I try USE enwiki_p; SELECT rev_user FROM revision LIMIT 1

Achim55 (talkcontribs)
Syced (talkcontribs)

Wonderful, thanks a lot :-)