User:Dispenser/sandbox

From Wikimedia Commons, the free media repository
Jump to: navigation, search
-- 2> /dev/null; date; echo '
/* Zero Pixel Images
 * Author: Dispenser
 * License: Public Domain
 * Run time: 60 minutes <SLOW_OK>
 */
SELECT
  CONCAT("{{#ifeq:{{str left|{{filepath:",img_name,"|1}}|20}}|//bits.wikimedia.org|",
    "[{{fullurl:File:", img_name, "|action=purge}} Purge],&nbsp;",
    "[{{filepath:", img_name, "}} Download]",
  "}}") AS "Links",
  CONCAT("[[:File:", REPLACE(img_name, "_", " "), "]]") AS "File",
  CONCAT("{{formatnum:", ROUND(img_size/1024), "}}" AS "Size (KB)",
  CONCAT("{{#time:Y-m-d|", img_timestamp, "}}") AS "Date",
  CONCAT("{{user|", img_user_text, "}}") AS "Uploader"
FROM image
WHERE img_width*img_height<1
AND img_media_type IN ("BITMAP", "DRAWING", "MULTIMEDIA", "OFFICE", "VIDEO")
ORDER BY img_minor_mime, img_name
;-- ' | mysql -ch dewiki-p.rrdb commonswiki_p --html > ~/public_html/temp/logs/zero_pixel_images.html; date;
File Date Uploader
File:1-jpg.svg 2013-03-14 Brijrat kumar (talk · contribs)
File:10-20-2008 Dismissal of Sworn Charges Dated 5-28-2008 (Charge Sheet).pdf 2012-11-21 Geo Swan (talk · contribs)
File:1025arud.svg 2012-09-07 Senior Strateg (talk · contribs)
File:1990 November 15 US Attorneys Bulletin.pdf 2013-09-28 Cirt (talk · contribs)
File:2009 10 08 Marc Randazza interview.ogg 2009-10-12 Cirt (talk · contribs)
File:Abadilla from Philippines pronunciation (Voice of America).webm 2013-05-08 Smallbot (talk · contribs)
File:Alexandre-Lacroix-voix.ogv 2013-02-27 Thierry Caro (talk · contribs)
File:Ansicht 1734 Gumpendorf Laimgrube mit Text.jpg 2012-11-29 Hedwig Abraham (talk · contribs)
File:Armoiries de l'amiral de LIBERGE de GRANCHAIN.gif 2011-11-15 Cyrille de Nanteuil (talk · contribs)
File:Arthur Astor Carey House - 079877pu.tif 2010-02-27 Daderot (talk · contribs)
File:AUDIO DJAMEL.ogg 2013-01-25 Berrouachedi (talk · contribs)
File:Aus dem Nachlass Wilhelm Grimm, Ernst Jordan, Blick auf Stadtmauerturm Neuer Weg Werkkunstschule Knappenort Marktkirche Hannover, 5c, A. Molling & Comp. Steindruck Kunstverein Hannover.jpg 2013-01-26 Bernd Schwabe in Hannover (talk · contribs)
File:Automated-Cell-Identification-and-Tracking-Using-Nanoparticle-Moving-Light-Displays-pone.0040835.s005.ogv 2012-11-14 Open Access Media Importer Bot (talk · contribs)
File:Bad Windsheim, Zehntgasse 5-003.jpg 2012-12-02 Tilman2007 (talk · contribs)
File:Bear growl.ogg 2007-11-19 Shizhao (talk · contribs)
File:Ben 10 1.ogv 2011-11-07 Atletismotics (talk · contribs)
File:Ben 10 2.ogg 2011-11-07 Atletismotics (talk · contribs)
File:Ben 10 3.ogg 2011-11-07 Atletismotics (talk · contribs)
File:BERROUACHEDI DJAMEL SOUND.ogv 2013-01-26 Berrouachedi (talk · contribs)
File:BERROUACHEDI DJAMEL.ogv 2013-01-27 Berrouachedi (talk · contribs)
File:Bilinear Transform Unwarped.svg 2011-07-24 Sympatycznyfacet (talk · contribs)
File:Blasonhumbert.gif 2009-01-23 Natg6 (talk · contribs)
File:Botiquin.ogv 2011-11-11 Leanperrupato (talk · contribs)
File:BPSN-5U2M sound.ogg 2011-05-06 Alex Alex Lep (talk · contribs)
File:Brad Maddox 2008.jpg 2012-11-25 Elbetitito (talk · contribs)
File:Burst-Feeding-of-Pelagia-noctiluca-ephyrae-on-Atlantic-Bluefin-Tuna-(Thunnus-thynnus)-Eggs-pone.0074721.s001.ogv 2013-09-27 Open Access Media Importer Bot (talk · contribs)
File:Cargas.ogv 2011-11-11 Leanperrupato (talk · contribs)
File:Carte de la CARENE.svg 2012-08-05 Senior-banker (talk · contribs)
File:Centaurus carte.svg 2007-09-03 Stanlekub (talk · contribs)
File:Cgt logo.svg 2013-06-06 Afrox (talk · contribs)
File:Chasse d'eau.ogv 2013-01-29 Ludo29 (talk · contribs)
File:Churches in the Bay of Kotor.svg 2011-12-23 Bratislav (talk · contribs)
File:Circle svg.svn.svg 2012-08-10 Wallellen (talk · contribs)
File:Cnic 048378.pdf 2012-01-21 Geo Swan (talk · contribs)
File:Curriculum Concept.svg 2007-01-01 James A Whitson (talk · contribs)
File:Cycas revoluta plant 01.JPG 2013-07-22 Vinayaraj (talk · contribs)
File:Cycas revoluta plant 02.JPG 2013-07-22 Vinayaraj (talk · contribs)
File:Defense.gov News Photo 960330-F-0000C-007.jpg 2013-05-27 Cobatfor (talk · contribs)
File:Defense.gov News Photo 960404-F-8748C-004.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 960404-F-8748C-005.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970410-D-9880W-083.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970418-D-2987S-010.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970418-F-8006R-001.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970421-F-4116M-105.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970422-F-8006R-003.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970423-F-6217S-007.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970501-D-2987S-099.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970501-D-2987S-112.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970530-N-0217R-002.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Defense.gov News Photo 970530-N-8506C-002.jpg 2012-08-25 Slick-o-bot (talk · contribs)
File:Descripcion del video.ogv 2011-11-09 Carlos milraya (talk · contribs)
File:Determinant3x3rule.svg 2012-04-27 Олюсь (talk · contribs)
File:Dig-ital 1.jpg 2013-03-11 090x8106x4666 (talk · contribs)
File:DoD Biometrics Consortium Conference 13 Sep 2007.pdf 2010-06-04 Geo Swan (talk · contribs)
File:Domingo Iturbe Abasolo from Spain pronunciation (Voice of America).webm 2013-05-08 Smallbot (talk · contribs)
File:Dr hamid asadi.jpg 2013-09-20 Hossein 1779 (talk · contribs)
File:Egil Aarvik from Norway pronunciation (Voice of America).webm 2013-05-08 Smallbot (talk · contribs)
File:En-AIDS-introduction.ogg 2011-10-23 MichChemGSI (talk · contribs)
File:En-us-Atlanta-local.ogv 2013-05-23 Mmann1988 (talk · contribs)
File:En-us-Atlanta.ogv 2013-05-23 Mmann1988 (talk · contribs)
File:EnglishDistrictLCMS.svg 2013-03-01 Jared82ca (talk · contribs)
File:Error of a Monte Carlo integration to calculate pi.svg 2012-07-29 Jorgecarleitao (talk · contribs)
File:Examplesong.ogg 2010-01-23 Guitar Webpages (talk · contribs)
File:Fair use cd cover.svg 2013-07-18 Rezonansowy (talk · contribs)
File:Family enjoying outdoors.jpg 2013-01-21 (talk · contribs)
File:Firma JV.SVG 2012-10-30 Jorpogepe (talk · contribs)
File:Flag of the Democratic Republic of Armenia.svg 2007-01-10 Aivazovsky (talk · contribs)
File:Forschungsreaktoren in Deutschland.svg 2009-01-07 Lencer (talk · contribs)
File:Fort Resolution Highway Shield.svg 2013-01-18 Feuerst (talk · contribs)
File:Fragile.svg 2006-07-14 Hakeliha (talk · contribs)
File:Frances M. MacKay House - 079944pu.tif 2010-02-28 Daderot (talk · contribs)
File:Gerald Ford Papers- Final Issues for Decision, Army Corps of Engineers- Puerto Rico - Compact of Permanent Union (1)(Gerald Ford Library)(1554455).pdf 2012-10-18 Smallbot (talk · contribs)
File:Giles wikimania2006 comparing wikipedia and britannica audio lowres.ogg 2006-09-30 GChriss (talk · contribs)
File:Glenn Beck (No Alibi).ogg 2009-10-12 Gwsuperfan (talk · contribs)
File:Graham de Gruchy01.ogg 2013-09-13 Pippigolightly (talk · contribs)
File:Graph with hole.svg 2012-10-07 Gilmjc (talk · contribs)
File:Guyot-Horsford House & Stable - 079913pu.tif 2010-02-28 Daderot (talk · contribs)
File:Guyot-Horsford House & Stable - 079914pu.tif 2010-02-28 Daderot (talk · contribs)
File:Habemus equum.ogg 2009-07-21 Jimrickshaw (talk · contribs)
File:Hamid asadi.jpg 2013-09-20 Hossein 1779 (talk · contribs)
File:HBV-serology.svg 2011-10-06 MGA73bot2 (talk · contribs)
File:Hemorragias.ogv 2011-11-11 Leanperrupato (talk · contribs)
File:Henry Melendy House - 079949pu.tif 2010-03-01 Daderot (talk · contribs)
File:Henry Melendy House - 079950pu.tif 2010-03-01 Daderot (talk · contribs)
File:Henry Melendy House - 079951pu.tif 2010-03-01 Daderot (talk · contribs)
File:Henry Melendy House - 079952pu.tif 2010-03-01 Daderot (talk · contribs)
File:Historic Center of Quito - World Heritage Site by UNESCO - Photo 492.JPG 2013-08-26 Alvarosevilladesign (talk · contribs)
File:ISN 569's Guantanamo detainee assessment.pdf 2011-06-12 Geo Swan (talk · contribs)
File:Jaw-Laterality-and-Related-Handedness-in-the-Hunting-Behavior-of-a-Scale-Eating-Characin-Exodon-pone.0029349.s002.ogv 2012-11-21 Open Access Media Importer Bot (talk · contribs)
File:Jeff Flake, official portrait, 113th Congress 2.jpg 2013-08-17 Gage (talk · contribs)
File:Jewish Encyclopedia Volume 6.pdf 2013-09-26 John Carter (talk · contribs)
File:Jorge Abadia from Panama pronunciation (Voice of America).webm 2013-05-08 Smallbot (talk · contribs)
File:Justicia brandegeeana 02.JPG 2013-07-28 Vinayaraj (talk · contribs)
File:Kitsapcountyflag1.svg 2012-04-26 Floreal78 (talk · contribs)
File:KlogoAlone-jpg.svg 2011-12-24 Vysakh0 (talk · contribs)
File:Knight's graph showing an Euler solution to knight's tour.svg 2008-07-07 Nonenmac (talk · contribs)
File:Lemsterland flag.svg 2013-01-19 File Upload Bot (Magnus Manske) (talk · contribs)
File:Leonid Abalkin from Russia pronunciation (Voice of America).webm 2013-05-08 Smallbot (talk · contribs)
File:Leroux - L'Epouse du Soleil.djvu 2010-12-29 Toto256 (talk · contribs)
File:Les Falles.ogg 2013-05-17 Coentor (talk · contribs)
File:Libro alas delta jpg.pdf 2010-08-10 Roberto6936 (talk · contribs)
File:Lindos2.svg 2008-10-26 Penpen (talk · contribs)
File:Location Paimbœuf.svg 2011-10-09 Fylip22 (talk · contribs)
File:Logo MWAM Records.svg 2012-02-13 Vipmission (talk · contribs)
File:LostPaddleAPR2006.ogg 2007-04-15 Jwick (talk · contribs)
File:Maffei 1 surface brightness.SVG 2012-05-16 Ruslik0 (talk · contribs)
File:Maillotgenil.svg 2012-07-06 Ewy25 (talk · contribs)
File:Mapa de Três Pontas.svg 2012-12-22 WOtP (talk · contribs)
File:Marque Vélonautic.svg 2011-11-30 Elphéon (talk · contribs)
File:MCSFRegtLogo.svg 2013-05-24 Byrnebj (talk · contribs)
File:Mediapolis Logo.svg 2011-10-26 Bajan64 (talk · contribs)
File:Muixeranga.ogg 2013-05-17 Coentor (talk · contribs)
File:NakhichevanASSRFlag1937.svg 2006-09-02 Aivazovsky (talk · contribs)
File:National Hero of Armenia ribbon2.svg 2013-04-01 Yerevanci (talk · contribs)
File:New York Locator Map with Adirondack Park.svg 2011-10-30 Mwanner (talk · contribs)
File:NIH national library of medicine (8).jpg 2013-01-21 (talk · contribs)
File:Obama2009HRCSpeechPart1.webm 2013-01-29 RayneVanDunem (talk · contribs)
File:Olexandr Mishuga.ogg 2009-06-25 Ilmari Karonen (talk · contribs)
File:Oranie.svg 2012-02-27 Vikoula5 (talk · contribs)
File:Parliametennte.svg 2012-05-08 Lluket24 (talk · contribs)
File:Parovoz sound.ogg 2009-04-01 Alex Alex Lep (talk · contribs)
File:Parovoz Su gudok.ogg 2009-04-03 Alex Alex Lep (talk · contribs)
File:Parsons-Warner House - 079953pu.tif 2010-03-03 Daderot (talk · contribs)
File:Parsons-Warner House - 079954pu.tif 2010-03-03 Daderot (talk · contribs)
File:Parsons-Warner House - 079955pu.tif 2010-03-03 Daderot (talk · contribs)
File:Parsons-Warner House - 079956pu.tif 2010-03-03 Daderot (talk · contribs)
File:Pinned Magnet on a superconductor.ogv 2011-12-30 Jubobroff (talk · contribs)
File:Port Imperial Street Circuit.svg 2011-10-26 August90 (talk · contribs)
File:President Obama Speaks to the Muslim World from Cairo, Egypt (audio).ogg 2009-06-04 Ilmari Karonen (talk · contribs)
File:Primeros auxilios.ogv 2011-11-11 Leanperrupato (talk · contribs)
File:Progression continue octave do3 do4.ogg 2006-11-07 Cdang (talk · contribs)
File:Proof-Pythagorean-Theorem.svg 2005-12-28 Schutz (talk · contribs)
File:Présentation de la Fondation Louis de Broglie - La science comme aventure de l'esprit.ogv 2012-04-20 Rabatakeu (talk · contribs)
File:R.C.P..ogv 2011-11-11 Leanperrupato (talk · contribs)
File:Rahat 5 Ai copy.jpg 2013-03-05 Wismore Pakistan (talk · contribs)
File:Rahat Banaspati Pouch copy.JPG 2013-03-05 Wismore Pakistan (talk · contribs)
File:Rahat Cooking Oil Oil 1 Kg copy.JPG 2013-03-05 Wismore Pakistan (talk · contribs)
File:Rahat Vanaspati 2.5.JPG 2013-03-05 Wismore Pakistan (talk · contribs)
File:Reagle wikimania2006 wikipedia neutrality audio lowres.ogg 2006-09-30 GChriss (talk · contribs)
File:Recruit Training Regiment Logo.svg 2013-05-24 Byrnebj (talk · contribs)
File:Riverbank Court - 079957pu.tif 2010-02-05 Daderot (talk · contribs)
File:ROLE.pdf 2013-05-16 Dericoprof (talk · contribs)
File:Roue libre Campagnolo.ogv 2013-01-31 Ludo29 (talk · contribs)
File:Rozestavěnost OD Fontána v Teplicích 9. března 2012 (exif údaj je špatný).jpg 2012-07-30 Takmocsekretovanej! (talk · contribs)
File:SAKEC.svg 2012-03-08 InfiniteDragforce (talk · contribs)
File:Samar,badawistory.pdf 2012-02-08 Thejustice966 (talk · contribs)
File:Samidh Mukerjee.jpg 2013-01-12 Samidhmukerjee (talk · contribs)
File:Sani Abacha from Nigeria pronunciation (Voice of America).webm 2013-05-08 Smallbot (talk · contribs)
File:SchwerinWiki.ogv 2013-07-24 Skypic-Media (talk · contribs)
File:Sefora Tech.svg 2013-09-07 Hybirdd (talk · contribs)
File:SELCDistrictLCMS.svg 2013-03-01 Jared82ca (talk · contribs)
File:Semargl - Tak, Kurwa.ogg 2013-08-24 Russavia (talk · contribs)
File:Sempervivum Amanda (4732783019).jpg 2013-03-08 File Upload Bot (Magnus Manske) (talk · contribs)
File:Server Based LAN.pdf 2012-11-19 Dawebservices (talk · contribs)
File:SkyTeam Tailfin.jpg 2013-09-18 Faisal Al-Abdullah (talk · contribs)
File:Sound of the bells of Sveta Nedelya in Sofia 2012 PD.ogg 2013-07-14 McZusatz (talk · contribs)
File:SPURS AT&T.svg 2012-05-03 HITNOM (talk · contribs)
File:Srimati Lal.svg 2011-11-07 Aditya3611 (talk · contribs)
File:Sscmalarme gen.ogv 2012-02-01 Ludo29 (talk · contribs)
File:St Leo, Baltimore MD.jpg 2013-09-15 ZeWrestler (talk · contribs)
File:Sámi Soga Lávlla.ogg 2011-02-06 Kaihsu (talk · contribs)
File:Taurus Makrofon.ogg 2007-06-30 Sese Ingolstadt (talk · contribs)
File:Teplovoz sound.ogg 2009-04-01 Alex Alex Lep (talk · contribs)
File:The individuals Revolution.pdf 2012-02-23 Fraankieamir (talk · contribs)
File:Toma Asiatica.ogg 2011-11-10 Blasco88 (talk · contribs)
File:Toma Europea.ogg 2011-11-10 Blasco88 (talk · contribs)
File:Türkiye Dış Borcu, 2001-2011.svg 2011-11-16 Condmatstrel (talk · contribs)
File:Universal Island Records (8224072834).jpg 2013-04-02 File Upload Bot (Magnus Manske) (talk · contribs)
File:USMC-090312-M-6323R-001.jpg 2012-12-07 Slick-o-bot (talk · contribs)
File:USMC-090312-M-6323R-002.jpg 2013-03-26 Tm (talk · contribs)
File:USMC-090924-M-4820H-048.jpg 2012-12-08 Slick-o-bot (talk · contribs)
File:USMC-09325.jpg 2012-12-05 Slick-o-bot (talk · contribs)
File:USMC-100708-M-4059K-053.jpg 2012-12-13 Slick-o-bot (talk · contribs)
File:USMC-100708-M-4059K-060.jpg 2012-12-13 Slick-o-bot (talk · contribs)
File:USMC-110226-M-4388Z-001.jpg 2012-12-09 Slick-o-bot (talk · contribs)
File:USMC-110430-M-DX861-166.jpg 2012-12-12 Slick-o-bot (talk · contribs)
File:USMC-110430-M-DX861-196.jpg 2012-12-12 Slick-o-bot (talk · contribs)
File:USMC-110504-M-DX861-165.jpg 2012-12-12 Slick-o-bot (talk · contribs)
File:USMC-110504-M-DX861-170.jpg 2012-12-12 Slick-o-bot (talk · contribs)
File:USMC-110504-M-DX861-178.jpg 2012-12-12 Slick-o-bot (talk · contribs)
File:USMC-110504-M-DX861-255.jpg 2012-12-12 Slick-o-bot (talk · contribs)
File:USMC-110504-M-DX861-260.jpg 2012-12-12 Slick-o-bot (talk · contribs)
File:USMC-110505-M-DX861-096.jpg 2012-12-12 Slick-o-bot (talk · contribs)
File:Valentine-Fuller House & Garden - 079858pu.tif 2010-03-06 Daderot (talk · contribs)
File:Valentine-Fuller House & Garden - 079859pu.tif 2010-03-06 Daderot (talk · contribs)
File:Vendajes.ogv 2011-11-11 Leanperrupato (talk · contribs)
File:Violencia.ogv 2011-11-09 Palomalemany (talk · contribs)
File:Vorstandsvorsitzender Werner Strahl2.jpg 2013-08-13 Missmie (talk · contribs)
File:Wiki kvadratna Dgt0.svg 2013-06-21 Lfahlberg (talk · contribs)
File:Wikimania2006 press conference audio lowres.ogg 2006-09-30 GChriss (talk · contribs)
File:YERCADU FLOWER 01.jpg 2012-09-27 Neelavannan.c (talk · contribs)
File:¿Que es la Matronatacion?.ogv 2011-11-02 Los que somos (talk · contribs)
File:Позиционная карта Дмитровского района Орловской области.svg 2012-11-12 Alexandr1991 (talk · contribs)
File:拉丁语词形变化表【西塞罗版】.pdf 2013-06-10 慎獨木鐸 (talk · contribs)