Your Pool MailboxYou are not logged in. Pool LoginPrivate MessagesYou are not logged in. Latest Concertselect max(g.id) id from jos_pool_game g join jos_pool_tour tour on tour.id = g.tour_id where tour.published = 1there 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 = 0
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 = 0
order by sc.rank Overall Scoresselect ifNULL(max(g.id),0) id from jos_pool_game g join jos_pool_tour tour on tour.id = g.tour_id where tour.published = 1Individual 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 Pool Menu |
Re:Set list (2 viewing) (2) Guests
Powered by FireBoard
|