use hewiki_p;

select pagelinks.*, page_title from pagelinks join page

on pl_from_namespace = 0

and not pl_namespace in (0, 1, 4, 6, 8, 10, 12, 14, 100, 108)

and pl_from = page_id

​