SQL
AخA
use wikidatawiki_p;
SELECT
CONCAT('Q', term_entity_id) As item,
CONCAT('D', term_language) As tr,
CONCAT('"', term_text, '"') As current_desc,
LENGTH(term_text) as strl,
term_entity_id
from wb_terms
WHERE term_entity_type = 'item'
AND term_language in (
'as', 'bn', 'gom', 'gom-deva', 'gom-latn', 'gu', 'hi', 'kn', 'ks', 'ks-arab', 'ks-deva', 'mai', 'mni', 'ml', 'mr', 'ne', 'or', 'pa', 'pnb', 'sa', 'sat', 'sd', 'ta', 'te', 'ur'
)
AND term_type = 'description' # 'label', 'description', 'alias'
AND (term_text LIKE '%.'
OR term_text LIKE '%।')
GROUP BY term_text, term_entity_id
ORDER BY term_entity_id DESC
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.