Error checking hole averages: SELECT round(avg(score),2) as avgscore FROM sm_scoredata s, sm_rounds r, sm_holedata h WHERE r.id=s.roundid and (( r.compid=5921 OR r.compid=5922 r.compid = 5666 or r.compid = 5667 or r.compid = 5918 or r.compid = 5919)) and r.courseid=h.courseid and h.par=3 and h.hole=s.hole and s.score > 0You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'r.compid = 5666 or r.compid = 5667 or r.compid = 5918 or r.compid = 5919)) and r' at line 3