User talk:Achim55/Archive
Latest comment: 4 years ago by Achim55 in topic image & blocked editors
 | Please do not post any new comments on this page. This is a discussion archive first created on Error: Invalid time., although the comments contained were likely posted before and after this date. See current discussion. |
SQL question
Greetings Achim55, I noticed you seem to be pretty good at SQL and I was hoping I could ask for some help. I am trying to craft a query for commons that will show the images that have duplicate categories. Do you happen to have something like that? Reguyla (talk) 01:11, 20 January 2017 (UTC)
- Reguyla, I don't understand what "duplicate categories" shall mean. --Achim (talk) 12:57, 20 January 2017 (UTC)
- Oh ok. On some articles, files, etc. they have duplicate categories. Like if someone adds Category:Example twice. It seems like there should be a way to detect what articles or files link to the same category twice, but I can't seem to figure it out. I'm still learning the database structure. Reguyla (talk) 14:28, 20 January 2017 (UTC)
- Reguyla, ok, now I got it. Right now I'm busy and not at home til Tuesday, so please be patient. --Achim (talk) 18:36, 21 January 2017 (UTC)
- Oh it's no rush at all. Thanks in advance. Reguyla (talk) 00:41, 22 January 2017 (UTC)
- Reguyla, ok, now I got it. Right now I'm busy and not at home til Tuesday, so please be patient. --Achim (talk) 18:36, 21 January 2017 (UTC)
- Oh ok. On some articles, files, etc. they have duplicate categories. Like if someone adds Category:Example twice. It seems like there should be a way to detect what articles or files link to the same category twice, but I can't seem to figure it out. I'm still learning the database structure. Reguyla (talk) 14:28, 20 January 2017 (UTC)
image & blocked editors
pst - https://www.flickr.com/photos/73455099@N07/ - cheers Slowking4 (talk) 00:59, 8 March 2020 (UTC)
- Slowking4, I don't understand. What can I do for you? --Achim (talk) 12:32, 8 March 2020 (UTC)
- if you go to that flickr feed, you will find images of notable people without an image on wiki, taken by a blocked editor. for example [1] w:David_Enrich; and [2] w:Marita_Golden - flickr2commons works well. cheers Slowking4 (talk) 17:41, 8 March 2020 (UTC)
┌─────────────────────────────────┘
@Slowking4: You will get no joy here. Achim hates you, otherwise he would have replied sooner. Keep up the good work Slowie. Moonleapt (talk) 19:32, 13 July 2020 (UTC)
- tja - hate is a strong emotion, and i already have the joy in pointing out the hypocrisy of comments such as this: "Edit: To come to the point: I'm the 1st volunteer for re-uploading images. Hey socks, leave me a note. :))" and then has not done it. cheers. Slowking4 (talk) 12:18, 14 July 2020 (UTC)
- You seem to have had the joy in pointing out that you didn't have got it. That cited sentence was just meant to illustrate my POV and my vote in the discussion you took it from. Therefore I added ":))". Nonetheless, many thanks to you for your work on Wikisource! Regards, --Achim (talk) 14:58, 17 July 2020 (UTC)