Cut Final Character

SQL

USE dewiktionary_p;
select page_title, page_id, page_namespace
from page
where page_title = 'Substantiv_(Deutsch)';

SELECT CONCAT('# [[',p1.page_title,']]') AS page_title,
p1.page_id,
p1.page_namespace,
cl_from,
cl_to#,
#p2.page_title,
#p2.page_id,
#p2.page_namespace
FROM page p1
LEFT JOIN categorylinks
ON cl_from = p1.page_id
#left JOIN page p2
#ON  p2.page_title = cl_to 
#AND p2.page_namespace = 14
#LEFT JOIN page_props
#ON p2.page_id = pp_page AND pp_propname = 'hiddencat'
WHERE p1.page_namespace = '(main)'
AND p1.page_is_redirect = 0
#AND p1.page_title REGEXP '^Käse$';
AND p1.page_title = 'Käse'
and cl_to = 'Substantiv_(Deutsch)';
SQL

Checking query status...
