Cut First Char

SQL

USE dewiktionary_p;

SELECT
#convert(p1.page_title USING utf8) COLLATE utf8_general_ci,
p1.page_title,
c1.cl_to,
#c2.cl_to,
# As soon as I include one of the following fields,
# the query does not finish within 5 minutes,
# reason unclear.
#p2.page_title,
#p2.page_id,
#p2.page_namespace,
#c2.cl_from,
#c2.cl_to,
'Dummy'
FROM page p1
JOIN categorylinks c1
ON  c1.cl_from = p1.page_id
and c1.cl_to = 'Grundformeintrag_(Deutsch)'
#and c1.cl_to = 'Substantiv_(Deutsch)'
join page p2
on  p2.page_namespace = 0
and p2.page_is_redirect = 0
AND convert(p2.page_title using utf8) = convert(mid(p1.page_title,2) using utf8 ) collate utf8_general_ci
JOIN categorylinks c2
ON  c2.cl_from = p2.page_id
and c2.cl_to = 'Grundformeintrag_(Deutsch)'
#and c2.cl_to = 'Substantiv_(Deutsch)'
where p1.page_namespace = 0
AND p1.page_is_redirect = 0
#AND p1.page_title REGEXP '^[FVfv][[:lower:]]{5,5}$';
#AND p1.page_title REGEXP '^N[[:lower:]]{5,5}$';
#and p1.page_title regexp '^[Nn][[:lower:]]{2,}$'
#and p1.page_title regexp '[Ss][[:lower:]]{3}'
#and convert(p1.page_title using utf8) like 'sk__' collate utf8_general_ci
and ( left(p1.page_title, 1) = 'S' or left(p1.page_title, 1) = 's' )
#and p1.page_title like '_____'
#and p1.page_title regexp '[Ss][[:lower:]]{3}'
#and p2.page_title = 'Raute'

#limit 3
;
SQL

Checking query status...
