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 left(p1.page_title, 3) AS a,
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 JOIN categorylinks
ON  cl_from = p1.page_id
and cl_to = 'Grundformeintrag_(Deutsch)'
left join page p2
on p2.page_namespace = 0
and p2.page_is_redirect = 0
and p2.page_title = p1.a
where p1.page_namespace = 0
AND p1.page_is_redirect = 0
AND p1.page_title = 'Käse';


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