I'm a bit stuck for a way to join 4 tables in a single query in MySQL.
The tables relate to a submission system for users to submit 1 or more
links against a specific topic. The tables are follows:
// table 'topic'
// table 'submission'
// table 'link'
// table 'user'
I'm trying to get it so when I query it with a specific topic, I want
the details of the topic, submissions and all associated links and
user details. As theres no common table that joins them ...