Error Number: 23
MySQL error in file: /engine/modules/schedules.php at line 271
The Error returned was:
Out of resources when opening file './ab_db/ab_teams.MYD' (Errcode: 24)
SQL query:
SELECT
AG.*,
AGT.`name` AS `type_name`,
COALESCE(AGS.`name_ru`, AG.`status`) AS `status_name`,
CONCAT(ATH.`city`, ' ', ATH.`name`) AS `home_team_full_name_alt`,
CONCAT(ATH.`city_ru`, ' ', ATH.`name_ru`) AS `home_team_full_name`,
CONCAT(ATV.`city`, ' ', ATV.`name`) AS `visitor_team_full_name_alt`,
CONCAT(ATV.`city_ru`, ' ', ATV.`name_ru`) AS `visitor_team_full_name`,
ATH.`alt_name` AS `home_team_alt_name`,
ATV.`alt_name` AS `visitor_team_alt_name`,
ATH.`abbreviation` AS `home_team_abbreviation`,
ATV.`abbreviation` AS `visitor_team_abbreviation`,
ATH.`type` AS `home_team_type`,
ATV.`type` AS `visitor_team_type`,
IF(AG.`type` = 3, (
SELECT COUNT(*)
FROM `ab_games`
WHERE ((`home_team_id` = AG.`home_team_id` AND `visitor_team_id` = AG.`visitor_team_id`) OR (`home_team_id` = AG.`visitor_team_id` AND `visitor_team_id` = AG.`home_team_id`))
AND `season` = AG.`season`
AND `date` <= AG.`date`
AND `type` = AG.`type`
), NULL) AS `playoff_round_game`
FROM `ab_games` AS AG
LEFT JOIN `ab_game_type` AS AGT ON AGT.`id` = AG.`type`
LEFT JOIN `ab_game_status` AS AGS ON AGS.`name` = AG.`status`
LEFT JOIN `ab_teams` AS ATH ON ATH.`id` = AG.`home_team_id`
LEFT JOIN `ab_teams` AS ATV ON ATV.`id` = AG.`visitor_team_id`
WHERE AG.`season` = '2024'
ORDER BY AG.`date` ASC, AG.`id` ASC
LIMIT 1443, 50