User:Zocky/Article survey

What I need

A query to produce a list of 1000 random articles, with the following data both for the article page and for the talk page (all at the chosen cut-off date):

• Revision number
• Date of creation
• Creator logged in or not
  • If yes, date of account creation
• Number of edits
• Number of edits by logged in editors
• Number of editors
• Number of logged in editors
• Date of last edit
• Last editor logged in or not
• Number of sections
• Number of characters

The following make sense just for the article page:

• Number of direct links to the article
• Number of redirects to the article
• Number of redirected links to the article
• Number of people watching the article
• Number of admin rollbacks in the history
• Number of images
• Number of categories

Additional data that would be nice but could possibly be tricky to get with SQL; could possibly be found out manually.

• Creator's edit count at time of creation
• Average edit count of editors at time of contribution

Classification

Articles will be classified by (at least) two criteria. This is the current draught:

Encyclopedicity

Articles rated by where one would expect to find them.

• Encyclopedia

  Things you would find in any large general-purpose encyclopedia

• Almanac

  Topics that are included because they are members of a well defined notable category.

• Cruft

  Topics that are included because they are members of a badly defined or instantly expandable category.

• Non-notable

  Articles that would likely not survive AfD for lack of notability

• Speedy

  Valid candidates for speedy deletion

Condition

What superficial state the article is in. Proper review of presented information is way outside the scope of this little survey.

• CSD

  Valid candidates for speedy deletion

• Neglected

  Articles that need attention from experienced users, i.e. unformatted, unwikified, etc. pages.

• Stub

  Articles that provide only the definition and rudimentary links.

• Short article

  Short proper articles, up to several paragraphs.

• Medium article

  Medium proper articles, up to several screen-fuls

• Long article

  Elaborate coverage of a topic, proper section structure

• FA candidate

  Pages that are FA candidates or look like they could be reasonably proposed as a Featured Article candidates

• Featured article

  If any popup in the smallish sample.

• Short list
• Medium list
• Long list
• Dissambiguation