Hi All,
I have this query to retrieve information about available players for a competition, which is broken somehow. I cannot figure out where the error is (I get a general error from mysql: #1064 - Er is iets fout in de gebruikte syntax bij 'select distinct ga_id, DATE_FORMAT(ga_date, '%e %M %Y') as ga_da' in regel 1 ). Anybody an idea what I am doing wrong?
select distinct ga_id,
DATE_FORMAT(ga_date, '%e %M %Y') as ga_date,
DATE_FORMAT(ga_ch_date, '%e %M %Y') as challenge_date,
challenger.pe_disp_name as challenger_name,
challenged.pe_disp_name as challenged_name,
ga_ch_accepted, ga_id, ga_friendly
from games
left join people as challenger
on ga_challenger = challenger.pe_id
left join people as challenged
on ga_challenged = challenged.pe_id
where (
( (challenger.pe_id = 1) and (challenged.pe_active = 1) )
or
( (challenged.pe_id = 1) and (challenger.pe_active = 1) )
)
and (ga_played=0)
and (ga_friendly = 0)
and (ga_ch_accepted >=0)
order by ga_friendly ASC, ga_date DESC, challenger.pe_id, challenged.pe_id
select distinct ga_id,
DATE_FORMAT(ga_date, '%e %M %Y') as ga_date,
DATE_FORMAT(ga_ch_date, '%e %M %Y') as challenge_date,
challenger.pe_disp_name as challenger_name,
challenged.pe_disp_name as challenged_name,
ga_ch_accepted, ga_id, ga_friendly
from games
left join people as challenger
on ga_challenger = challenger.pe_id
left join people as challenged
on ga_challenged = challenged.pe_id
where (
( (challenger.pe_id = 4) and (challenged.pe_active = 1) )
or
( (challenged.pe_id = 4) and (challenger.pe_active = 1) )
)
and (ga_played=0)
and (ga_friendly = 0)
and (ga_ch_accepted >=0)
order by ga_friendly ASC, ga_date DESC, challenger.pe_id, challenged.pe_id
