Your Pool MailboxYou are not logged in. Pool LoginPrivate MessagesYou are not logged in. Latest ConcertScores for 6.04.24 Austin Individual Results
Team Results
Overall ScoresIndividual 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 = 1480
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 = 1480
order by sc.ranktotal Pool Menu |
Re:RAMBLIN' JACK ELLIOTT THREAD (4 viewing) (4) Guests
Powered by FireBoard
|