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

SQL

AخA
 
SELECT CONCAT("Q", ips_item_id) as item, ips_site_page
  FROM wikidatawiki_p.wb_items_per_site 
  WHERE ips_site_id='hywiki' 
    AND ips_site_page NOT LIKE "Պատկեր:%"
    AND ips_site_page NOT LIKE "Կաղապար:%"
    AND ips_site_page NOT LIKE "Կատեգորիա:%"
    AND ips_site_page NOT LIKE "Վիքիպեդիա:%"
    AND ips_site_page NOT LIKE "Օգնություն:%"
    AND ips_site_page NOT LIKE "Մոդուլ:%"
    AND ips_site_page NOT LIKE "Պորտալ:%"
    
    AND REPLACE(ips_site_page, ' ', '_') NOT IN (SELECT page_title FROM hywiki_p.page WHERE page_namespace = 0)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...