Игровые сервера: Counter-Strike Condition Zero

Не удалось выполнить запрос 'SELECT server_game,server_port,server_vip,server_id,server_name,server_players,server_maxplayers,server_map,server_ip,votes,server_color,game_mod,server_location,(SELECT `name` FROM `amx_game_mod` WHERE `type`=`game_mod`) AS mod_name,(select count(*) from `amx_favorit` WHERE `user_id`='0' AND `fav_server_id`=`server_id`) AS fav_prov FROM amx_servers where server_new = 0 and server_game='cszero' and server_name != '' and server_status != 0 and server_off != 1 order by server_vip desc, votes desc limit 0, 80'
Ответ с сервера: Subquery returns more than 1 row