اردو ویکیپیڈیا صارفین کی ویکی ڈیٹا ترامیم

SQL

SELECT
    CONCAT("[[صارف:", wd.user_name, "|", wd.user_name, "]]"),
    CONCAT("[[d:special:Contributions/", wd.user_name, "|", wd.user_editcount, "]]"),
    DATE_FORMAT(wd.user_registration, '%d-%m-%Y') AS reg
FROM (
  SELECT user_name, user_editcount
  FROM urwiki_p.user
) AS ur
JOIN wikidatawiki_p.user AS wd ON wd.user_name = ur.user_name
WHERE wd.user_name NOT LIKE 'Bot%' 
    AND wd.user_name NOT LIKE 'bot%' 
    AND wd.user_name NOT LIKE '%bot' 
    AND wd.user_name NOT LIKE '%Bot' 
    AND wd.user_name NOT LIKE '%Bot%' 
    AND wd.user_name NOT LIKE '%bot%'
    AND wd.user_name NOT LIKE 'Flow%'
    AND wd.user_name NOT LIKE 'Mediawiki%'
    AND wd.user_name NOT LIKE 'MediaWiki%'
    AND wd.user_name NOT LIKE '%Delinker'
ORDER BY ur.user_editcount DESC
LIMIT 100;

SQL

Checking query status...