Untitled query #7417

SQL

use jawiki_p;

SELECT pp_value, concat('L', term_language) AS lang, CONCAT('"', LOWER(SUBSTRING(term_text, 1, 1)), SUBSTRING(term_text, 2), '"')

FROM (
	SELECT page_title, pp_value
	FROM templatelinks
	JOIN page on page_id = tl_from
	JOIN page_props ON pp_page = page.page_id
	WHERE tl_title = '小文字'
	AND tl_namespace = 10
	AND pp_propname = 'wikibase_item' 
#	LIMIT 10
) AS tmp

#JOIN wb_items_per_site ON ips_site_page = 
JOIN wikidatawiki_p.wb_terms ON term_entity_id = REPLACE(pp_value, 'Q', '')
WHERE term_type = 'label'
AND term_entity_type = 'item'
AND term_language = 'ja'

AND page_title = term_text

order by term_text
SQL

Checking query status...
