DB Error: mySQL Error on Query : SELECT mat.id AS mat_id, mat.home_id, mat.away_id, mat.FT_h, mat.FT_a, mat.status, mat.status_type, DAY(mat.start_time) as sday, DATE_FORMAT(mat.start_time, "%Y-%m-%d") AS mat_date, DATE_FORMAT(mat.start_time, "%d.%m.%Y") AS startdate, DATE_FORMAT(mat.start_time, "%H:%i") AS starttime, MIN(IF( map.p_order = 1, par.par_name, NULL)) AS home_team, MIN(IF( map.p_order = 1, parl.logo_url, NULL)) AS home_logo_url, MIN(IF( map.p_order = 1, par.par_seo_name, NULL)) AS home_seo, MIN(IF(map.p_order = 1, mat.cur_h, NULL)) AS home_ft_score, MIN(IF(map.p_order = 2, mat.cur_a, NULL)) AS away_ft_score, MIN(IF(map.p_order = 1, mat.part_1_h, NULL)) AS part_1_h, MIN(IF(map.p_order = 2, mat.part_1_a, NULL)) AS part_1_a, MIN(IF(map.p_order = 1, mat.part_2_h, NULL)) AS part_2_h, MIN(IF(map.p_order = 2, mat.part_2_a, NULL)) AS part_2_a, MIN(IF(map.p_order = 1, mat.part_3_h, NULL)) AS part_3_h, MIN(IF(map.p_order = 2, mat.part_3_a, NULL)) AS part_3_a, MIN(IF( map.p_order = 1, mat.ot_h, NULL)) AS home_ot_score, MIN(IF( map.p_order = 2, mat.ot_a, NULL)) AS away_ot_score, MIN(IF( map.p_order = 1, mat.pen_h, NULL)) AS home_pen_score, MIN(IF( map.p_order = 2, mat.pen_a, NULL)) AS away_pen_score, MIN(IF( mat.ot_h+mat.ot_a, 1, NULL)) AS ot, MIN(IF( mat.pen_h+mat.pen_a, 1, NULL)) AS pen, MIN(IF( map.p_order = 2, par.par_name, NULL)) AS away_team, MIN(IF( map.p_order = 2, parl.logo_url, NULL)) AS away_logo_url, MIN(IF( map.p_order = 2, par.par_seo_name, NULL)) AS away_seo, cor.cor_name AS round, cor.cor_seo_name AS round_seo, cos.cos_name AS season, cos.cos_seo_name AS season_seo, col.col_name AS league, col.col_seo_name AS league_seo, com.com_name AS competition, com.com_seo_name AS competition_seo FROM picks_score_new.matches AS mat INNER JOIN picks_score_new.matches_participants AS map ON map.mat_id = mat.id INNER JOIN picks_score_new.participants AS par ON par.id = map_id INNER JOIN picks_score_new.participants_logos AS parl ON parl.par_id = par.id INNER JOIN picks_score_new.competitions_rounds AS cor ON cor.id = mat.cor_id INNER JOIN picks_score_new.competitions_seasons AS cos ON cos.id = cor.cos_id INNER JOIN picks_score_new.competitions_leagues AS col ON col.id = cos.col_id INNER JOIN picks_score_new.competitions AS com ON com.id = col.com_id INNER JOIN picks_score_new.sports AS spo ON spo.id = com.spo_id WHERE par.lng_id=2 AND spo.lng_id=2 AND com.lng_id=2 AND col.lng_id=2 AND cos.lng_id=2 AND cor.lng_id=2 AND YEAR(mat.start_time) = 2019 AND MONTH(mat.start_time) = 02 AND spo.id=10 AND com.id=83 AND col.id=20 GROUP BY cos.id,mat.cor_id,mat.id ORDER BY col.col_name, mat.cor_id DESC,mat.start_time DESC, mat.id LIMIT 800
More Information:
  • Mysql Error : 1146
  • Mysql Error no # : Table 'picks_score_new.competitions_rounds' doesn't exist
  • Date : February 21, 2019, 12:33 am
  • Referer:
  • Script: /nemecko/del/live/