#8 Martin Kosík
Sezóna 2024/25
Podrobné statistikyKariéra
Sezón
Čistých kont
PR
Zápasy
Statistika
Rozpad podle soupeřů
Soupeř | Z | V | P | R | Score |
---|
Error in SELECT distinct soutez.soutezid FROM `soutez` LEFT JOIN souteznirocnik ON soutez.aktivnisouteznirocnikid = souteznirocnik.souteznirocnikid LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE soutez.aktivni = 1 AND soutez.soutezid != 1 AND souteznirocnik.zacatek < NOW() AND souteznirocnik.konec > NOW() AND soupiska.hracid IN (757,)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
Error in SELECT distinct soupiska.post FROM `soupiska` WHERE soupiska.hracid IN ( 757,)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '1999-08-01 00:00:00' <= souteznirocnik.zacatek AND '2000-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2000-08-01 00:00:00' <= souteznirocnik.zacatek AND '2001-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2001-08-01 00:00:00' <= souteznirocnik.zacatek AND '2002-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2002-08-01 00:00:00' <= souteznirocnik.zacatek AND '2003-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2003-08-01 00:00:00' <= souteznirocnik.zacatek AND '2004-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2004-08-01 00:00:00' <= souteznirocnik.zacatek AND '2005-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2005-08-01 00:00:00' <= souteznirocnik.zacatek AND '2006-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2006-08-01 00:00:00' <= souteznirocnik.zacatek AND '2007-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2007-08-01 00:00:00' <= souteznirocnik.zacatek AND '2008-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2008-08-01 00:00:00' <= souteznirocnik.zacatek AND '2009-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2009-08-01 00:00:00' <= souteznirocnik.zacatek AND '2010-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2010-08-01 00:00:00' <= souteznirocnik.zacatek AND '2011-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2011-08-01 00:00:00' <= souteznirocnik.zacatek AND '2012-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2012-08-01 00:00:00' <= souteznirocnik.zacatek AND '2013-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2013-08-01 00:00:00' <= souteznirocnik.zacatek AND '2014-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2014-08-01 00:00:00' <= souteznirocnik.zacatek AND '2015-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2015-08-01 00:00:00' <= souteznirocnik.zacatek AND '2016-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2016-08-01 00:00:00' <= souteznirocnik.zacatek AND '2017-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2017-08-01 00:00:00' <= souteznirocnik.zacatek AND '2018-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2018-08-01 00:00:00' <= souteznirocnik.zacatek AND '2019-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2019-08-01 00:00:00' <= souteznirocnik.zacatek AND '2020-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2020-08-01 00:00:00' <= souteznirocnik.zacatek AND '2021-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2021-08-01 00:00:00' <= souteznirocnik.zacatek AND '2022-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2022-08-01 00:00:00' <= souteznirocnik.zacatek AND '2023-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2023-08-01 00:00:00' <= souteznirocnik.zacatek AND '2024-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT souteznirocnik.* FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2024-08-01 00:00:00' <= souteznirocnik.zacatek AND '2025-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1)' at line 1
Error in SELECT DISTINCT u.udelenacenaid, u.udeleno, u.cenaid FROM (( SELECT udelenacena.udelenacenaid, udelenacena.udeleno, udelenacena.cenaid FROM cena LEFT JOIN udelenacena ON cena.cenaid = udelenacena.cenaid LEFT JOIN soupiska ON udelenacena.soupiskaid = soupiska.soupiskaid WHERE cena.komu = 'hraci' AND cena.rozsah = 'soutez' AND soupiska.hracid IN (757,)) UNION ALL ( SELECT udelenacena.udelenacenaid, udelenacena.udeleno, udelenacena.cenaid FROM cena LEFT JOIN udelenacena ON cena.cenaid = udelenacena.cenaid WHERE cena.komu = 'hraci' AND cena.rozsah = 'ahl' AND udelenacena.hracid IN (757,)) UNION ALL ( SELECT udelenacena.udelenacenaid, udelenacena.udeleno, udelenacena.cenaid FROM cena LEFT JOIN udelenacena ON cena.cenaid = udelenacena.cenaid LEFT JOIN ucastniksouteznihorocniku ON udelenacena.ucastniksouteznihorocnikuid = ucastniksouteznihorocniku.ucastniksouteznihorocnikuid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE cena.komu = 'klubu' AND cena.rozsah = 'soutez' AND soupiska.hracid IN (757,))) u LEFT JOIN cena ON u.cenaid = cena.cenaid WHERE u.udelenacenaid IS NOT NULL ORDER BY cena.poradi, u.udeleno DESC
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) UNION ALL ( SELECT udelenacena.udelenacenaid, udelenacena.udeleno, udelena...' at line 1
Error in SELECT z.* FROM ( ( select zapas.zapasid, zapas.termin from zapas LEFT JOIN soupiska AS dom ON zapas.ucastniksouteznihorocnikuid_domaci = dom.ucastniksouteznihorocnikuid WHERE zapas.stav = "neodehrano" AND dom.hracid IN (757,) ) UNION ALL ( select zapas.zapasid, zapas.termin from zapas LEFT JOIN soupiska AS hos ON zapas.ucastniksouteznihorocnikuid_hoste = hos.ucastniksouteznihorocnikuid WHERE zapas.stav = "neodehrano" AND hos.hracid IN (757,) ) ) z WHERE z.termin > NOW() ORDER BY z.termin LIMIT 1
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ) UNION ALL ( select zapas.zapasid, zapas.termin from zapas LEFT JOIN sou...' at line 1
Error in SELECT zapas.zapasid FROM `soupiska` LEFT JOIN soupiskazapasmap ON soupiska.soupiskaid = soupiskazapasmap.soupiskaid LEFT JOIN zapas ON soupiskazapasmap.zapasid = zapas.zapasid LEFT JOIN souteznirocnik ON zapas.souteznirocnikid = souteznirocnik.souteznirocnikid WHERE soupiska.hracid IN (757,) AND soupiska.soupiskaid IS NOT NULL AND soupiskazapasmap.soupiskaid IS NOT NULL AND zapas.zapasid IS NOT NULL ORDER BY zapas.termin DESC LIMIT 1
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND soupiska.soupiskaid IS NOT NULL AND soupiskazapasmap.soupiskaid IS NO...' at line 1
Error in SELECT distinct soutez.soutezid FROM `soutez` LEFT JOIN souteznirocnik ON soutez.soutezid = souteznirocnik.soutezid LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE soupiska.hracid IN (757,)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
Error in SELECT distinct soupiska.post FROM `soupiska` WHERE soupiska.hracid IN ( 757,)
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '1999-08-01 00:00:00' <= souteznirocnik.zacatek AND '2000-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2000-08-01 00:00:00' <= souteznirocnik.zacatek AND '2001-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2001-08-01 00:00:00' <= souteznirocnik.zacatek AND '2002-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2002-08-01 00:00:00' <= souteznirocnik.zacatek AND '2003-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2003-08-01 00:00:00' <= souteznirocnik.zacatek AND '2004-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2004-08-01 00:00:00' <= souteznirocnik.zacatek AND '2005-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2005-08-01 00:00:00' <= souteznirocnik.zacatek AND '2006-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2006-08-01 00:00:00' <= souteznirocnik.zacatek AND '2007-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2007-08-01 00:00:00' <= souteznirocnik.zacatek AND '2008-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2008-08-01 00:00:00' <= souteznirocnik.zacatek AND '2009-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2009-08-01 00:00:00' <= souteznirocnik.zacatek AND '2010-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2010-08-01 00:00:00' <= souteznirocnik.zacatek AND '2011-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2011-08-01 00:00:00' <= souteznirocnik.zacatek AND '2012-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2012-08-01 00:00:00' <= souteznirocnik.zacatek AND '2013-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2013-08-01 00:00:00' <= souteznirocnik.zacatek AND '2014-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2014-08-01 00:00:00' <= souteznirocnik.zacatek AND '2015-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2015-08-01 00:00:00' <= souteznirocnik.zacatek AND '2016-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2016-08-01 00:00:00' <= souteznirocnik.zacatek AND '2017-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2017-08-01 00:00:00' <= souteznirocnik.zacatek AND '2018-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2018-08-01 00:00:00' <= souteznirocnik.zacatek AND '2019-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2019-08-01 00:00:00' <= souteznirocnik.zacatek AND '2020-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2020-08-01 00:00:00' <= souteznirocnik.zacatek AND '2021-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2021-08-01 00:00:00' <= souteznirocnik.zacatek AND '2022-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2022-08-01 00:00:00' <= souteznirocnik.zacatek AND '2023-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2023-08-01 00:00:00' <= souteznirocnik.zacatek AND '2024-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souteznirocnik.*, YEAR(souteznirocnik.zacatek) AS rok FROM souteznirocnik LEFT JOIN ucastniksouteznihorocniku ON souteznirocnik.souteznirocnikid = ucastniksouteznihorocniku.souteznirocnikid LEFT JOIN soupiska ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid LEFT JOIN soutez ON ucastniksouteznihorocniku.ucastniksouteznihorocnikuid = soupiska.ucastniksouteznihorocnikuid WHERE souteznirocnik.souteznirocnikid != 1 AND '2024-08-01 00:00:00' <= souteznirocnik.zacatek AND '2025-08-01 00:00:00' > souteznirocnik.zacatek AND soupiska.hracid IN (757,,-1) ORDER BY souteznirocnik.zacatek
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1) ORDER BY souteznirocnik.zacatek' at line 1
Error in SELECT souper.klubid as klubId, souper.nazev as klubNazev, sum(souper.pocet) as souper_zapasy,
(SELECT count(*) FROM soupiska s1
LEFT JOIN soupiskazapasmap szm1 ON s1.soupiskaid = szm1.soupiskaid
LEFT JOIN zapas z1 ON szm1.zapasid = z1.zapasid
LEFT JOIN ucastniksouteznihorocniku usr1 ON z1.ucastniksouteznihorocnikuid_hoste = usr1.ucastniksouteznihorocnikuid
LEFT JOIN klub k1 ON usr1.klubid = k1.klubid
WHERE
s1.hracid IN (757,)
AND k1.klubid = souper.klubid
AND s1. ucastniksouteznihorocnikuid = z1.ucastniksouteznihorocnikuid_domaci
AND z1.scoredomaci > z1.scorehoste)
+
(SELECT count(*) FROM soupiska s1
LEFT JOIN soupiskazapasmap szm1 ON s1.soupiskaid = szm1.soupiskaid
LEFT JOIN zapas z1 ON szm1.zapasid = z1.zapasid
LEFT JOIN ucastniksouteznihorocniku usr1 ON z1.ucastniksouteznihorocnikuid_domaci = usr1.ucastniksouteznihorocnikuid
LEFT JOIN klub k1 ON usr1.klubid = k1.klubid
WHERE
s1.hracid IN (757,)
AND s1. ucastniksouteznihorocnikuid = z1.ucastniksouteznihorocnikuid_hoste
AND k1.klubid = souper.klubid
AND z1.scoredomaci < z1.scorehoste)
AS vyhry,
(SELECT count(*) FROM soupiska s1
LEFT JOIN soupiskazapasmap szm1 ON s1.soupiskaid = szm1.soupiskaid
LEFT JOIN zapas z1 ON szm1.zapasid = z1.zapasid
LEFT JOIN ucastniksouteznihorocniku usr1 ON z1.ucastniksouteznihorocnikuid_hoste = usr1.ucastniksouteznihorocnikuid
LEFT JOIN klub k1 ON usr1.klubid = k1.klubid
WHERE
s1.hracid IN (757,)
AND k1.klubid = souper.klubid
AND s1. ucastniksouteznihorocnikuid = z1.ucastniksouteznihorocnikuid_domaci
AND z1.scoredomaci < z1.scorehoste)
+
(SELECT count(*) FROM soupiska s1
LEFT JOIN soupiskazapasmap szm1 ON s1.soupiskaid = szm1.soupiskaid
LEFT JOIN zapas z1 ON szm1.zapasid = z1.zapasid
LEFT JOIN ucastniksouteznihorocniku usr1 ON z1.ucastniksouteznihorocnikuid_domaci = usr1.ucastniksouteznihorocnikuid
LEFT JOIN klub k1 ON usr1.klubid = k1.klubid
WHERE
s1.hracid IN (757,)
AND s1. ucastniksouteznihorocnikuid = z1.ucastniksouteznihorocnikuid_hoste
AND k1.klubid = souper.klubid
AND z1.scoredomaci > z1.scorehoste)
AS prohry,
(SELECT count(*) FROM soupiska s1
LEFT JOIN soupiskazapasmap szm1 ON s1.soupiskaid = szm1.soupiskaid
LEFT JOIN zapas z1 ON szm1.zapasid = z1.zapasid
LEFT JOIN ucastniksouteznihorocniku usr1 ON z1.ucastniksouteznihorocnikuid_hoste = usr1.ucastniksouteznihorocnikuid
LEFT JOIN klub k1 ON usr1.klubid = k1.klubid
WHERE
s1.hracid IN (757,)
AND k1.klubid = souper.klubid
AND s1. ucastniksouteznihorocnikuid = z1.ucastniksouteznihorocnikuid_domaci
AND z1.scoredomaci = z1.scorehoste)
+
(SELECT count(*) FROM soupiska s1
LEFT JOIN soupiskazapasmap szm1 ON s1.soupiskaid = szm1.soupiskaid
LEFT JOIN zapas z1 ON szm1.zapasid = z1.zapasid
LEFT JOIN ucastniksouteznihorocniku usr1 ON z1.ucastniksouteznihorocnikuid_domaci = usr1.ucastniksouteznihorocnikuid
LEFT JOIN klub k1 ON usr1.klubid = k1.klubid
WHERE
s1.hracid IN (757,)
AND s1. ucastniksouteznihorocnikuid = z1.ucastniksouteznihorocnikuid_hoste
AND k1.klubid = souper.klubid
AND z1.scoredomaci = z1.scorehoste)
AS remizy
FROM
(SELECT klub.nazev, klub.klubid, count(klub.klubid) AS pocet
FROM `soupiska`
LEFT JOIN soupiskazapasmap ON soupiska.soupiskaid = soupiskazapasmap.soupiskaid
LEFT JOIN zapas ON soupiskazapasmap.zapasid = zapas.zapasid
LEFT JOIN ucastniksouteznihorocniku ON zapas.ucastniksouteznihorocnikuid_hoste = ucastniksouteznihorocniku.ucastniksouteznihorocnikuid
LEFT JOIN klub ON ucastniksouteznihorocniku.klubid = klub.klubid
WHERE
soupiska.ucastniksouteznihorocnikuid = zapas.ucastniksouteznihorocnikuid_domaci
AND soupiska.hracid IN (757,)
GROUP BY klub.klubid
UNION ALL
SELECT klub.nazev, klub.klubid, count(klub.klubid) AS pocet
FROM `soupiska`
LEFT JOIN soupiskazapasmap ON soupiska.soupiskaid = soupiskazapasmap.soupiskaid
LEFT JOIN zapas ON soupiskazapasmap.zapasid = zapas.zapasid
LEFT JOIN ucastniksouteznihorocniku ON zapas.ucastniksouteznihorocnikuid_domaci = ucastniksouteznihorocniku.ucastniksouteznihorocnikuid
LEFT JOIN klub ON ucastniksouteznihorocniku.klubid = klub.klubid
WHERE
soupiska.ucastniksouteznihorocnikuid = zapas.ucastniksouteznihorocnikuid_hoste
AND soupiska.hracid IN (757,)
GROUP BY klub.klubid
) souper
GROUP BY klubid
ORDER BY souper_zapasy desc, vyhry desc, remizy desc
DB Message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND k1.klubid = souper.klubid
AND s1. ucastniksouteznihorocnikuid =...' at line 8
Soupeř | Z | V | P | R | Score |
---|