USE bnwikisource_p;

SELECT current_date;

SELECT DISTINCT

 /* SUBSTRING_INDEX(p1.page_title, '/', 1) as page_num, */      

 CONCAT("পাতা:", p1.page_title) as page 

FROM page p1

INNER JOIN revision_userindex r1 ON r1.rev_page = p1.page_id

INNER JOIN categorylinks c ON c.cl_from = p1.page_id AND c.cl_to = 'মুদ্রণ সংশোধন করা হয়েছে'

WHERE p1.page_namespace = 104

AND r1.rev_user_text IN ('Mahir256') 

AND c.cl_to IS NOT NULL

ORDER BY p1.page_latest