QUERY 96: (SELECT `players`.*, count(distinct `texttranslations`.`id_texttranslation`) as `yellow_rp`, 0 as `yellow_off`, `matchezs`.`id_matchez`, `teams`.`team`, `teams`.`id_team` FROM `players`, `tours`, `matchezs`, `teams`, `teamplayerlinkers`, `texttranslations` LEFT JOIN `playermatchlinkers` ON `playermatchlinkers`.`id_player` = `texttranslations`.`id_player` WHERE `texttranslations`.`id_player`=`players`.`id_player` AND `teamplayerlinkers`.`id_team` = `teams`.`id_team` AND `teamplayerlinkers`.`id_player` = `players`.`id_player` AND `teamplayerlinkers`.`igrok` = 1 AND `matchezs`.`id_matchez` = `texttranslations`.`id_matchez` AND `tours`.`id_tour` = `matchezs`.`id_tour` AND `tours`.`playoff` = 0 AND `tours`.`id_league`= 258 AND `texttranslations`.`id_event` IN (9, 10) AND `playermatchlinkers`.`id_team` = `teams`.`id_team` AND `playermatchlinkers`.`id_matchez` = `matchezs`.`id_matchez` GROUP BY `players`.`id_player` ORDER BY `yellow` desc, `players`.`player`) UNION (SELECT `players`.*, 0 as `yellow`, count(distinct `texttranslations`.`id_texttranslation`) as `yellow_off`, `matchezs`.`id_matchez`, `teams`.`team`, `teams`.`id_team` FROM `players`, `tours`, `matchezs`, `teams`, `teamplayerlinkers`, `texttranslations` LEFT JOIN `playermatchlinkers` ON `playermatchlinkers`.`id_player` = `texttranslations`.`id_player` WHERE `texttranslations`.`id_player`=`players`.`id_player` AND `teamplayerlinkers`.`id_team` = `teams`.`id_team` AND `teamplayerlinkers`.`id_player` = `players`.`id_player` AND `teamplayerlinkers`.`igrok` = 1 AND `matchezs`.`id_matchez` = `texttranslations`.`id_matchez` AND `tours`.`id_tour` = `matchezs`.`id_tour` AND `tours`.`playoff` = 1 AND `tours`.`id_league`= 258 AND `texttranslations`.`id_event` IN (9, 10) AND `playermatchlinkers`.`id_team` = `teams`.`id_team` AND `playermatchlinkers`.`id_matchez` = `matchezs`.`id_matchez` GROUP BY `players`.`id_player` ORDER BY `yellow` desc, `players`.`player`)
RESULT:Unknown column 'yellow' in 'order clause'
Желтые карточки | Первенство СПб 2012 | Детско-юношеское Первенство Санкт-Петербурга по мини-футболу. 2022-2023 | Лига Чайников
Детско-юношеское Первенство Санкт-Петербурга по мини-футболу. 2022-2023 (ноябрь 2022 — апрель 2023)

Статистика

Детско-юношеское Первенство Санкт-Петербурга по мини-футболу. 2022-2023
Первенство СПб 2012

Данные отсутствуют.
"РП" — регулярное первенство