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