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 rc_title LIKE 'গীতিমাল্য-রবীন্দ্রনাথ_ঠাকুর.djvu%'
#  AND rc_namespace=104;

SELECT * from revision LIMIT 10;
SQL

Checking query status...
