Would something like this fit the bill?
--[params]
-- date :start_date
-- date :end_date
SELECT
'https://meta.discourse.org/' || 't/' || t.slug || '/' || t.id || '/' || p.post_number AS post_url,
COUNT(*) AS external_click_count
FROM incoming_links il
INNER JOIN posts p ON p.id = il.post_id
INNER JOIN topics t ON t.id = p.topic_id
WHERE t.archetype = 'regular'
AND il.created_at::date BETWEEN :start_date AND :end_date
GROUP BY p.id, t.id
ORDER BY external_click_count DESC
(Though swop out your own site link rather than https://meta.discourse.org 
)