Flair_url is always NULL in SQL query?

I think the data from that column may have been moved at some point. flair_upload_id seems promising:

SELECT g.name,
       g.flair_upload_id, 
       u.url, 
       u.original_filename
FROM groups g
JOIN uploads u on g.flair_upload_id = u.id