we cascade the LEFT JOIN-ed queries to ensure correct cardinality of records (probably not necessary when joining affiliations + keywords because affiliations are 1 to 1, but definitely needed when joining affs + kws + hashtags)