Untitled query #31760

SQL

USE fawiki_p;
SELECT page_title, comment_text, MID(comment_text,119,30)#, rev_comment# DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]')#,rev_timestamp
FROM comment JOIN revision ON rev_comment_id= comment_id JOIN page ON rev_page=page_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND comment_text LIKE '[[ویکی‌پدیا:ابزار پیوندساز|ابزار پیوندساز]]: افزودن پیوند%'

AND page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation'
)

ORDER BY rev_timestamp
#LIMIT 500;
SQL

Checking query status...
