The Never Ending Pool

there is an error in the syntax: SELECT u.username, game.id usergameid, sc.points, sc.rank, venue.city, g.gigdate from jos_pool_concert_scores sc join jos_users u on u.id = sc.user_id join jos_gigcal_gigs g on g.gigcal_gigs_id = sc.gigcal_gigs_id join jos_gigcal_venues venue on venue.gigcal_venues_id = g.gigcal_venues_id join jos_pool_tour_concert c on c.gigcal_gigs_id = g.gigcal_gigs_id join jos_pool_tour t on t.id = c.tour_id join jos_pool_game gm on gm.tour_id = t.id join jos_pool_user_game game on gm.id = game.game_id and game.user_id = u.id where sc.gigcal_gigs_id = 1480 order by sc.rank asc limit 0,250select sc.rank, t.name, t.id,sc.points from jos_pool_concert_scores_team sc join jos_pool_team t on t.id = sc.team_id where sc.rank <= 50 and sc.gigcal_gigs_id = 1480 order by sc.rank

Individual Resultsthere is an error in the syntax: SELECT u.username, scores.tourtotal, scores.user_id, scores.ranktotal, game.id usergameid FROM jos_pool_concert_scores scores join jos_users u on u.id = scores.user_id join jos_pool_tour_concert tc on tc.gigcal_gigs_id = scores.gigcal_gigs_id join jos_pool_game g on g.tour_id = tc.tour_id join jos_pool_user_game game on game.user_id = scores.user_id and game.game_id = g.id where scores.gigcal_gigs_id = 0 order by scores.ranktotal asc limit 0,250select sc.ranktotal, t.name, t.id, sc.tourtotal from jos_pool_concert_scores_team sc join jos_pool_team t on t.id = sc.team_id where sc.ranktotal <= 50 and sc.gigcal_gigs_id = 0 order by sc.ranktotal