USE urwiki_p;

SELECT

  CONCAT('[[',page_title,']]')

FROM page

LEFT JOIN pagelinks

ON pl_title = page_title

AND pl_namespace = page_namespace

WHERE pl_namespace IS NULL

AND page.page_namespace =0 AND page.page_is_redirect = 0

and page.page_id not in (select tl_from from templatelinks  where tl_title = 'يتيمة')

and page.page_id not in (select tl_from from templatelinks  where tl_title = 'توضيح') 

LIMIT 100;