Cut Final Character

SQL

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

SELECT 
p1.page_title,
p1.page_id,
p1.page_namespace,
c1.cl_from,
c1.cl_to,
#p2.page_title,
#p2.page_id,
#p2.page_namespace,
#c2.cl_from,
#c2.cl_to,
'Dummy'
FROM page p1
left JOIN categorylinks c1
ON  c1.cl_from = p1.page_id
and c1.cl_to = 'Grundformeintrag_(Deutsch)'
left join page p2
on  p2.page_namespace = 0
and p2.page_is_redirect = 0
and p2.page_title = left(p1.page_title, 3)
left JOIN categorylinks c2
ON  c2.cl_from = p2.page_id
and c2.cl_to = 'Grundformeintrag_(Deutsch)'
where p1.page_namespace = 0
AND p1.page_is_redirect = 0
AND p1.page_title = 'Baum';


#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'
#and 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...
