Back ache

Mein Shiff 3

I'm puzzled why you added 2 locations to Mein Schiff 3 (Q16323072), when by their nature ships have lots of locations, until their final resting place as a museum ship or wreck. Vicarage (talk) 14:36, 31 October 2023 (UTC)

It was right at the time of adding hence why it has the "point in time" property, the data came from the gps aboard the ship, if it was available I was also back-filling any other data the ship provided. I have stopped the project now Back ache (talk) 18:47, 31 October 2023 (UTC)

I can't see any advantage in putting such data in WD. Can you point me to a description of the project, so we can discuss its merits in WikiProject:Ships? Vicarage (talk) 19:00, 31 October 2023 (UTC)

it's a moot point tbh, I've already stopped. Back ache (talk) 20:23, 31 October 2023 (UTC)

Podcast

Could you please stop adding retrieved (P813) as a qualifier of number of episodes (P1113)? It's not even a valid qualifier for that property and you are just creating hundreds of constraint violations Trade (talk) 22:10, 11 November 2023 (UTC)

OKay Back ache (talk) 00:15, 12 November 2023 (UTC)

And also to stop listing podcast (Q24634210) as a genre Trade (talk) 03:14, 12 November 2023 (UTC)

iAlso please stop using name (P2561) on podcasts (Q123401326)--Trade (talk) 03:17, 12 November 2023 (UTC)

thanks for the feedback, I have done a lot of work to fix the gaps in a lot of entries and its nce or someone to notice :-) Back ache (talk) 07:32, 12 November 2023 (UTC)

Could you make a batch that removes the wrong properties and qualifiers from items? Trade (talk) 11:46, 12 November 2023 (UTC)

WDQS refuse to query entries with "name" and QS can be very "quirky", but I am looking into it. Back ache (talk) 09:22, 13 November 2023 (UTC)

Is Next 2 Blow Podcast (Q113559381) supposed to be about a podcast or a human? Biy confused Trade (talk) 13:38, 13 November 2023 (UTC)

Looks like someone going a bit batch-crazy so better you ask the person that did it, its the kind of thing a script could fix, but for now I have tidied it up Back ache (talk) 14:06, 13 November 2023 (UTC)

I have written and run one that removed any "titles" on "podcasts" Back ache (talk) 07:43, 24 November 2023 (UTC)

Something wrong? Trade (talk) 23:46, 12 November 2023 (UTC)

no, just got some personal stuff going on Back ache (talk) 09:26, 13 November 2023 (UTC)

Do you have time to run a sccript that removes the "retrieved" qualifier? Trade (talk) 21:54, 18 November 2023 (UTC)

done Back ache (talk) 12:03, 27 November 2023 (UTC)

Any chance you could import review scores from Apple Podcasts?--Trade (talk) 10:45, 17 November 2023 (UTC)

That's a good idea, I will take a look , Back ache (talk) 17:18, 17 November 2023 (UTC)

Alright, would like to see some test edits if you figure it out Trade (talk) 01:00, 18 November 2023 (UTC)

Thankyou, this has been a lonely task at times :-) Back ache (talk) 15:42, 18 November 2023 (UTC)

Have done one test edit so far, on Bill Gates' new podcast https://www.wikidata.org/wiki/Q123470663 let me know what you think Back ache (talk) 22:57, 18 November 2023 (UTC)

Could make a test with the changes i made?Trade (talk) 16:35, 19 November 2023 (UTC)

Please stop the batch until you have fixed the constraint errors you are creating --Trade (talk) 21:56, 23 November 2023 (UTC)

what constraint errors? Let me know what they are or where they are listedBack ache (talk) 04:21, 24 November 2023 (UTC)

Part of it is that, in edits like this, you should be using retrieved (P813) as part of the reference, not as a qualifier of the statement.

More generally, you should be checking that any sort of mass-edit does not produce constraint violations or other errors before you make it. It does look like you've been adding some helpful info about podcasts, so that's appreciated, but when it's not formatted properly it creates additional work for others to clean up. {{u|Sdkb}} ^talk 06:33, 24 November 2023 (UTC)

