Cut Final Character

SQL

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

SELECT CONCAT('# [[',p1.page_title,']]') AS page_title,
p1.page_id,
p1.page_namespace,
cl_from,
cl_to#,
#As soon as I include p2.page_title in the list,
#the query will run for 5 minutes or longer.
#unclear why that is.
#p2.page_title,

#p2.page_id#,
#p2.page_namespace
FROM page p1
LEFT OUTER JOIN categorylinks
ON cl_from = p1.page_id
left OUTER 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 = 0
AND p1.page_is_redirect = 0
#AND p1.page_title REGEXP '^Käse$';
AND p1.page_title = 'Käse'
and p2.page_title = 'Substantiv_(Deutsch)';
SQL

Checking query status...
