Page MenuHomePhabricator

DBQ-133 some data for the selected English articles
Closed, ResolvedPublic

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-133.
Summary: some data for the selected English articles
Issue type: Task - A task that needs to be done.
Priority: Major
Status: Done
Assignee: Hoo man <hoo@online.de>


From: Minn Seok Choi <MinnSeok.Choi@gmail.com>

Date: Sun, 27 Mar 2011 08:45:07

I had selected the following 904 articles from the statistics of 2010 December about English WP pageview as you can see in the section of the article list below. I need several variables for each article:
(01) "quality" grade for each article (format: FA, A, GA, B, C, Start, Stub, Not assessed)
(02) "article size" (bytes)
(03) the number of total "article edits" since the article was created
(04) the number of total "article editors" since the article was created
(05) the number of total "article IP editors" since the article was created
(06) "discussion size" (bytes)
(07) the number of total "discussion edits" since the article was created
(08) the number of total "discussion IP editors" since the article was created
(10) the time when the article was created (format: 2002-02-02)
(11) the number of edits of the editor who rank on the top in the number of edit by unique editors
(12) the number of edits of the editor who rank on the second in the number of edit by unique editors
(13) the number of edits of the editor who rank on the third in the number of edit by unique editors
(14) the URL of the article (format: http://en.wikipedia.org/wiki/......)

the article list

127 Hours
2 Girls 1 Cup
2010 FIFA World Cup
2010-11 UEFA Champions League
2012 phenomenon
2014 FIFA World Cup
2018 and 2022 FIFA World Cup bids
24 (TV series)
3G
4chan
50 Cent
555 timer IC
90210 (TV series)
A
A Christmas Carol
A Christmas Story
A Very Glee Christmas
Abraham Lincoln
Absinthe
Acropolis of Athens
Adam Sandler
Adolf Hitler
Adriana Lima
Affiliate marketing
Afghanistan
Africa
Agnosticism
Akon
Albert Einstein
Amazon Kindle
American Civil War
America's Next Top Model
Anal sex
ANALOG COMPUTER
Android (operating system)
Angelina Jolie
Anne Hathaway (actress)
Anonymous (group)
Arnold Schwarzenegger
Asperger syndrome
Assassin's Creed: Brotherhood
Attack on Pearl Harbor
Auld Lang Syne
Australia
Avatar (2009 film)
Avatar: The Last Airbender
Ball-jointed doll
Barack Obama
Batman
Benjamin Millepied
Bernard Madoff
Black Swan (film)
Black swan theory
Bleach (manga)
Boardwalk Empire
Boeing X-37
Bones (TV series)
Boxing Day
Brad Pitt
Brazil
Bruce Lee
Bruno Mars
Buche de Noel
California
Californication (TV series)
Call of Duty: Black Ops
Canada
Castle (TV series)
Cee Lo Green
Celebrity sex tape
Characters of Glee
China
Chris Brown (American singer)
Christmas
Christmas tree
Chuck (TV series)
Cloud computing
Communist Russia
Community (TV series)
Cristiano Ronaldo
CSI: Crime Scene Investigation
Daft Punk
December 2010 lunar eclipse
Demi Lovato
Detox (Dr. Dre album)
Devil (film)
Dexter (season 5)
Dexter (TV series)
Doctor Who
Don't ask, don't tell
Dr. Dre
Drake (entertainer)
Dwayne Johnson
Eduardo Saverin
Eggnog
Elizabeth Edwards
Elizabeth II
Eminem
Emma Stone
Emma Watson
England
English language
Entourage (TV series)
Europe
European Union
F
Facebook
Family Guy
Fast Five (film)
Fergie (singer)
Festivus
France
Freemasonry
Friends
Fringe (TV series)
Geographic coordinate system
George VI of the United Kingdom
Georges St-Pierre
Germany
Glee (season 2)
Glee (TV series)
Global warming
Go (game)
Google
Gossip Girl (season 4)
Gossip Girl (TV series)
Grand Theft Auto (series)
Grey's Anatomy
Halloween
Hank Baskett
Hannah Montana (season 4)
Hanukkah
Harry Potter
Harry Potter (film series)
Harry Potter and the Deathly Hallows
Harry Potter and the Deathly Hallows (film)
Henry VIII of England
Heroes (TV series)
Holiday greetings
Hotmail
House (TV series)
How I Met Your Mother
How I Met Your Mother (season 6)
Hugh Hefner
Human penis size
Hydrogen
Hypertext Transfer Protocol
Inception (film)
India
initial
International Standard Book Number
Internet
Islam
Israel
Italy
J
Jake Gyllenhaal
Jane Austen
Japan
Jay-Z
Jeff Bridges
Jersey Shore (TV series)
Jesus
Jim Carrey
John Cena
John F. Kennedy
John Lennon
Johnny Depp
Julian Assange
Julie Andrews
Justin Bieber
K
Kanye West
Katy Perry
Kesha
Kim Kardashian
Kwanzaa
Lady Gaga
Leonardo da Vinci
Leonardo DiCaprio
Leslie Nielsen
Lil Wayne
Lionel Messi
Little Fockers
London
Lost (TV series)
Loud (Rihanna album)
Lunar eclipse
Macaulay Culkin
Madonna (entertainer)
Mariah Carey
Mark David Chapman
Mark Wahlberg
Mark Zuckerberg
Marvel vs. Capcom 3: Fate of Two Worlds
Masturbation
Megan Fox
Merlin (TV series)
Mexico
Michael Jackson
Michael Jordan
Micky Ward
Microsoft
Mila Kunis
Miley Cyrus
Misfits (TV series)
Modern Family
My Beautiful Dark Twisted Fantasy
Mythical creature
Naruto
Natalie Portman
NCIS (TV series)
Neil Patrick Harris
Nepal
Netherlands
New Year's Eve
New York City
New Zealand
Nicki Minaj
Nicole Scherzinger
No Mercy (T.I. album)
North Korea
Olivia Wilde
One Tree Hill (TV series)
Oud
Pakistan
Paramore
Paul McCartney
People's Republic of China
Philippines
Pierogi
Pink (singer)
Pink Friday
Pirates of the Caribbean (film series)
Pirates of the Caribbean: On Stranger Tides
PlayStation 3
Poland
Pretty Little Liars (TV series)
Prince (musician)
Qatar
Quantum Leap
Queen (band)
Recovery (Eminem album)
Richard Holbrooke
Rick Ross (rapper)
Rihanna
RMS Titanic
Rosa Parks
Russell Brand
Russia
Ryan Reynolds
Saint Basil's Cathedral
Saint Nicholas
Salvia divinorum
Santa Claus
Scarlett Johansson
Scott Pilgrim vs. the World
Scrubs (TV series)
Sean Parker
Search
Selena Gomez
September 11 attacks
Seven deadly sins
Sex
Sexual intercourse
Shake It Up (TV series)
Shaquille O'Neal
Singapore
Skins (TV series)
Skyline (film)
Slipknot (band)
Sons of Anarchy
South Africa
South Korea
Spain
Spartacus: Blood and Sand
Special Education (Glee)
Standard deviation
Supernatural (TV series)
Survivor: Nicaragua
Sweden
Tangled
Taylor Swift
Teena Marie
The Beatles
The Big Bang Theory
The Black Eyed Peas
The Chronicles of Narnia
The Chronicles of Narnia (film series)
The Chronicles of Narnia: Prince Caspian
The Chronicles of Narnia: The Voyage of the Dawn Treader
The Dark Knight (film)
The Expendables (2010 film)
The Fighter (2010 film)
The Green Hornet (2011 film)
The Hangover (film)
The Office (U.S. TV series)
The Social Network
The Tourist (2010 film)
The Town (2010 film)
The Twelve Days of Christmas (song)
The Twilight Saga: Breaking Dawn
The Ultimate Fighter: Team GSP vs. Team Koscheck Finale
The Vampire Diaries
The Vampire Diaries (season 2)
The Walking Dead
The Walking Dead (TV series)
The X Factor (UK series 7)
The X Factor (UK)
Theodore Roosevelt
Thor (film)
Titanic (1997 film)
TLC: Tables, Ladders & Chairs (2010)
Top Gear (2002 TV series)
Transformers: Dark of the Moon
Triple H
Tron (film)
Tron: Legacy
Tron: Legacy (soundtrack)
True Blood
True Grit (2010 film)
Tupac Shakur
Turkey
Twilight (series)
Two and a Half Men
UFC 124
UFC 125
UFC 126
UFC 127
UFC: Fight For The Troops 2
United Kingdom
United States
United States diplomatic cables leak
Unstoppable (2010 film)
User Datagram Protocol
Usher (entertainer)
Vagina
Vietnam War
Weeds (TV series)
White Christmas (film)
Wiki
WikiLeaks
Wikipedia
Will Smith
William Shakespeare
Willow Smith
Winter solstice
Wiz Khalifa
Wonders of the World
World War I
World War II
Xbox 360
X-Men Origins: Wolverine
X-Men: First Class (film)
YouTube
AIDS
Aishwarya Rai
Al Capone
Al Pacino
Alaska
Alexander the Great
Alimony
Alistair Overeem
Amber Heard
Amelia Earhart
Amy Adams
Andrew Garfield
Angry Birds
Animal
Antarctica
Apple Inc.
Area 51
Aretha Franklin
Argentina
Aristotle
Aron Ralston
Arsenal F.C.
Ashton Kutcher
Assassin's Creed
Association football
Atomic bombings of Hiroshima and Nagasaki
Audrey Hepburn
Austria
Autism
Avenged Sevenfold
Avril Lavigne
B.o.B
Bangladesh
Banksy
Barbra Streisand
Basketball
Bedbug
Belarus
Belgium
Ben Affleck
Ben Folds
Ben Stiller
Benjamin Franklin
Bermuda Triangle
Beyonce Knowles
Biblical Magi
Big Time Rush
Bill Clinton
Bill Gates
Bing Crosby
Biological classification
Bipolar disorder
Black swan
Blake Edwards
Blake Lively
Blood pressure
Blood type
Blu-ray Disc
Bob Dylan
Bob Marley
Bradley Manning
Breaking Bad
Breast
Brett Favre
Britney Spears
Brittany Murphy
Brock Lesnar
Bruce Boxleitner
Bruce Willis
Buddhism
Bulgaria
Burj Khalifa
Burlesque (film)
Burn Notice
Business
C (programming language)
C. S. Lewis
Call of Duty
Cameron Diaz
Cameron Newton
Camille Donatacci
Cancer
Cannabis (drug)
Captain Beefheart
Cat
Charles Dickens
Charles Manson
Charles, Prince of Wales
Charlie Sheen
Che Guevara
Chelsea Handler
Cher
Chernobyl disaster
Cheryl Cole
Chicago
Chili pepper
Chinese language
Chinese New Year
Chris Colfer
Christian Bale
Christianity
Christina Aguilera
Christine O'Donnell
Christmas Eve
Christopher Columbus
Christopher Nolan
Chuck Norris
Circumcision
Clint Eastwood
Clitoris
Cocaine
Coen brothers
Cold War
Coldplay
Colombia
Communism
Computer
Concorde
Coronation Street
Cote d'Ivoire
Criminal Minds
Crystal Harris
Cthulhu
Cuba
Dakota Fanning
Daniel Lambert
Daniel Radcliffe
Darren Aronofsky
Darren Criss
Dave Batista
David Bowie
Deadmau5
Death of John Lennon
Demi Moore
Denial-of-service attack
Denmark
Desperate Housewives
Despicable Me
Diana, Princess of Wales
Dianna Agron
Digital object identifier
DNA
Dog
Don Meredith
Dragon Ball
DREAM Act
Drew Barrymore
Dubai
Dubstep
Dustin Moskovitz
Earth
Easy A
Ebenezer Scrooge
Eddie Murphy
Edward VIII of the United Kingdom
Egypt
Ejaculation
Elizabeth Hurley
Elizabeth I of England
Ellen Page
Elton John
Elvis Presley
Emma Roberts
Emoticon
Enrique Iglesias
Epic Mickey
Eric Roberts
Euro
F-35 Lightning II
Fahrenheit
Far East Movement
Fascism
Favicon.ico
favicon.ico
Faye Resnick
FC Barcelona
Fellatio
Female ejaculation
Fidel Castro
FIFA World Cup
Finland
First Amendment to the United States Constitution
Florence and the Machine
Forbes list of billionaires
Four (energy drink)
Fourteenth Amendment to the United States Constitution
Frank Sinatra
Franklin D. Roosevelt
Freddie Mercury
Fuck
Futurama
Garrett Hedlund
Gene Simmons
George Clooney
George Harrison
George W. Bush
George Washington
Girls' Generation
Glee
Globalization
Google search
Gorillaz
Gout
Great Depression
Great Wall of China
Greece
Greek alphabet
Green Lantern
Gross domestic product
Gulliver's Travels
Gwyneth Paltrow
Hannah Montana
Harrison Ford
Hawaii
Hayley Williams
HDMI
Heath Ledger
Helena Bonham Carter
Hemorrhoid
Henry IV of France
Herpes simplex
Hilary Duff
Hinduism
HIV
Home Alone
Hong Kong
Hugo Strange
Human
Hungary
Ian Somerhalder
ICarly
Iceland
Illuminati
Indian classical dance
Indonesia
Industrial Revolution
IOS jailbreaking
IPad
IPhone
IPod Touch
Iran
Ireland
Isaac Newton
Isabelle Caro
It's a Trap!
It's a Wonderful Life
It's Always Sunny in Philadelphia
Ivy League
Jack Black
Jackie Chan
Jaden Smith
James Bond
James Franco
Japanese language
Jared Leto
Jason Segel
Jason Statham
Jeffrey Dahmer
Jenna Jameson
Jennifer Aniston
Jessica Alba
Jim Morrison
Jimi Hendrix
Jimmy Wales
Joaquin Phoenix
John Edwards
John F. Kennedy assassination
John Wayne
Joseph Gordon-Levitt
Joseph Stalin
Josh Koscheck
Judy Garland
Julia Roberts
Julius Caesar
Justin Timberlake
Kama Sutra
Kate Middleton
Katrina Kaif
Keeping Up with the Kardashians
Keira Knightley
Kelsey Grammer
Keri Hilson
Kevin Bacon
Keyshia Cole
Khloe Kardashian
Kid Cudi
Kinect
Kings of Leon
Kobe Bryant
Korean War
Kourtney Kardashian
Kristen Stewart
Ku Klux Klan
Kurt Cobain
L
Last Train to Paris
Lea Michele
LeBron James
Led Zeppelin
Liam Neeson
Like a G6
Lindsay Lohan
Linkin Park
Liu Xiaobo
LOL
Los Angeles
Louis Althusser
Love
Love Actually
Love and Other Drugs
Ludwig van Beethoven
M16 rifle
Mad Men
Malaysia
Malware
Manchester United F.C.
Manny Pacquiao
Marilyn Monroe
Martin Luther
Martin Luther King, Jr.
Maslow's hierarchy of needs
Matt Damon
MDMA
Megamind
Meningitis
Metallica
Methamphetamine
Michael Buble
Michael C. Hall
Michael Oher
Michael Sheen
Michael Vick
Mike Tyson
Minecraft
Miranda Cosgrove
Mistletoe
Mohandas Karamchand Gandhi
Mona Lisa
Moon
Morocco
Mount Fuji
Muhammad
Muhammad Ali
Multiple sclerosis
Muse (band)
My Chemical Romance
Napoleon I
Narcissism
National Football League
Nazi Germany
Nelly
Nelson Mandela
New York
Nicolas Cage
Nicole Polizzi
Nigeria
Nikola Tesla
Nintendo 3DS
Norway
Nudity
Operating system
Oprah Winfrey
Oral sex
Orgasm
Ottoman Empire
Owen Wilson
Pablo Picasso
Paper size
Paris
Parkinson's disease
Patrick Swayze
Penis
Periodic table
Peyton Manning
Pi
Pink Floyd
Playboy
Pneumonia
Ponzi scheme
Pornographic actor
Pornography
Premier League
President of the United States
Prince William of Wales
Psych
Psychology
PubMed Identifier
Puerto Rico
QR Code
Queen Victoria
Rachel McAdams
Rachel Uchitel
RAID
Real Madrid C.F.
Red Dead Redemption
Red Hot Chili Peppers
Reese Witherspoon
Reindeer
Renaissance
Republican Party (United States)
Resident Evil
Richard Nixon
Ringo Starr
Robert De Niro
Robert Kardashian
Robert Pattinson
Rogers' Rangers
Roman Empire
Romania
Rome
Ronald Reagan
Rosie Huntington-Whiteley
RSS
Rudolph the Red-Nosed Reindeer
Sachin Tendulkar
Sahara
Sailor Moon
Salman Khan
Sandra Bullock
Santa Claus's reindeer
Sarah Palin
Sasha Grey
Saudi Arabia
Schizophrenia
Scientology
Scoleciphobia
Scotland
Scott Pilgrim
Sean Combs
Secure Digital
Serbia
Serial ATA
Sex positions
Shahrukh Khan
Shakira
Shaun Ryder
Sherlock Holmes
Shia LaBeouf
Shirley Temple
Sigmund Freud
Skype
Small penis rule
Smallville
Snoop Dogg
Solar eclipse
Solstice
South Park
Soviet Union
Sri Lanka
Star Wars
Stargate Universe
Stephen Hawking
Steve Jobs
Steve Stevens
Steven Spielberg
Super Bowl XLV
Superman
Swan Lake
Switzerland
Sylvester Stallone
T.I.
Taiwan
Taj Mahal
Take That
Taylor Lautner
Taylor Momsen
Tea Party movement
Ted Bundy
Tees Maar Khan
Ten Commandments
Texas
Thailand
That '70s Show
The Ashes
The Event
The Fourth Kind
The Girl with the Dragon Tattoo
The Godfather
The Green Hornet
The Holocaust
The Human Centipede (First Sequence)
The King's Speech
The Lord of the Rings
The Notorious B.I.G.
The Nutcracker
The Rolling Stones
The Simpsons
The Undertaker
The Voyage of the Dawn Treader
The Wizard of Oz (1939 film)
Thomas Jefferson
Time zone
Tom Brady
Tom Cruise
Tom Hanks
Toy Story 3
Tramadol
Tron
True Grit
Tuberculosis
Twin Peaks
Twitter
UEFA Champions League
UFC 128
UFC 129
Ukraine
United Arab Emirates
United Nations
United States Bill of Rights
United States Declaration of Independence
Universal Serial Bus
Vanessa Hudgens
Vanuatu
Victoria Justice
Victoria's Secret
Victorious
Vietnam
Vin Diesel
Vitamin D
Vladimir Putin
Vulva
Walt Disney
Warren Buffett
Washington, D.C.
Water
Website
Wesley Snipes
White elephant gift exchange
Wi-Fi
Wii:
Wiktionary
Will Ferrell
Winona Ryder
Winston Churchill
Wizards of Waverly Place
Wolfgang Amadeus Mozart
World of Warcraft
World population
World Wide Web
World Wrestling Entertainment
WWE NXT
Xmas
XML
XXX
Yoko Ono
Yule
Zac Efron
Zodiac
Zooey Deschanel


Version: unspecified
Severity: major

Details

Reference
bz59388

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:27 AM
bzimport set Reference to bz59388.

From: Hoo man <hoo@online.de>

Date: Sun, 27 Mar 2011 12:21:19

The following is doable:
2,3,4,5,6,7,8,9,10,11,12,13
Impossible (from DB data):
14,15

Further, I don't know the differences between 4,5 and 8,9, it would be great if you could reexplain them to me ![][1]

But you have to be patient, that is quite a lot work and will probably take me some time ![][2]

[1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif
[2]: https://jira.toolserver.org/images/icons/emoticons/wink.gif

From: Minn Seok Choi <MinnSeok.Choi@gmail.com>

Date: Sun, 27 Mar 2011 12:53:48

Thanks, Hoo man. I have updated what I want to acquire according to your question.


From: Minn Seok Choi <MinnSeok.Choi@gmail.com>

Date: Tue, 29 Mar 2011 06:08:09

Variable (3)~(13) except (06) were referred from http://vs.aka-online.de/cgi-bin/wppagehiststat.pl


From: Hoo man <hoo@online.de>

Date: Sun, 03 Apr 2011 16:11:16

Ok, I'm finished, but I was unable to get fields 1 and 11 - 13. The first one is up to impossible to fetch from the db and the edit counts are just to slow (I wrote a quite complicated query and tested it om a smaller database, but it just doesn't work with that much data (so many revisions and pages)).
If you really need that data, I'm may going to rewrite my queries or find another solution for this.

Furthermore, I had to change the following pages:
Wii: -> Wii
ANALOG_COMPUTER -> Analog_computer
initial -> Initial
and to remove the following:
Favicon.ico
favicon.ico
(which aren't real requests, just browsers asking for those images)

As a little apologies for that I've reformatted the results as CSV, cause you have written above that you want to use them with excel ![][1]

SQL (and other notes):
http://toolserver.org/~hoo/dbq/dbq-133_sql.txt
Result:
http://toolserver.org/~hoo/dbq/dbq-133.csv (csv which should open in excel)
http://toolserver.org/~hoo/dbq/dbq-133.txt (plain text)

[1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif

From: Minn Seok Choi <MinnSeok.Choi@gmail.com>

Date: Mon, 04 Apr 2011 04:39:49

Thank you so much for your sincere efforts for me, Hoo man. Your job is great. In addition, your considerable formating using cvs file is very helpful for me. Variable (1) and (11)-(13) you had not completed are not matter. Thanks again.

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: hoo@online.de
CC list: hoo@online.de