tl_namespace, tl_title obsolesced

Templates/modules transcluded on [[:Category:Wikipedia files with the same name on Wikimedia Commons as of 19 September 2022]], as they now appear in the db.

See also https://lists.wikimedia.org/hyperkitty/list/wikitech-l@lists.wikimedia.org/message/U2U6TXIBABU3KDCVUOITIGI5OJ4COBSW/

For [[WT:Database reports#Listing maintenance categories]] and [[WT:Request a query#New linktarget table]] circa 15 September 2022.

SQL

SELECT templatelinks.*, linktarget.*
FROM templatelinks
JOIN page ON page_id = tl_from
LEFT JOIN linktarget ON lt_id = tl_target_id
WHERE page_namespace = 14 -- Category:
  AND page_title = 'Wikipedia_files_with_the_same_name_on_Wikimedia_Commons_as_of_19_September_2022'
ORDER BY lt_namespace ASC, lt_title ASC;

AخA
 
SELECT templatelinks.*, linktarget.*FROM templatelinksJOIN page ON page_id = tl_fromLEFT JOIN linktarget ON lt_id = tl_target_idWHERE page_namespace = 14 -- Category:  AND page_title = 'Wikipedia_files_with_the_same_name_on_Wikimedia_Commons_as_of_19_September_2022'ORDER BY lt_namespace ASC, lt_title ASC;

SQL

Checking query status...