alswiki displaytitle

SQL

USE wikidatawiki_p;
SELECT term_full_entity_id, term_language, CONCAT(LCASE(LEFT(term_text, 1)), SUBSTRING(term_text,2,LENGTH(term_text))) AS description
FROM wb_terms
WHERE term_type = 'description'
AND term_language = 'cs'
AND term_full_entity_id LIKE 'Q%'
AND (
  term_text LIKE 'Album %'
  OR term_text LIKE 'Americk%'
  OR term_text LIKE 'Druh %'
  OR term_text LIKE 'Farnost %'
  OR term_text LIKE 'Francouzsk%'
  OR term_text LIKE 'Kaple %'
  OR term_text LIKE 'Kostel %'
  OR term_text LIKE 'Město %'
  OR term_text LIKE 'Německ%'
  OR term_text LIKE 'Příjmení%'
  OR term_text LIKE 'Rakousk%'
  OR term_text LIKE 'Vesnice %'
  OR term_text LIKE 'Sbor %'
  OR term_text LIKE 'Slovensk%'
  OR term_text LIKE 'Zámek %'
  OR term_text LIKE 'Zanikl%'
  OR term_text LIKE 'Zřícenina%'
);
SQL

Checking query status...
