Wikidata talk:WikiProject Commons/Phase 1 progress/Links/Module
Jump to navigation
Jump to search
SQL queries[edit]
- Formatted - http://quarry.wmflabs.org/query/492
use wikidatawiki_p;
SELECT CONCAT('* [[Q', ips_item_id, ']] : [[:c:', ips_site_page, ']] <--- {{Q|', ips_item_id, '}}') AS '== List of sitelinks =='
FROM wb_items_per_site
WHERE ips_site_id='commonswiki' AND ips_site_page LIKE 'Module:%'
ORDER BY ips_item_id;
- Unformatted - http://quarry.wmflabs.org/query/491
use wikidatawiki_p;
SELECT CONCAT('Q', ips_item_id) AS item, ips_site_page AS link
FROM wb_items_per_site
WHERE ips_site_id='commonswiki' AND ips_site_page LIKE 'Module:%'
ORDER BY ips_item_id ASC;