User:Krinkle/Queries/commonswiki filepageswithoutdots
Appearance
< User:Krinkle | Queries
commons.wikimedia.org : File-pages without dots
Last update: 2011-04-04 16:58 (UTC)
Last update: 2011-04-04 16:58 (UTC)
# file.sh sql commonswiki_p < filepageswithoutdots.sql > commonswiki_filepageswithoutdots.txt # filepageswithoutdots.sql SELECT concat('*[[:commons:File:',page_title,']]') FROM page WHERE page_namespace=6 AND page_title NOT LIKE '%.%' LIMIT 500 # commonswiki_filepageswithoutdots.txt
- commons:File:@
- commons:File:Antigua_escuela_de_Tresgrandas
- commons:File:Autumn_leaf_color_change_at_Chateau_La-Roche_pg
- commons:File:Baby_hippo_resting_on_adult
- commons:File:Baby_hippo_swims
- commons:File:Beidh_ár_lá_linn_mural
- commons:File:Bush_at_podium_at_renewable_energy_conference
- commons:File:Cartella_asul
- commons:File:Cartella_pula
- commons:File:Cecilia_Brækhus_(looking_down)
- commons:File:Colours_of_Donegal
- commons:File:Commons_logo
- commons:File:Drottning_Silvia_och_Kung_Carl_XVI_Gustaf_under_nationaldagsfirande_vid_Skansen_2009
- commons:File:Ellen_Campesinos!_2008
- commons:File:Gutter_1850s_House_NOLAjpg
- commons:File:HKstreet2-2-2010jpg
- commons:File:Harriet_(Los_Campesinos!)_-_2010
- commons:File:Igreja_Bom_Jesus_-_Americana-SP
- commons:File:Kit_right_arm_canada_red
- commons:File:Kostel_pod_zlatým_nebem
- commons:File:Ku_Mueang_Bua-005jpg
- commons:File:L'Abbé_Jean-Jacques_Huber_lisant_(original_replica)_by_Maurice_Quentin_de_La_Tour
- commons:File:Licensing_tutorial/lang
- commons:File:Marching_New_Orleans_Tulane_Avenuejpg
- commons:File:Moses_Mabhida_at_the_Spain-Switzerland
- commons:File:Mother_and_very_small_baby_hippo
- commons:File:Nativity_of_the_Virgin_Mary_-_Cathedral_in_Rostov-on-Don
- commons:File:New_Orleans_bookshop_couch_and_globejpg
- commons:File:Odessa_literary_group
- commons:File:POTD
- commons:File:PatriotsCheerleader
- commons:File:Periphery_(3)jpg
- commons:File:Prasad_Vaidya_Shaniwarwada_Well,jpg
- commons:File:Préparation_500
- commons:File:Rieles-Amagá-jpg
- commons:File:Robin_Hanson_at_OSCON_2007
- commons:File:Schloss_Charlottenburg_Street_Lamp
- commons:File:Shiv_Temple,_Mata_Trilok_Bala_Sundri,_Himachal_Pardesh
- commons:File:Slag_Heap_on_Buffalo_Creek_near_Man_and_Logan,_West_Virginia
- commons:File:St_charles_streetcar_style_New_Orleans_Carnival_2009jpg
- commons:File:Sunbathig_Smooth-billed_Ani
- commons:File:Tamiasciurus_hudsonicus_Bas-Saint_Laurent,_QC
- commons:File:Vences,_Vences,_Monterrei_05jpg
- commons:File:Vences,_Vences,_Monterrei_06jpg
- commons:File:Vences,_Vences,_Monterrei_07jpg
- commons:File:Vences,_Vences,_Monterrei_08jpg
- commons:File:Vences,_Vences,_Monterrei_09jpg
- commons:File:Xuanwumen_Station,_Nanjing_Metro_jpg
- commons:File:Πύλος,_Ιερός_Ναός_Κοιμήσεως_της_Θεοτόκου_1
- commons:File:Πύλος,_Ιερός_Ναός_Κοιμήσεως_της_Θεοτόκου_2
- commons:File:هشام_الجخ