User:Sriveenkat/notes

To Do

https://archive.org/details/gc-sh10-0116/page/14/mode/2up

Quick Links

Wikidata:Tools

Queries

• Tamil lexemes missing item for this sense statements
• About languages in Bangla Wikipedia
• Pakistan Actress
• Members of the 15th Kerala Legislative Assembly
• List of African Countries
• Country Rivers
• Book of the Bible
• Mosque in Bangladesh

QuickStatements

• QS Description Adding Useful Query

WikiProject Music

• Bangla music composition with music track with vocals
• Bengali songs missing YouTube videos
• Bangla Albums without en Label with Spotify ID

Tamiḷ

• Tamil Nadu Villages with en and ta Label
• Adding Missing Labels for Tamil (Template)
• Adding Missing Descriptions for Tamil Wikipedia Articles

WikiProject Films

• Malayalam films without any cast members, with IMDb ID (Adding Casts from IMDb)
• Indian actresses with image and without Moviebuff ID

TABernacle

• tabernacle - தமிழில் "(திரைபடம்)" என்ற சொல்லை நீக்குதல்
• occupation

Wikidata:Request a query

These queries are requested by me on Wikidata:Request a query. Some users accept my requests and created some queries for me. So these are not my own work. (The requests will be archived after seven days on that page, It's really hard to find in the archives. So I just copied the query text in this page.)

Tagishsimon

Tagishsimon! Thanks for Creating these queries

SELECT ?item ?itemLabel ?property ?propertyLabel ?type  ?sproperty ?spropertyLabel ?value ?valueLabel WITH {
  SELECT ?statement ?type ?property ?sproperty ?value WHERE 
  {
    ?statement ?predicate wd:Q5885.
    hint:Prior hint:runFirst true.

    {?property wikibase:statementProperty ?predicate. 
    BIND("statement" as ?type) }
    UNION
    {?property wikibase:qualifier ?predicate. 
    filter not exists {wd:P407 wikibase:qualifier ?predicate. } 
    BIND("qualifier" as ?type)
    ?statement ?predicate3 ?value .
    ?sproperty wikibase:statementProperty ?predicate3 .
    }
    UNION
    {?property wikibase:reference ?predicate. 
    filter not exists {wd:P407 wikibase:reference ?predicate. } 
    BIND("reference" as ?type) 
    ?statement ?predicate3 ?value .
    ?sproperty wikibase:statementProperty ?predicate3 .
    }
  } 
}  as %i
WHERE
{
  INCLUDE %i  
  ?item ?predicate2 ?statement .
  ?property2 wikibase:claim ?predicate2. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,ta". } 
}

Try it!

#Lexemes that means water ordered by language
# By So9q
# Lexemes that means (liquid) water
SELECT ?l ?sense ?lemma ?language ?languageLabel WHERE {
  ?l a ontolex:LexicalEntry ; # get from the special LexicalEntry
       ontolex:sense ?sense ; # the sense
       dct:language ?language ; # the language
       wikibase:lemma ?lemma. # and the lemma
  ?sense wdt:P5137 wd:Q29053744 .

  VALUES ?language { wd:Q5885 wd:Q36236 wd:Q150 wd:Q7737 }
  
                   # change Q29053744 to anything you want 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
# Lower case before order
ORDER BY (LCASE(?languageLabel))

Try it!

• Wikidata P18 Statement images don't have depicts statement of WD item in the Wikimedia Commons

Mahir256

select ?form ?rep {
  ?form ontolex:representation ?rep ; ^ontolex:lexicalForm/dct:language wd:Q5885 ; wikibase:grammaticalFeature wd:Q146233 .
}

Try it!

Show All Tamil Wikipedia Article without Wikidata Item

Copied version of the discussion in Wikidata:Request a query Hi @Tagishsimon, It's possible please make a query for All Tamil Wikipedia Articles without an Wikidata Item. Because Some Newly created Tawiki Articles are not linked with wikidata. We need to link that. Thanks Sriveenkat (talk) 02:48, 11 December 2023 (UTC)

@Sriveenkat: Probably the best resource to use for this is duplicity. It's updated once per day, as far as I know:

• list of ta wiki articles with no wikidata item - newest articles at the end of the list
• statistics
• categories

The next best option is https://petscan.wmflabs.org/ but I've not been able to get that to work for ta wikipedia. WDQS reports are not very useful for the problem of language wiki articles that are not linked to wikidata items.

Let me know if duplicity works for you. Ideally log into it duplicity (login at the top right) since it provides tools to do lookups from article titles to wikidata - although maybe that won't be so successful for Tamil language titles? --Tagishsimon (talk) 03:46, 11 December 2023 (UTC)

Hello @Sriveenkat, Tagishsimon: PetScan for example, for one category for unconnected pages on ta lanuage wikipedia:

• https://petscan.wmflabs.org/?psid=26626630

With PetScan/QuickStatemens it is also possible to add one or more base statements (e.g. "is a (P31:...") and so on) to every newly created item after clicking on "Start QS" (QuickStatements).

Petscan-Examples:

• User:M2k~dewiki/Tools/Create_Objects
• User:M2k~dewiki/Tools/Create_Objects#Andere_Sprachen

After connecting to existing objects or creating new items they can be enriched with additional statemtents and information, for example:

• User:M2k~dewiki/Tools/Enrich Objects

M2k~dewiki (talk) 16:56, 12 December 2023 (UTC)

Some Useful User pages

• User:Netha Hussain/Query list