I just quickly hacked together this query which pulls out all amazon URLs in post answers:
SELECT REGEXP_EXTRACT(body, r'[^a-z](http[a-z\:\-\_0-9\/\.]+amazon[a-z\:\-\_0-9\/\.]*)[^a-z]') AS link, COUNT(1)
FROM [bigquery-public-data:stackoverflow.posts_answers]
GROUP BY 1 ORDER BY 2 DESC LIMIT 20
It takes 5 seconds to run - over ALL stackoverflow answers!
I just quickly hacked together this query which pulls out all amazon URLs in post answers:
It takes 5 seconds to run - over ALL stackoverflow answers!