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 page_title,
# 		comment_text,
#         rev_id,
#         rev_page,
#         actor_name,
#         rev_timestamp
# FROM revision
# JOIN page ON page_id = rev_page
# JOIN comment on rev_comment_id=comment_id
# JOIN actor on rev_actor=actor_id
# WHERE
#   page_namespace=104 AND
#   page_title RLIKE '^এতদ্দেশীয়_স্ত্রীলোকদিগের_পূর্ব্বাবস্থা.pdf/' AND  
#   comment_text RLIKE '^/\\\* '
# ORDER BY rev_timestamp DESC
# LIMIT 5000;

SELECT page_title,
rev_comment,
rev_id,
rev_page,
rev_user_text,
rev_timestamp
FROM revision
JOIN page ON page_id = rev_page
JOIN comment on rev_comment_id=comment_id
JOIN actor on rev_actor=actor_id
WHERE
  page_namespace=104 AND
  comment_text RLIKE '^/\\\* ' AND
  rev_timestamp > 20161231235999 AND rev_timestamp < 20170131235999
ORDER BY rev_timestamp 
LIMIT 10000;
SQL

Checking query status...
