 |
|
|
|
select sum(ifnull(pmat.attitude, 0)) / count(pmatt.type) as att from player_manager_attitude_types pmatt left join players pl on pl.id = '3254' left join managers mn on mn.id = '0' left join managers mn1 on mn.first_name = mn1.name left join player_manager_attitude pmat on pmat.player = '3254' and pmat.type = pmatt.type and pmat.managerid = ifnull(mn1.id, ifnull(mn.id, 0)) error: Out of resources when opening file './fb/managers.MYD' (Errcode: 24) | |||||||||||||||||||||||||||