I am trying to find articles that use "Template:Auto short description" but not "Template:Short description". Is this possible?
Topic on Talk:Quarry
Though it is possible using an SQL query, you can also use the default search.
Thank you. But I also need to sort by the length of the induced short description, so it has to be SQL.
I think I misunderstood your request. "Template:Short description" is used inside articles, but "Template:Auto short description" is only for documentation purposes. So you actually want articles with a template documented as "short description inducing" without "Template:Short description", right?
I made this query (hope it's correct):
SELECT page_title, LENGTH(pp_value) AS len, pp_value FROM page_props JOIN page ON page_id = pp_page LEFT JOIN templatelinks ON tl_from = page_id AND tl_target_id = 137 # Short_description WHERE pp_propname = 'wikibase-shortdesc' AND tl_target_id IS NULL AND page_namespace = 0 AND page_is_redirect = 0 AND EXISTS ( SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id JOIN page ON page_namespace = lt_namespace AND page_title = lt_title JOIN categorylinks ON cl_from = page_id WHERE tl_from = page_id AND cl_to = 'Templates_that_generate_short_descriptions' );
It took 10 minutes and the only returned entry was for en:Main_Page.
I very much appreciate the effort. But there are probably a few thousand pages that have very long induced short descriptions. I was able to find this one: [https://en.wikipedia.org/wiki/St._Anthony_Catholic_School] by skimming through [https://quarry.wmcloud.org/query/82687]. A fellow wikipedian who adds SDs requested a script for all such auto-SDs in excess of 80 characters, although SDs tend to get visually cut off around 55 characters.
The "AND tl_target_id = 137" seems to filter in only articles with explicit SDs. But changing it to "AND tl_target_id <> 137" gives a list of template links that aren't T:short_description. I'm not sure how to make it return a list of pages instead of template links.