Հայերեն Վիքիեդիայի ստեղծված և թարգմանված հոդվածների թիվը

This query is marked as a draft This query has been published by ԱշոտՏՆՂ.

SQL

use wikidatawiki_p;

SELECT Count(ips_site_id), 
       ips_item_id 
FROM   wb_items_per_site w1 
WHERE  NOT EXISTS (SELECT * 
                   FROM   wb_items_per_site w2 
                   WHERE  w2.ips_item_id = w1.ips_item_id 
                          AND w2.ips_site_id = 'hywiki') 
GROUP  BY ips_item_id 
ORDER  BY Count(ips_site_id) DESC 
LIMIT  10;

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