update queries that retrieve club competition
test