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=8121 OR r.compid=8122 r.compid = 7782 or r.compid = 7783 or r.compid = 8105 or r.compid = 8106)) 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 = 7782 or r.compid = 7783 or r.compid = 8105 or r.compid = 8106)) and r' at line 3