Thanks for appreciating what I am doing, I have removed from the script the part that adds the retrieved (it was intended for the reference not the statement) and culled then re-added the "number of episodes" that were affected. Back ache (talk) 11:32, 27 November 2023 (UTC)

Podcasts with the statement URL (P2699) should be moved to exact match (P2888) instead Trade (talk) 10:45, 24 November 2023 (UTC)

Podcast tidy-up

They shouldn't use "name"

https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%20%20%7B%0A%20%20%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%20%20%3Fitem%20p%3AP31%20%3Fstatement0.%0A%20%20%20%20%20%20%3Fstatement0%20%28ps%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ24634210.%0A%20%20%20%20%20%20%3Fitem%20p%3AP2561%20%3Fstatement1.%0A%20%20%20%20%20%20%3Fstatement1%20%28ps%3AP2561%29%20_%3AanyValueP2561.%0A%20%20%20%20%7D%0A%20%20%20%20LIMIT%20100%0A%20%20%7D%0A%7D Back ache (talk) 04:46, 24 November 2023 (UTC)

Thx Trade (talk) 00:34, 25 November 2023 (UTC)

Their number of episodes shouldn't have a retrieved

SELECT ?item ?itemLabel ?number ?retrieved_as_qualifier WHERE {

 ?item wdt:P31  wd:Q24634210 . 
 ?item p:P1113 ?stat .
 ?stat ps:P1113 ?number .
 {?stat pq:P813 ?retrieved_as_qualifier.}
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 

}

Podcasts should have an official website

SELECT DISTINCT ?item ?itemLabel WHERE {

 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
 {
   SELECT DISTINCT ?item WHERE {
     ?item p:P31 ?statement0.
     ?statement0 (ps:P31/(wdt:P279*)) wd:Q24634210.
     MINUS {
       ?item p:P856 ?statement1.
       ?statement1 (ps:P856) _:anyValueP856.
     }
   }
   LIMIT 100
 }

} Back ache (talk) 12:04, 27 November 2023 (UTC)

Apple Podcast review score

https://w.wiki/8RLw

SELECT DISTINCT ?item ?itemLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  {
    SELECT DISTINCT ?item WHERE {
      ?item p:P31 ?statement0.
      ?statement0 (ps:P31/(wdt:P279*)) wd:Q24634210.
      ?item p:P5842 ?statement1.
      ?statement1 (ps:P5842) _:anyValueP5842.
      MINUS {
        ?item p:P444 ?statement2.
        ?statement2 (ps:P444) _:anyValueP444.
      }
    }
    LIMIT 100
  }
}

Try it!

Could you fix them? Trade (talk) 09:56, 8 December 2023 (UTC)

oh no, what have a I broken now :-( ? Back ache (talk) 11:46, 8 December 2023 (UTC)

The score should look like this instead. I brought it up once before but you forgot to respond--Trade (talk) 12:17, 8 December 2023 (UTC)

ah, so it's just build and add an archive URL Back ache (talk) 17:13, 8 December 2023 (UTC)

And change the order of qualifiers and fill out the unit of number of reviews/ratings Trade (talk) 17:50, 8 December 2023 (UTC)

Did you ran into trouble? Trade (talk) 15:51, 20 December 2023 (UTC)

it's not obvious Back ache (talk) 17:18, 20 December 2023 (UTC)

What's not obvious? Trade (talk) 20:05, 20 December 2023 (UTC)

Telegram

Could i convince you to join the Wikiproject Podcasts telegram channel? It's not easy to communicate when responses takes so long Trade (talk) 01:17, 1 January 2024 (UTC)

I am already, I have been there a while but like the main talk page it does not seem to be very active. Back ache (talk) 14:28, 1 January 2024 (UTC)

Wikiproject Journalists

I've seen that you've contributed to  Wikidata:WikiProject Journalists.

I think it's worth developing the project. However, I suggest to expand the topic to either journalism or medias. What do you think? PAC2 (talk) 21:21, 20 April 2024 (UTC)

Stay focused on journalists, thats a big enough job in itself! Back ache (talk) 06:17, 21 April 2024 (UTC)

Of course but journalists work in media organisations. So it's relevant to document them. PAC2 (talk) 10:40, 21 April 2024 (UTC)