Ошибка MySQL!
========================

MySQL вернул ошибку:
Unknown column 'level' in 'field list'

Номер ошибки:
1054

SELECT clan_data.clan_name, clan_data.clan_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, characters.char_name, ccount FROM `clan_data` LEFT JOIN `characters` ON characters.charId = clan_data.leader_id LEFT JOIN ( SELECT clanid, count(level) AS ccount FROM characters WHERE clanid GROUP BY clanid ) AS levels ON clan_data.clan_id = levels.clanid ORDER BY clan_data.clan_level DESC, clan_data.reputation_score DESC LIMIT 10