On 13/09/13 11:37, Bas vb wrote:
Probably these people are using last years tool, maybe we could try to find those images and move them to 2013 (as it's clear that's the intention of the user).
Mvg,
Bas
There are 43 such images:
+----------+-------------------------------------------------------------------------------------------------------------------------+----------------+-------------------------------+ | log_id | wlm_title | wlm_timestamp | wlm_author_text | +----------+-------------------------------------------------------------------------------------------------------------------------+----------------+-------------------------------+ | 68011366 | Центральний_лютеранський_катедральний_собор_України_Св._Павла.jpg | 20130901221038 | Milissime25 | | 68048047 | Дудаєва_17_(2).JPG | 20130902123024 | MSha | | 68048396 | Дудаєва_19_(01).JPG | 20130902124004 | MSha | | 68048416 | Дудаєва_19_(02).JPG | 20130902124030 | MSha | | 68054482 | Cated_samuxs.jpg | 20130902150213 | Samux | | 68057742 | Ужгородський_кафедральний_собор_-_Хрестовоздвиженський_собор.jpg | 20130902155628 | Sergio kubik | | 68062686 | Edifici_d'aparcaments_(Girona)_2013-09-02_19-10-41.jpg | 20130902171106 | Cortsenc | | 68169473 | -do-_2013-09-04_06-58-04.jpg | 20130904013904 | Jyosthna devi | | 68170842 | Ramappa_temple_2013-09-04_07-25-22.jpg | 20130904020356 | Jyosthna devi | | 68171713 | Ramappa_temple_2013-09-04_07-43-01.jpg | 20130904022200 | Jyosthna devi | | 68298481 | Заліщики_каньйон.jpg | 20130905145241 | Davisdm | | 68299084 | Бережани.jpg | 20130905150533 | Davisdm | | 68299294 | Кременець_комплекс_колегіума_чину_єзуїтів.jpg | 20130905151008 | Davisdm | | 68299410 | Почаївська_лавра_панорама.jpg | 20130905151245 | Davisdm | | 68335808 | Phare_ile_Rouge.jpg | 20130905233223 | Jeangagnon | | 68411709 | Templo_en_Chapala_2013-09-06_13-50-05.jpg | 20130906185041 | Gravity.kny | | 68421175 | Castell_de_Montgrí_des_de_l'aire_3_cropped.jpg | 20130906205901 | AxelHH | | 68487960 | Langshuis_2013-09-07_18-55-36.jpg | 20130907165630 | Natsakis.anastasios | | 68488992 | Traditionele_woning_2013-09-07_19-10-55.jpg | 20130907171232 | Natsakis.anastasios | | 68491997 | Creu_des_Racó_(Porreres)_2013-09-07_19-59-47.jpg | 20130907175918 | RafelJuan | | 68492655 | Creu_des_Racó_(Porreres)_2013-09-07_20-09-36.jpg | 20130907180837 | RafelJuan | | 68552187 | El_Palmàs_(Sant_Joan_de_les_Abadesses)_2013-09-08_12-09-13.jpg | 20130908100958 | Planvi | | 68552374 | Església_de_Sant_Miquel_de_la_Infermeria_(Sant_Joan_de_les_Abadesses)_2013-09-08_12-11-26.jpg | 20130908101252 | Planvi | | 68553289 | Passeig_del_Comte_Guifré_(Sant_Joan_de_les_Abadesses)_2013-09-08_12-25-03.jpg | 20130908102557 | Planvi | | 68606659 | Замок_у_Підзамочку.jpg | 20130908214759 | Бабенко Наталія | | 68621746 | 19_Nechuja-Levytskoho_Street,_Lviv_(9).JPG | 20130909061544 | MSha | | 68628191 | 3-5_Stusa_Street,_Lviv_(02).JPG | 20130909083314 | MSha | | 68628231 | 3-5_Stusa_Street,_Lviv_(03).JPG | 20130909083342 | MSha | | 68634842 | 48_Mushaka_Street,_Lviv_(01).JPG | 20130909100622 | MSha | | 68634871 | 48_Mushaka_Street,_Lviv_(02).JPG | 20130909100650 | MSha | | 68634912 | 50_Mushaka_Street,_Lviv.JPG | 20130909100724 | MSha | | 68669834 | Santuario_del_Sagrado_Corazón_de_Jesús_2013-09-09_14-04-26.jpg | 20130909200654 | JuanRGG | | 68670683 | Government_House_2013-09-09_14-15-10.jpg | 20130909201536 | Korwinntt | | 68670742 | Government_House_2013-09-09_14-16-09.jpg | 20130909201625 | Korwinntt | | 68670778 | Government_House_2013-09-09_14-16-42.jpg | 20130909201707 | Korwinntt | | 68682555 | Templo_de_Belem_2013-09-09_17-52-14.jpg | 20130909225244 | Veronicat01 | | 68695418 | Golkonda_Fort,_Fortifications_2013-09-04_09-56-34.jpg | 20130910053043 | Jyosthna devi | | 68750231 | Catedral_Metropolitana_de_Santiago_2013-09-10_19-05-58.jpg | 20130910220602 | CarolinAngelina | | 68750426 | Museo_de_Arte_Moderno_2013-09-10_19-10-51.jpg | 20130910220958 | CarolinAngelina | | 68763177 | Plaza_Jardín_de_los_Maestros_2013-09-11_02-08-13.jpg | 20130911050901 | B1mbo | | 68844991 | Catedral_de_San_Juan_Bautista_Pungarabato_2013-09-11_20-40-28.jpg | 20130912014129 | Buenapera | | 68845428 | Templo_de_San_Lucas_2013-09-11_20-52-53.jpg | 20130912015344 | Buenapera | | 68927653 | Estació_del_Nord_(Mollerussa)_2013-09-13_11-40-35.jpg | 20130913094119 | ESM | +----------+-------------------------------------------------------------------------------------------------------------------------+----------------+-------------------------------+
SELECT log_id, page_title AS wlm_title, log_timestamp AS wlm_timestamp, log_user_text AS wlm_author_text FROM logging JOIN categorylinks ON (log_page = cl_from) LEFT JOIN page ON (log_page = page_id) WHERE log_timestamp >= '20130831120000' AND log_timestamp <= '20131015205959' AND log_type='upload' AND log_action='upload' AND cl_to = 'Images_from_Wiki_Loves_Monuments_2012' ORDER BY log_timestamp ASC, log_id ASC;