Pages translated using Google Translate-bnwiki

Fork of Pages translated using Google Translate-bnwiki by Arjunaraoc

This query is marked as a draft This query has been published by Theredproject.

SQL

use enwiki_p;
SELECT  page_id,
		rev_parent_id,
		rev_len,
		rev_id,
		user_id,
		user_name,
		rev_timestamp,
		page_title
FROM revision
LEFT JOIN  page ON revision.rev_page=page.page_id
LEFT JOIN user
      ON rev_actor = user_id
INNER JOIN page article ON 
   article.page_id = rev_page AND
   article.page_namespace = 0
INNER JOIN page talk ON 
   talk.page_title = article.page_title AND
   talk.page_namespace = 1
INNER JOIN categorylinks ON 
   cl_from = talk.page_id
INNER JOIN page_props ON
   article.page_id = page_props.pp_page
WHERE page.page_namespace = 0 AND page_is_redirect =0 
GROUP BY page_title
ORDER BY page_title

SQL

Checking query status...