مساعدة:استعلام - ويكيبيديا

USE arwiki_p; SELECT page_title FROM page WHERE page_namespace = 0     AND page_is_redirect = 0     AND page_title LIKE "%_كتاب_%" LIMIT 500; 

USE arwiki_p; SELECT page_title FROM page LEFT JOIN pagelinks ON pl_from = page_id WHERE page_namespace = 0     AND page_is_redirect = 0     AND pl_namespace IS NULL GROUP BY page_id; 

USE enwiki_p; SELECT CONCAT (         ":",         page_title,         "]]||",         count(*),         "||",         page_len         ) FROM langlinks INNER JOIN page ON ll_from = page_id WHERE page_namespace = 0     AND page_is_redirect = 0     AND NOT EXISTS (         SELECT *         FROM langlinks AS t         WHERE t.ll_lang = "ar"             AND t.ll_from = langlinks.ll_from         ) GROUP BY ll_from ORDER BY count(*) DESC,     page_title limit 500; 

USE enwiki_p; SELECT /*SLOW OK*/ page_title FROM page WHERE page_id IN (         SELECT tl_from         FROM templatelinks         WHERE tl_title = "Infobox_film"             AND tl_namespace = 10             AND tl_from IN (                 SELECT ll_from                 FROM langlinks                 WHERE ll_from                 GROUP BY ll_from                 HAVING COUNT(*) > 20                 )             AND tl_from NOT IN (                 SELECT ll_from                 FROM langlinks                 WHERE ll_lang = "ar"                 )         )limit 500; 

USE arwiki_p; SELECT page_title FROM page LEFT JOIN categorylinks ON cl_from = page_id WHERE page_namespace = 0     AND page_is_redirect = 0     AND ISNULL(cl_from); 

USE arwiki_p; select page_title from page where page_namespace = 0 and page_is_redirect = 0 and page_id in (select cl_from from categorylinks group by cl_from having count(*) < 3) limit 10; 

USE arwiki_p;  SELECT  page_title  FROM page  WHERE page_id IN (          SELECT tl_from          FROM templatelinks          WHERE tl_title = "محمية")  AND page_id NOT IN (          SELECT pr_page FROM page_restrictions          WHERE pr_expiry  LIKE 'infinity')  AND page_namespace = 0  ORDER BY page_title ; 

USE arwiki_p; SELECT /*SLOW OK */     DATE (         CONCAT (             YEAR(rev_timestamp),             "-",             MONTH(rev_timestamp),             "-",             DAY(rev_timestamp)             )         ) AS DAY,     COUNT(rev_timestamp) AS revisions FROM revision WHERE rev_user_text = 'Reza1615' GROUP BY DAY; 

USE arwiki_p; SELECT         log_user_text AS المستخدم,         log_type AS الفعل,         COUNT(log_timestamp) AS العدد         FROM logging         WHERE log_timestamp BETWEEN  20160101000000 AND 20160731235959         AND log_user_text = "Elph"         GROUP BY (log_type)         ORDER BY COUNT(log_timestamp)         ; 

USE arwiki_p; SELECT /*SLOW OK */ page_title,     DATE (         CONCAT (             YEAR(rev_timestamp),             "-",             MONTH(rev_timestamp),             "-",             DAY(rev_timestamp)             )         ) AS DAY FROM revision INNER JOIN page ON rev_page = page_id WHERE page_namespace = 0     AND rev_user_text = 'Reza1615'     AND rev_parent_id = 0     AND page.page_is_redirect = 0 GROUP BY DAY;  ORDER BY rev_timestamp; 

USE arwiki_p; SELECT         rev_user_text AS المستخدم,         page_namespace AS النطاق,         COUNT(rev_timestamp) AS عدد_التعديلات         FROM revision         JOIN page ON rev_page = page_id         WHERE rev_timestamp BETWEEN  20160101000000 AND 20160731235959         AND rev_user_text = "Elph"         GROUP BY (page_namespace)         ORDER BY COUNT(rev_timestamp)         ; 

USE arwiki_p; SELECT user_name, user_editcount FROM user WHERE user_name NOT IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot') ORDER BY user_editcount DESC LIMIT 500;