Untitled query #48245

SQL

use arwiki_p;
select 
	CONCAT('# [[',page.page_title,']]')
from page 
where page_namespace = 0
and page_is_redirect = 0
and page_id in (select tl_from from templatelinks  where tl_title = 'إيقونة_مختارة') 
#and page_id in (select tl_from from templatelinks  where tl_title = 'إيقونة_جيدة') 

and page_id in (select tl_from from templatelinks  where tl_title = 'شريط_محتوى_متميز') 
#and page_id not in (select tl_from from templatelinks  where tl_title = 'شريط_محتوى_متميز') 

order by rand();
SQL

Checking query status...
