Wikidata terms with trailing spaces

SQL

USE cswiki_p;
SELECT pages.page_title, ids1.pp_value, CONCAT("Kategorie:",cl_to), ids2.pp_value#, 'P910' , 'S143', 'Q191168'
	FROM page AS pages
	JOIN categorylinks AS cl
		ON cl_from = pages.page_id
	JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS ids1
		ON ids1.pp_page = pages.page_id
	JOIN wikidatawiki_p.page AS items
		ON items.page_namespace = 0 AND items.page_title = ids1.pp_value
	LEFT JOIN wikidatawiki_p.pagelinks AS withmain
		ON withmain.pl_from = items.page_id AND pl_title = 'P910' AND pl_namespace = 120
	JOIN page AS categories
		ON categories.page_namespace = 14 AND categories.page_title = cl_to
	JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS ids2
		ON ids2.pp_page = categories.page_id
WHERE cl_sortkey_prefix = ' ' AND withmain.pl_from IS NULL
LIMIT 1;#ORDER BY pages.page_title;
SQL

Checking query status...
