Untitled query #58544

SQL

SELECT lt_title, COUNT(tl_from) AS antal FROM linktarget JOIN templatelinks ON tl_target_id=lt_id WHERE 
lt_namespace = 10 AND
lt_title IN ('A6_Tyskland','A7_Tyskland','AHL-lag','Adlig','Akademisk_tidskrift')
GROUP BY lt_title
HAVING antal >= 10
ORDER BY antal DESC


/*
SELECT COUNT(page_title) AS antal, lt_title FROM page JOIN templatelinks ON page_id=tl_from JOIN linktarget ON tl_target_id=lt_id WHERE
tl_from_namespace = 0
AND lt_title IN ('Webbref','Faktamall')
GROUP BY lt_title
*/
/*
SELECT actor_name, COUNT(*), MAX(rc_timestamp) AS senast FROM recentchanges JOIN actor ON rc_actor = actor_id WHERE
rc_timestamp > '20240704110000'
AND rc_type >4
GROUP BY actor_name
ORDER BY senast DESC
*/

/*
SELECT rc_timestamp, rc_title, actor_name, comment_text FROM recentchanges JOIN comment ON rc_comment_id=comment_id JOIN actor ON rc_actor=actor_id WHERE
rc_timestamp > '20240601000000'
AND comment_text LIKE '%ILL%'
*/
/*
SELECT log_timestamp, log_title, actor_name, log_params, REPLACE(comment_text,',','§') AS commenttext FROM logging JOIN comment ON log_comment_id=comment_id JOIN actor on log_actor=actor_id WHERE 
log_timestamp > '20230101000000'
AND log_timestamp < '20240601000000'
AND log_action = 'block'
AND (log_params LIKE '%week%' OR log_params LIKE '%month%' OR log_params LIKE '%year%')
AND NOT log_title LIKE '%.%'
AND NOT log_title LIKE '%:%'
ORDER BY log_timestamp DESC
*/
/*
SELECT SUBSTR(rev_timestamp,1,8) AS datum FROM revision JOIN page on rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp LIKE '2024%'
AND actor_name != ''
AND page_namespace = 0
AND SUBSTR(rev_timestamp,1,8) NOT IN (
SELECT SUBSTR(rev_timestamp,1,8) AS datum FROM revision JOIN page on rev_page=page_id JOIN actor ON rev_actor=actor_id WHERE
rev_timestamp LIKE '2024%'
AND actor_name = 'Larske'
AND page_namespace = 0
)
GROUP BY datum 
ORDER BY datum
*/
SQL

Checking query status...
