Notice: Undefined index: year_filter in /home/html/chess.sk/public_html/include/listina_talentov_export.php on line 21

Notice: Undefined index: year_filter in /home/html/chess.sk/public_html/include/listina_talentov_export.php on line 31

Notice: Undefined index: year_filter in /home/html/chess.sk/public_html/include/listina_talentov_export.php on line 42

Notice: Undefined index: year_filter in /home/html/chess.sk/public_html/include/listina_talentov_export.php on line 45

Notice: Undefined index: year_filter in /home/html/chess.sk/public_html/include/listina_talentov_export.php on line 54
Query Error at www.chess.sk Error occured while executing query on 11-07-2020-22-36-10. Debuging info: _____________________________________________________ FILE: /home/html/chess.sk/public_html/include/listina_talentov_export.php line 203 _____________________________________________________ ERROR: 1064 : 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 'INNER JOIN mtkPlayers ON listina_talentov_vysledky.fide_id ' at line 12 _____________________________________________________ SQL QUERY: SELECT '' as year_app, Surname, x.Name, x.titulOsobny, x.Birthday, x.Nationality, x.BankAccountStateBudget, x.BankAccountSponsor, x.PlayerId , GROUP_CONCAT(DISTINCT mtkKluby.klubName ORDER BY mtkKluby.uzemnyCelok DESC, mtkKluby.klubId ASC ) as klubName , 'členský vzťah' as vztah FROM ( ( SELECT mtkPlayers.PlayerId, mtkPlayers.Surname, mtkPlayers.Name, mtkPlayers.titulOsobny, mtkPlayers.Birthday, mtkPlayers.Nationality , mtkPlayers.BankAccountStateBudget, mtkPlayers.BankAccountSponsor FROM listina_talentov_vysledky INNER JOIN listina_talentov_turnaje ON listina_talentov_vysledky.listina_talentov_turnaje_id = listina_talentov_turnaje.id AND listina_talentov_turnaje.year_app = INNER JOIN mtkPlayers ON listina_talentov_vysledky.fide_id = mtkPlayers.FideId OR listina_talentov_vysledky.lok_id = mtkPlayers.PlayerId WHERE listina_talentov_vysledky.perc > 60 ) UNION ALL ( SELECT mtkPlayers.PlayerId, mtkPlayers.Surname, mtkPlayers.Name, mtkPlayers.titulOsobny, mtkPlayers.Birthday, mtkPlayers.Nationality , mtkPlayers.BankAccountStateBudget, mtkPlayers.BankAccountSponsor FROM mtkPlayers INNER JOIN mtkFideRatings ON mtkPlayers.FideId = mtkFideRatings.FideId AND mtkFideRatings.StartDatePeriod = '-01-01' AND mtkFideRatings.Type = 's' WHERE ((mtkFideRatings.Rating > 2300) OR (mtkPlayers.Sex = 'F' AND mtkFideRatings.Rating > 2100)) AND mtkPlayers.Birthday >= '-23-01-01' AND mtkPlayers.status != 'x' ) UNION ALL ( SELECT mtkPlayers.PlayerId, mtkPlayers.Surname, mtkPlayers.Name, mtkPlayers.titulOsobny, mtkPlayers.Birthday, mtkPlayers.Nationality , mtkPlayers.BankAccountStateBudget, mtkPlayers.BankAccountSponsor FROM listina_talentov_divoka_karta INNER JOIN mtkPlayers ON listina_talentov_divoka_karta.player_id = mtkPlayers.PlayerId AND mtkPlayers.status != 'x' WHERE listina_talentov_divoka_karta.year_app = ) ) as x LEFT JOIN mtkHracKlub ON mtkHracKlub.playerId = x.PlayerId AND datumOd <= '2020-01-01' AND ( datumDo IS NULL OR datumDo >= '2020-01-01' ) LEFT JOIN mtkKluby ON mtkKluby.klubId = mtkHracKlub.klubId WHERE x.Nationality = 'SK' GROUP BY year_app, x.Surname, x.Name, x.titulOsobny, x.Birthday, x.Nationality, x.BankAccountStateBudget, x.BankAccountSponsor ORDER BY klubName ASC, x.Surname ASC, x.Name ASC _____________________________________________________ QUERY_STRING: _____________________________________________________ REQUEST_METHOD: GET _____________________________________________________ REMOTE_ADDR: 3.236.8.46 _____________________________________________________ SERVER_NAME: www.chess.sk _____________________________________________________ HTTP_REFERER: _____________________________________________________ Don't be sad - keep smiling - this bug loves you :).
Warning: Invalid argument supplied for foreach() in /home/html/chess.sk/public_html/include/listina_talentov_export.php on line 89

Warning: Cannot modify header information - headers already sent by (output started at /home/html/chess.sk/public_html/db_access.php:236) in /home/html/chess.sk/public_html/include/listina_talentov_export.php on line 148

Warning: Cannot modify header information - headers already sent by (output started at /home/html/chess.sk/public_html/db_access.php:236) in /home/html/chess.sk/public_html/include/listina_talentov_export.php on line 151
ࡱ;   !"$%&'Oh+'0h X`$ H T` Zoznam talentovanej mládeže Zoznam talentovanej mládežeSlovenský šachový zväz Zoznam talentovanej mládeže Zoznam talentovanej mládežeSlovenský šachový zväz@W@W  B=%r8X"1Calibri                83ffff̙̙3f3fff3f3f33333f33333>Zoznam talentovanej mlde~egP priezviskomenotitulSSZ Iddtum narodeniaattna prsluanose slo bankovho tu slo sponzorskho tu prvny titul$prsluanose k aportovm organizcim  *+&ffffff?'ffffff?(?)?"dXX333333?333333?U} $ } $ } $ } $ } $ } $ } $ } $ } $ } $            >@ddgg ՜.+,0 PX   Zoznam talentovanej mládeže  Worksheet Feuilles de calculRoot Entry FWW SummaryInformation( FWorkbook FDocumentSummaryInformation8 F#