USE bnwikisource_p;

​

# SELECT

# CONCAT("#") AS number, actor_user,

# CONCAT("[[user:",actor_name,"|",actor_name,"]]") AS rev_user_text,

# COUNT(actor_id) AS recent_user_editcount

# /*user_editcount*/

# FROM revision

# JOIN actor ON rev_actor=actor_id

# JOIN page ON rev_page=page_id

# WHERE actor_user IS NOT NULL

#   AND page_namespace IN ('0','104')

#   AND rev_timestamp BETWEEN 20200322000000 AND 20200423235959

# GROUP BY actor_id

# ORDER BY recent_user_editcount DESC

# LIMIT 500;

​

SELECT DISTINCTROW 

rc_title,

actor_name,

rc_timestamp

FROM recentchanges rc

JOIN actor ac ON rc.rc_actor=ac.actor_id

WHERE rc_title LIKE 'গীতিমাল্য-রবীন্দ্রনাথ ঠাকুর.djvu%'

  AND rc_namespace=104;