The rdfs:label plus FILTER version is missing all results that don’t have an English label. Use OPTIONAL to fix that: [3], 37991 results, just like your second query.

Regards,
Lucas

[3]: https://query.wikidata.org/#SELECT%20%3Fplace%20%3Flabel%20WHERE%20%0A%7B%0A%20%20%3Fplace%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ486972%3B%0A%20%20%20%20%20%20%20%20%20wdt%3AP17%20wd%3AQ183.%0A%20%20OPTIONAL%20%7B%0A%20%20%3Fplace%20rdfs%3Alabel%20%3Flabel%20.%0A%20%20FILTER%20%28LANG%28%3Flabel%29%3D%27en%27%29%0A%20%20%7D%0A%7D%20%20%0A

Dear all, 

Standard way of filtering labels and calling SERVICE returns different number of results. Is it normal? 

For example, I would like to get all places in Germany. If I filter language using rdfs:label I got 14346 results [1]. However, when I use  SERVICE wikibase:label I got 37991 results [2]. 

Am I missing something? 

--

Best regards, 

Ali Ismayilov

[1] - https://query.wikidata.org/#SELECT%20%3Fplace%20%3Flabel%20WHERE%20%0A%7B%0A%20%20%3Fplace%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ486972%3B%0A%20%20%20%20%20%20%20%20%20wdt%3AP17%20wd%3AQ183.%0A%20%20%3Fplace%20rdfs%3Alabel%20%3Flabel%20.%0A%20%20FILTER%20%28LANG%28%3Flabel%29%3D%27en%27%29%0A%7D%20%20%0A

[2] - https://query.wikidata.org/#SELECT%20%3Fplace%20%3FplaceLabel%20WHERE%20%0A%7B%0A%20%20%3Fplace%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ486972%3B%0A%20%20%20%20%20%20%20%20%20wdt%3AP17%20wd%3AQ183.%0A%20%20%0A%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%0A%20%7D%0A%7D%20%20%20

_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata