Most used modules on plwiki

This query is marked as a draft This query has been published by The Polish.
SQL

#RESULTSET_11
USE plwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title, CONCAT('[[Wikipedysta:',rd_title,']]') AS rd_title
FROM page
JOIN redirect
ON rd_FROM = page_id
AND page_namespace = 0
AND rd_namespace = 2
ORDER BY page_title, rd_title;
#RESULTSET_12
USE plwiki_p;
SELECT CONCAT('# [[',page_title,']]') AS page_title, pp_propname
FROM page_props
JOIN page
ON page_id = pp_page
WHERE page_namespace = 0
AND pp_propname IN ('index', 'newsectionlink', 'noeditsection', 'nonewsectionlink', 'notitleconvert')
AND page_title NOT LIKE '%według_pierwiastków%';
#RESULTSET_13
USE plwiki_p;
SELECT CONCAT("# [[",page_title,"]]") AS page_title, GROUP_CONCAT(cl_to SEPARATOR ',') AS cl_to
FROM categorylinks
JOIN page ON cl_from=page_id
WHERE cl_to rlike "Urodzeni_w_1.*"
AND page_title NOT LIKE '%_i_%'
AND page_title NOT LIKE 'Bracia%'
AND page_title NOT LIKE 'Honor_Blackman'
AND page_title NOT LIKE 'Samuel_Shelley'
AND page_title NOT LIKE 'Joyce_Redman'
AND page_title NOT LIKE 'Zhu_Da'
AND page_title NOT LIKE 'Thomas_Morley'
AND page_title NOT LIKE 'Stefan_Pogonowski'
AND page_title NOT LIKE 'Rojda_Felat'
AND page_title NOT LIKE 'Jan_Horodeński'
AND page_title NOT LIKE 'Jason_Derek_Brown'
AND page_title NOT LIKE 'Jan_Kanty_Szwedkowski'
GROUP BY cl_from
HAVING COUNT(cl_to)>1;
#RESULTSET_14
USE plwiki_p;
SELECT CONCAT("# [[",page_title,"]]") AS page_title, GROUP_CONCAT(cl_to SEPARATOR ',') AS cl_to
FROM categorylinks
JOIN page ON cl_from=page_id
WHERE cl_to rlike "Zmarli_w_1.*"
AND page_title NOT LIKE '%_i_%'
AND page_title NOT LIKE 'Bracia%'
AND page_title NOT LIKE 'Spytko_IV_z_Melsztyna'
GROUP BY cl_from
HAVING COUNT(cl_to)>1;
#RESULTSET_15
USE plwiki_p;
SELECT CONCAT('# [[:Kategoria:',cat_title,']]') AS cat_title, cat_pages
FROM page, category
WHERE page_title = cat_title
AND page_namespace = 14
AND page_is_redirect = 1
ORDER BY cat_pages DESC, cat_title ASC;
#RESULTSET_16
USE plwiki_p;
SELECT CONCAT('# [[:Kategoria:',page_title,']]') AS page_title
FROM page
LEFT OUTER JOIN categorylinks
on cl_FROM = page_id
WHERE cl_FROM is null
AND page_namespace = 14
AND page_title NOT LIKE 'Kategorie'
AND page_title NOT LIKE '%wstawienia%'
AND page_title NOT LIKE 'Wikipedysta:Pablo000/dyskusja';
#RESULTSET_17
USE plwiki_p;
SELECT DISTINCT CONCAT('# [[',page_title,']]') AS page_title
FROM page
JOIN imagelinks
ON page_id = il_from
WHERE (NOT EXISTS(
SELECT 1
FROM image
WHERE img_name = il_to))
AND (NOT EXISTS(
SELECT
1
FROM commonswiki_p.page
WHERE page_title = il_to
AND page_namespace = 6))
AND page_namespace = 0;
#RESULTSET_19
SELECT CONCAT('# [[',p1.page_title,']]') AS page_title
FROM page p1
LEFT OUTER JOIN categorylinks
ON cl_from = p1.page_id
LEFT JOIN page p2
ON cl_to = p2.page_title AND p2.page_namespace = 14
LEFT JOIN page_props
ON p2.page_id = pp_page AND pp_propname = 'hiddencat'
WHERE p1.page_namespace = 0
AND p1.page_is_redirect = 0
AND p1.page_title NOT LIKE '%/%'
AND p1.page_title NOT LIKE 'Lista_planetoid%'
GROUP BY p1.page_title
HAVING COUNT(cl_from)-COUNT(pp_propname) = 0;
#RESULTSET_20
SELECT CONCAT('# [[:Kategoria:',cl_to,'|Kategoria:',cl_to,']]') AS cl_to, COUNT(*) AS count_cl_to
FROM page, categorylinks
WHERE page_id = cl_from
AND page_namespace = 0
AND NOT EXISTS
(SELECT * FROM page AS p1
WHERE cl_to = p1.page_title
AND p1.page_namespace = 14)
GROUP BY cl_to
ORDER BY count_cl_to DESC, cl_to ASC;
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...
