User talk:Multichill/Archives/2016/March

page_props: wb-claims, pp_value and pp_sortkey

Hi Multichill,

Thanks for purging items ensuring this property finally gets populated. Currently, there are just about 40 items missing it. Supposedly a bug misses it once in a while. In any case, the reports at Wikidata:Database_reports/without_claims_by_site are more complete. Still there is a gap. Personally, I use pp_sortkey = 0 to select items, but it seems that some (maybe 200,000) of the entries just have pp_value = 0. Would you kindly run the purge on these items as well?
--- Jura 14:59, 6 March 2016 (UTC)

@Jura1: I found these items and purged them. Those reports are quite nice. Played around with it and ended up filing Phab:T129037. Multichill (talk) 16:57, 6 March 2016 (UTC)

• The purging did improve the reports substantially. The remaining items I have in mind are these. Maybe WQS should also offer a way to select items without any statements directly.
  --- Jura 17:41, 6 March 2016 (UTC)

• You could use SQL for that (working with wiki per wiki). One example query:

use enwiki_p;
SELECT p.page_title
FROM page p, page_props, wikidatawiki_p.page wdp
LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P31' or wdpl.pl_title = 'P279') AND wdpl.pl_namespace = 120
WHERE p.page_namespace = 0
AND pp_page = p.page_id AND pp_propname = 'wikibase_item' AND wdp.page_title = pp_value AND wdp.page_namespace = 0
and p.page_id in (SELECT tl_from
						FROM templatelinks
						WHERE tl_namespace = 10 and tl_from_namespace=0
						and tl_title="Infobox_road")
AND wdpl.pl_from IS NULL;

• Yes, it's dirty, but I it works well and I haven't yet worked on cleaning-up query. --Edgars2007 (talk) 18:09, 6 March 2016 (UTC)

• I will try to do the purging myself. BTW, as you had proposed P971, I thought you might have an opinion on Wikidata:Property_proposal/Sister_projects#cct_applicable_property.
  --- Jura 11:00, 8 March 2016 (UTC)

P1887

Please undo your deletion of P1887, for which there is no consensus. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:42, 18 March 2016 (UTC)

No, it was open long enough so I made a decision. Multichill (talk) 21:55, 18 March 2016 (UTC)

Big source of problems

Hi: Remember this lad? Well, now I guess his actions are more than just "mistakes". He's adding not referenced data. More than that, false data. Most of his actions are disruptive and they're damaging Spanish or Latin American bios. I'm available for further questions. Thanks in advance. --Fixertool (talk) 13:07, 20 March 2016 (UTC)

@Fixertool: sorry to hear that. Could you open a topic on Wikidata:Administrators' noticeboard? I hope an admin who actually understands Spanish can follow up on this. Multichill (talk) 13:20, 20 March 2016 (UTC)

Image suggestions

Hi Multichill! Ik ging aan de slag met de 'image suggestions' (leek me wel chill om de griep-verveling mee te verdrijven), en ik heb twee vragen: 1. Er staat vaak de melding 'Lua error: too many expensive function calls'. Wat houdt dat in en kan ik daar iets aan doen? 2. Als duidelijk is dat een afbeelding niet bij het Q-nummer hoort, wat doe ik dan?

Dankjewel voor je hulp alvast! Mtmlan84 (talk) 13:38, 24 March 2016 (UTC)

Hoi [[User:Mtmlan84|Mtmlan84], ik hoop dat je snel beter bent! Had laatst ook griep en dat duurde me allemaal veel te lang. Als je een nieuw onderwerp start is het gebruikelijk om dit onderaan te doen. Ik zat me nu al af te vragen waar je vraag stond. De LUA fouten komen omdat de pagina te groot is. Daar kan je helaas niets aan doen. Als iets geen match is dan kan je het gewoon negeren. Multichill (talk) 20:54, 24 March 2016 (UTC)

DiMCoN

Voor als je je verveelt (ha ha): de DiMCoN portal van het RCE (Digitale Museale Collectie Nederland) met vele voor ons relevante musea. Ik heb ook iets gevonden dat in de richting van een API wijst. Misschien zijn de makers van Delving wel aardig en antwoorden ze op emails? Veel inspiratie in Jeruzalem! Spinster (talk) 09:49, 30 March 2016 (UTC)