SQL Error [1242] [21000]: Subquery returns more than 1 row (AMATEUR)
You should be joining between each table on the fields you're trying to compare in the WHERE clause. Then your  statement can be on top of that.