Untitled query #54661

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

SQL

SELECT i1.ips_item_id from wb_items_per_site i1
 LEFT OUTER JOIN wb_items_per_site i2
ON i1.ips_item_id=i2.ips_item_id 
AND i2.ips_site_id='simplewiki' 
WHERE i1.ips_site_id='enwiki'
AND i2.ips_site_id IS NULL
 
AND i1.ips_site_page IN ('Abacavir','Aciclovir','Adenosine','Azathioprine','Entecavir','Fludarabine','Mercaptopurine','Tenofovir disoproxil','Tioguanine','Valaciclovir','Valganciclovir')
order by i1.ips_site_page limit 100 OFFSET 0

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...