Untitled query #59487

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

SQL

select * from pagelinks 
join page on page_id = pl_from 
where page_namespace = 0
and pl_namespace = 118 
and (SELECT page_id from page draft where draft.page_namespace = pl_namespace and pl_title = draft.page_title) IS NULL

AخA
 
select * from pagelinks join page on page_id = pl_from where page_namespace = 0and pl_namespace = 118 and (SELECT page_id from page draft where draft.page_namespace = pl_namespace and pl_title = draft.page_title) IS NULL

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...