We need the list of citations (TWL citations and total citations) to the following URLs for the past 1 year (1st July 2025 to 1st July 2026).
https://www.africaintelligence.fr/
https://www.africaintelligence.com/
https://www.intelligenceonline.fr/
https://www.intelligenceonline.com/
https://www.lalettre.fr/fr/
https://www.glitz.paris/fr
https://www.glitz.paris/en
@sjvipin is this something you can lookup in
https://wikilink-archive.toolforge.org/
?
No, this was not configured on WikiLink. Sam told me we can only give them a list of today's citations, since we weren't tracking. We can go with that.
cc -@Samwalton9-WMF
If it can help, this tool list additions of external links in the pages with the timestamp across all wikis: https://spamcheck.toolforge.org/by-domain?q=africaintelligence.fr It collects data since November 2023.
I've got the same need for linforme.com partnership and used to call this tool database directly to get this chart :
SELECT
CONCAT(YEAR(rev_timestamp), '-', LPAD(MONTH(rev_timestamp), 2, '0')) AS month,
COUNT(*) AS edits_count
FROM addedlink
INNER JOIN host ON al_host = hst_id
INNER JOIN revision ON al_rev = rev_id
INNER JOIN db ON rev_db = db_id
INNER JOIN scheme ON al_scheme = sch_id
LEFT JOIN pathoverflow ON al_path_overflow = pof_id
LEFT JOIN usertext ON rev_user_text = ut_id
WHERE hst_host LIKE 'com.linforme%'
AND al_path IS NOT NULL
GROUP BY
YEAR(rev_timestamp),
MONTH(rev_timestamp)
ORDER BY
YEAR(rev_timestamp),
MONTH(rev_timestamp)