مقالهٔ ایجاد شده توسط کاربر بر پایه حجم و میان ویکی

SQL

USE fawiki_p;
(SELECT DISTINCT page_namespace as namespace, 'rev' as type, page_title as page_title, page_is_redirect as page_is_redirect, rev_timestamp as timestamp, rev_user, rev_user_text
			FROM page
			JOIN revision_userindex on page_id = rev_page
			WHERE  $whereRev  AND rev_parent_id = '0'  $namespaceConditionRev  $redirectCondition
			)
			
			UNION
			
			(SELECT  a.ar_namespace as namespace, 'arc' as type, a.ar_title as page_title, '0' as page_is_redirect, min(a.ar_timestamp) as timestamp , a.ar_user as rev_user, a.ar_user_text as rev_user_text
			FROM archive_userindex a
			JOIN 
			 (
			  Select b.ar_namespace, b.ar_title
			  FROM archive_userindex as b
			  LEFT JOIN logging_logindex on log_namespace = b.ar_namespace and log_title = b.ar_title  and log_user = b.ar_user and (log_action = 'move' or log_action = 'move_redir')
			  WHERE  $whereArc AND b.ar_parent_id = '0' $namespaceConditionArc  $moveCond
			 ) AS c on c.ar_namespace= a.ar_namespace and c.ar_title = a.ar_title 
			GROUP BY a.ar_namespace, a.ar_title
			HAVING  $having
			)
			
			ORDER BY namespace ASC, timestamp DESC limit 10;
SQL

Checking query status...
