Error: 0
Message: PDO Error: SQLSTATE[42000]: Syntax error or access violation: 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 '. 0000-00-00. '' AND sortable_date != '1970-01-01' ORDER BY sortable_date ASC L' at line 25 Query: SELECT mi.*,
c.default_kit home_default_kit,
c.alt_kit home_alt_kit,
CONCAT( "/", m.filePathInternal, "/", m.fileName, ".", m.fileExtension ) home_current_logo,
CONCAT( "/", m3.filePathInternal, "/", m3.fileName, ".", m3.fileExtension ) home_logo,
c2.default_kit away_default_kit,
c2.alt_kit away_alt_kit,
CONCAT( "/", m2.filePathInternal, "/", m2.fileName, ".", m2.fileExtension ) away_current_logo,
CONCAT( "/", m4.filePathInternal, "/", m4.fileName, ".", m4.fileExtension ) away_logo,
cd.clubName home_current_name,
cd2.clubName away_current_name,
cd.club_short_name home_current_short_name,
cd2.club_short_name away_current_short_name,
cnd.name home_name,
cnd2.name away_name,
cnd.short_name home_short_name,
cnd2.short_name away_short_name,
sd.stadiumName stadium_current_name,
sd.cityName stadium_current_city,
snd.name stadium_name,
snd.city stadium_city,
td.name tournament_name,
td.url tournament_url,
CASE WHEN match_date_delayed = "0000-00-00 00:00:00" THEN match_date ELSE match_date_delayed END AS sortable_date
FROM match_info mi left JOIN club c ON mi.home_club_id = c.id left JOIN club_description cd ON mi.home_club_id = cd.clubId AND cd.languageId = 2 left JOIN club_name cn ON c.id = cn.club_id AND IF( mi.match_date_delayed = "0000-00-00 00:00:00", mi.match_date, mi.match_date_delayed) BETWEEN cn.date_from AND cn.date_to left JOIN club_name_description cnd ON cn.id = cnd.club_name_id AND cnd.language_id = 2 left JOIN media m ON m.id = c.logoId left JOIN media m3 ON m3.id = cn.logo_id left JOIN club c2 ON mi.away_club_id = c2.id left JOIN club_description cd2 ON mi.away_club_id = cd2.clubId AND cd2.languageId = 2 left JOIN club_name cn2 ON c2.id = cn2.club_id AND IF( mi.match_date_delayed = "0000-00-00 00:00:00", mi.match_date, mi.match_date_delayed) BETWEEN cn2.date_from AND cn2.date_to left JOIN club_name_description cnd2 ON cn2.id = cnd2.club_name_id AND cnd2.language_id = 2 left JOIN media m2 ON m2.id = c2.logoId left JOIN media m4 ON m4.id = cn2.logo_id left JOIN tournament t ON mi.tournament_id = t.id left JOIN tournament_description td ON mi.tournament_id = td.tournament AND td.language = 2 left JOIN stadium s ON mi.stadium_id = s.id left JOIN stadium_description sd ON mi.stadium_id = sd.stadiumId AND sd.languageId = 2 left JOIN stadium_name sn ON s.id = sn.stadium_id AND IF( mi.match_date_delayed = "0000-00-00 00:00:00", mi.match_date, mi.match_date_delayed) BETWEEN sn.date_from AND sn.date_to left JOIN stadium_name_description snd ON sn.id = snd.stadium_name_id AND snd.language_id = 2 WHERE ( ( mi.home_club_id IN (' . $this->CSKA_CLUB_IDS . ') AND end_score_home_goals > end_score_away_goals) OR ( mi.away_club_id IN (' . $this->CSKA_CLUB_IDS . ') AND end_score_home_goals < end_score_away_goals ) ) HAVING DAY( sortable_date ) = DAY( NOW() ) AND MONTH( sortable_date ) = MONTH( NOW() ) AND sortable_date !='' . 0000-00-00. '' AND sortable_date != '1970-01-01' ORDER BY sortable_date ASC LIMIT 20
File: /var/www/html/cska/tinymvc/sysfiles/plugins/tinymvc_pdo.php
Line: 550
Trace: #0 /var/www/html/cska/tinymvc/sysfiles/plugins/tinymvc_pdo.php(493): TinyMVC_PDO->_query('SELECT mi.*,\r\n\t...', Array, 2, NULL)
#1 /var/www/html/cska/tinymvc/myapp/models/match_model.php(1236): TinyMVC_PDO->query_all()
#2 /var/www/html/cska/tinymvc/myapp/controllers/base_controller.php(64): Match_Model->get_sameday_wins(20)
#3 /var/www/html/cska/tinymvc/myapp/controllers/match_controller.php(23): Base_Controller->__construct()
#4 /var/www/html/cska/tinymvc/myapp/controllers/root.php(167): Match_Controller->__construct()
#5 /var/www/html/cska/tinymvc/sysfiles/TinyMVC.php(120): Root_Controller->index()
#6 /var/www/html/cska/htdocs/index.php(81): tmvc->main()
#7 {main}