Last modified: 2014-01-03 16:01:07 UTC
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
------------------------------------------------------------------------------- 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
