Untitled query #58544

SQL

/*SELECT page_title FROM categorylinks INNER JOIN page on cl_from=page_id WHERE cl_to='Mallar_som_använder_data_från_Wikidata'


/*
SELECT COUNT(*) FROM page INNER JOIN templatelinks ON page_id=tl_from INNER JOIN linktarget ON tl_target_id=lt_id 
INNER JOIN categorylinks ON cl_from=page_id WHERE
cl_to = 'Mallar_som_använder_data_från_Wikidata'
AND lt_title = 'Alvin'
AND lt_namespace = 10
AND page_namespace = 0
GROUP BY lt_title
*/
SELECT COUNT(DISTINCT page_title) FROM page 
INNER JOIN templatelinks ON page_id=tl_from 
INNER JOIN linktarget ON tl_target_id = lt_id WHERE
lt_title IN ('Alvin','Arken') 
GROUP BY lt_title

/*
(SELECT page_title FROM categorylinks INNER JOIN page on cl_from=page_id WHERE cl_to='Mallar_som_använder_data_från_Wikidata')

/*
SELECT page_title FROM page WHERE
page_title REGEXP '_Q[1-9]'
*/

/*
SELECT DISTINCT rc_title FROM recentchanges INNER JOIN page ON rc_title=page_title WHERE
rc_timestamp > '20221226000000'
AND rc_namespace = 0
AND rc_type < 2
ORDER BY rc_timestamp DESC
LIMIT 1000
*/

/*
SELECT MID(log_timestamp,1,6) AS blockeringsmanad, COUNT(*) FROM logging WHERE
log_type = 'block' AND
log_timestamp > '2018010100000' AND log_timestamp < '20221201000000'
GROUP BY blockeringsmanad
ORDER BY blockeringsmanad
*/

/*
SELECT * FROM user LEFT JOIN ipblocks ON user_id=ipb_user WHERE
ipb_user IS NULL AND
user_registration > '20221001000000' AND user_registration < '20221201000000' AND
user_editcount >= 5
*/
/*
GROUP BY registreringsmanad
ORDER BY registreringsmanad
*/

/*
SELECT MID(user_registration,1,6) AS registreringsmanad, COUNT(*) AS antal FROM user LEFT JOIN ipblocks ON user_id=ipb_user WHERE
ipb_user IS NULL AND
user_registration > '20170101000000' AND user_registration < '20221201000000' AND
user_editcount >= 5
GROUP BY registreringsmanad
ORDER BY registreringsmanad
*/

/*
SELECT actor_name, COUNT(*) AS antal FROM revision INNER JOIN page ON rev_page=page_id INNER JOIN actor ON rev_actor=actor_id WHERE 
page_title LIKE 'Opinionsundersökningar_inför_riksdagsvalet_i_Sverige_2022' AND
page_namespace = 0
GROUP BY actor_name
ORDER BY antal DESC
*/

/*
SELECT  page_title, MAX(rc_timestamp) AS senast, COUNT(*) AS antal FROM recentchanges INNER JOIN page ON rc_title=page_title INNER JOIN categorylinks ON page_id=cl_from WHERE
rc_timestamp > '20221101000000' AND
rc_type < 5 AND
(cl_to = 'Kvinnor' OR cl_to = 'Män')
GROUP BY page_title
*/
SQL

Checking query status...
