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 revision_comment_temp ON rev_id=revcomment_rev
JOIN comment on revcomment_comment_id=comment_id
JOIN revision_actor_temp ON rev_id=revactor_rev
JOIN actor ON revactor_actor=actor_name
WHERE
  page_namespace=104 AND
  page_title RLIKE '^এতদ্দেশীয়_স্ত্রীলোকদিগের_পূর্ব্বাবস্থা.pdf/' AND  
  comment_text RLIKE '^/\\\* '
ORDER BY rev_timestamp DESC
LIMIT 5000;
SQL

Checking query status...
