Topic on Talk:Quarry

Jump to navigation Jump to search

Inordinately long Wikidata short descriptions

2
Genericusername57 (talkcontribs)

Hello all,

I would like to search for Wikidata items with inordinately long descriptions (say, more than 250 characters). I have already tried this query with no success. (Unfortunately, my knowledge of SQL is minimal.)

Matěj Suchánek (talkcontribs)
USE wikidatawiki_p;
SELECT wbit_item_id, wbxl_language, wbx_text
FROM wbt_item_terms
INNER JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
INNER JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
INNER JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE wbtl_type_id = 2
-- AND wbxl_language = ''
AND LENGTH(wbx_text) > 250

You can also filter by language (as hinted). You'll probably want to add some limit.

Reply to "Inordinately long Wikidata short descriptions"