 |
|
|
|
select games, yellows, two_yellows, reds, pens, tournament, t.name as tour_name, round(yellows/games+0.000001, 2) as avg_yellows, round((yellows+2*reds)/games+0.000001, 2) as avg_cards from referee_statistics, tournaments t where referee = 1842 and t.id = tournament and tournament != 1 and tournament != 5 error: Out of resources when opening file './fb/referee_statistics.MYD' (Errcode: 24) | |||||||||||||||||||||||||||
