Untitled query #44302

SQL

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
JOIN actor ON rc_actor=actor_id
WHERE recentchanges.rc_title LIKE 'গৌড়লেখমালা (প্রথম স্তবক).djvu%'
  AND recentchanges.rc_namespace=104;
SQL

Checking query status...
