HokejLive.netSvet › Live

- Svet

mySQL WARNING!
DB Error: mySQL Error on Query : select matches.id as mat_id,p1.id as home_id,p2.id as away_id,matches.g_h as FT_h,matches.g_a as FT_a,matches.g_h as home_ft_score,matches.g_a as away_ft_score, status_live_lngs.seo_name as seo_status_live,status_lngs.seo_name as seo_status, matches.stal_id as status, matches.stall_id as status_type, DATE_FORMAT(matches.date_time,"%d-%m-%Y") as mat_date,DATE_FORMAT(matches.date_time,"%d.%m.%Y") AS startdate,DATE_FORMAT(matches.date_time,"%H:%i") AS starttime, s1.name as home_team,s1.seo_name as home_seo,matches.playoff,matches.ot,matches.ps as pen, if(mr1.home_score is null,'-',mr1.home_score) as part_1_h,if(mr1.away_score is null,'-',mr1.away_score) as part_1_a, if(mr2.home_score is null,'-',mr2.home_score) as part_2_h,if(mr2.away_score is null,'-',mr2.away_score) as part_2_a, if(mr3.home_score is null,'-',mr3.home_score) as part_3_h,if(mr3.away_score is null,'-',mr3.away_score) as part_3_a, if(mr4.home_score is null,'-',mr4.home_score) as part_4_h,if(mr4.away_score is null,'-',mr4.away_score) as part_4_a, if(mr5.home_score is null,'-',mr5.home_score) as part_5_h,if(mr5.away_score is null,'-',mr5.away_score) as part_5_a, s2.name as away_team,s2.seo_name as away_seo,matches.round, concat(seasons.year,'/',seasons.year+1) as season,concat(seasons.year,'-',seasons.year+1) as season_seo,seasons.id as cos_id, competitions_lngs.name as league,competitions_lngs.seo_name as league_seo,competitions_lngs.com_id as col_id, countries_lngs.name as competition,countries_lngs.seo_name as competition_seo,countries.name_en as cou_name_en,countries.id as cou_id from picks_score_new.matches join picks_score_new.participants as p1 on matches.home_id=p1.id join picks_score_new.participants as p2 on matches.away_id=p2.id left join picks_score_new.matches_infos on matches.id=matches_infos.mat_id left join picks_score_new.seasons_participants_lngs as s1 on matches.sea_id=s1.sea_id and s1.par_id=p1.id left join picks_score_new.seasons_participants_lngs as s2 on matches.sea_id=s2.sea_id and s2.par_id=p2.id left join picks_score_new.matches_results on matches.id=matches_results.mat_id left join picks_score_new.matches_participants_stats as m1 on matches.id=m1.mat_id and p1.id=m1.par_id left join picks_score_new.matches_participants_stats_val as m11 on m1.id=m11.matps_id left join picks_score_new.matches_participants_stats_val_lngs as m111 on m11.matpsvl_id=m111.id left join picks_score_new.matches_participants_stats as m2 on matches.id=m2.mat_id and p2.id=m2.par_id left join picks_score_new.matches_participants_stats_val as m21 on m2.id=m21.matps_id left join picks_score_new.matches_participants_stats_val_lngs as m211 on m21.matpsvl_id=m211.id join picks_score_new.seasons on matches.sea_id=seasons.id join picks_score_new.competitions on matches.com_id=competitions.id left join picks_score_new.competitions_lngs on competitions.id=competitions_lngs.com_id and matches.sea_id=competitions_lngs.sea_id left join picks_score_new.countries_lngs on competitions.cou_id_new=countries_lngs.cou_id join picks_score_new.countries on competitions.cou_id_new=countries.id left join picks_score_new.status_live_lngs on matches.stall_id=status_live_lngs.id left join picks_score_new.status_lngs on matches.stal_id=status_lngs.id left join picks_score_new.matches_results as mr1 on matches.id=mr1.mat_id and mr1.part=1 left join picks_score_new.matches_results as mr2 on matches.id=mr2.mat_id and mr2.part=2 left join picks_score_new.matches_results as mr3 on matches.id=mr3.mat_id and mr3.part=3 left join picks_score_new.matches_results as mr4 on matches.id=mr4.mat_id and mr4.part=4 left join picks_score_new.matches_results as mr5 on matches.id=mr5.mat_id and mr5.part=5 join picks_score_new.sports on seasons.spo_id=sports.id where if(s1.lng_id is null,true,s1.lng_id=2) AND if(s2.lng_id is null,true,s2.lng_id=2) AND if(m111.lng_id is null,true,m111.lng_id=2) AND if(m211.lng_id is null,true,m211.lng_id=2) AND if(competitions_lngs.lng_id is null,true,competitions_lngs.lng_id=2) AND if(countries_lngs.lng_id is null,true,countries_lngs.lng_id=2) AND if(status_live_lngs.lng_id is null,true,status_live_lngs.lng_id=2) AND if(status_lngs.lng_id is null,true,status_lngs.lng_id=2) AND matches.stal_id=1100 and matches.id in (66174664,66174665,66174666,66174668,68891701,82672343,98197975,102487144,102487145,104115633,104644765,104675096,104753358,104603790,104723613,82672597,104638457,66174667,74990831,74990832,104626387,66174669,66174670,68891702,74990833,82672476,87545635,87545636,87545637,87545638,87545639,87545640,98197974,103648585,104623436,104657000,104720108,104749867,104749874,104611753,104611755,66174671,104611752,104611754,104611756,104683702,104644764,104700032,104687548,104687546,66174672,68891703,104675097,104684664,104684665,104687547,104687549,104749873,104753359,100005886,101117395,104410185,66174673,66174674,74990834,104684399,104684402,66174675,104719822,104611758,104671798,104360595,104684400,104684405,104687551,104700033,100005887,104709861,104611757,104684398,104671793,104684397,104687550,104684401,104700037,104700038,104684404,104700034,104684403,104700030,104818183,104687559,104700035,104818185,104818187,104818189,104818188,103763455,104706685,104766063,104818186,104700036,104706415,104706416,104706417,104706692,104766059,104766060,104775663,104687555,104684406,104818184,104687556,104687552,104687554,104699966,104700062,104700064,104775667,104775671,104775673,104775675,104775676,104775679,104775690,104775932,104775934,104775935,104775938,104786008,104786009,104786010,104786015,104612044,104612046,104612048,104700175,104687553,104713195,104713196,104775933,104684411,104684413,104687557,104766056,104766058,104684407,104775661,104779281,104706436,104746425,104779284,104786223,104565566,104629178,104629181,104638467,104684408,104699619,104699620,104700013,104700016,104700017,104700020,104706407,104713497,104713505,104746424,104769336,104779273,104779283,104782629,104785982,104785983,104687560,104775664,104687558,104699981,104706418,103179965,103179966,103179967,103179968,103179969,104612049,104700174,104766061,104775672,104775688,104786012,104700069,104775689,104612045,104713199,104775674,104775677,104775686,104775936,104766057,104699982,104706686,82772303,82772304,82772305,82772306,82772308,82772309,104684409,104684410,104699972,104779282,104785985,80946532,80946533,80946534,80946535,80946536,80946537,80946538,80946539,80946540,80946541,80946542,80946543,82772307,104684412,104706412,104706435,104612043,104785998,104706408,104746427,104565568,104700063,104713197,104713501,104713504,104775680,104775681,104775662,104779280,104785990,104786011,104706688,104713200,103645278,104699975,104700158,104713198,104617529,104638460,104713201,104785984,104792822,104700014,104700057,104706406,104785996,104786013,104699621,104766062,104782632,104775660,104775670,104775666,104785992,104786014,83206221,83206222,104638462,104713194,104775668,104699983,104775937,104786224,104775669,104775683,104785987,104612052,104699964,104706434,104786017,104805263,104828891,104706414,104849657,104775678,104817832,104817835,104706687,104713499,104786021,104817834,104817836,104832229,104699614,104775687,104700058,104700077,104700078,104699613,104699963,104700075,104785986,104785995,104775684,104699615,104699990,104786003,104786016,79446799,104364021,104623265,104629175,104713511,104746635,104803733,104818458,104818460,104850267,104699958,104775685,104713498,104746637,104818459,62646749,62646750,75768137,104699959,104699961,104700055,104785991,104699977,104700019,104786020,104785989,104786018,104700044,104785988,64932123,75768136,79446798,79446802,103645279,103662871,103662889,103662890,103662891,103662892,103662893,103662894,104111636,104700061,104746414,104746418,104786005,104800277,104817833,104629176,104700043,104785661,104111633,104713503,104775682,104785993,104786022,104805264,104817837,104617534,104746636,104786006,104629177,104706437,104775665,104713500,104700041,104700059,104700161,104817838,79446801,101283766,104312448,104635485,104706445,104756640,104632112,104632115,101898229,104700024,104792494,75768135,79446800,101283764,101283767,104111648,104151421,104638461,104700023,104700056,104746426,104111634,104706447,104818463,104629182,104785994,104785999,104786019,104817839,73210026,75768134,100881192,101283768,102657439,103846904,103846908,104111635,104312446,104364016,104364017,104612124,104612125,104612127,104700082,104717171,104818462,104785660,104700060,104706449,104817844,104629179,104700029,100881190,101848978,101848979,101848980,103713921,104151485,104175175,104329952,104364037,104493966,104493967,104612116,104626412,104632110,104700006,104756635,104626378,104786023,104626379,104632111,104805261,100881191,104626380,104626381,104700026,104700081,104544844,68599045,68599047,74085801,74230379,75096188,75096191,77491794,79367094,100881193,100881194,102603976,103045722,103396635,103396636,103645280,104082663,104111612,104111614,104312447,104312454,104364019,104551862,104612126,104612128,104626345,104626382,104635486,104706444,104717121,104717122,104717123,104717124,104726791,104750085,104759956,104789072,104817841,104817842,104818181,104849931,104725753,104849932,68036178,68939399,100881195,103396637,103713890,104479790,104612129,104825517,101898185,103476109,68036210,68803473,75913249,75913251,76225457,76225458,76225459,76225460,76225461,76225462,76437537,78704274,79367087,103235442,103713891,104082653,104082654,104090140,104111646,104175179,104476260,104617691,104626350,104626351,104626389,104717170,104717172,104825518,104638455,104736467,104749876,104789907,104820931,104792490,75096015,75913522,76437728,89971758,99844134,101185244,103274443,103875786,103875787,104115640,104612093,104684697,104684698,104684699,104700209,100776773,66687671,68482706,75096011,75096012,75096016,77860844,77890078,78262415,78704233,78704245,102378867,103738545,103839695,104111611,104111650,104115641,104479791,104626347,104626348,104626409,104632116,104713509,104717173,104805531,104825519,104825520,104855367,104082655,104476259,104817848,104367479,104626390,104626392,104814416,104825521,68599043,68803465,69204610,69930506,75096013,75096014,76437729,76437730,76437731,76437732,76437733,76789329,101592539,103045721,103713914,103839696,104237963,104687837,104687838,104700210,104700211,104700212,104820929,104817845,103476110,104876932,67740893,101898186,103645281,104805806,104852026,104638453,104804912,104629180,104804915,104852027,104817843,100282021,98197971,99436627,103235259,104644762,104823303,104840293,100403118,104817847,104638454,100403117,100403119,100403121,104623437,104632117,104785407,104638456,104818461,101824976,102487146,104237978,104451802,104451804,104451805,104451806,104775657,102487147,103730203,104136519,104237979,66174676,68891704,68891705,68891706,68891707,74990835,74990836,74990837,102487148,103747047,104237980,104237981,104312462,104675098,104738657,104753360,104842902,104847575,104638452,99436619,104644758,104820933,66174677,74990838,74990839,74990840,104136516,104638459,68891708,68891709,74990841,74990842,74990843,74990844,82672423,104623438,104749875,104840294,104840295,100273917,100403122,101404921,101404922,101404923,101404924,101404925,101404926,101404927,101404928,101824980,68891710,74990845,82672610,98197973,104675099,104818190,104820934,104822569,104823132,104827018,104827585,104829228,100005888,99436694,98197972,100403120,104805530,104825345,68891219,68891711,74990846,98197970,103235256,104804675,104817831,104818182,104829806,104829807,104824780,104827584,100005889,104827017,104829229,104824779,104829224,104829225,104833790,104833791,104833795,104836041,104833796,104833797,104829230,104406613,103763456,104406614,104551736,104828890,104833469,104837999,104838000,104329962,104769523,104828892,104833472,104833786,104833798,104833799,104833800,104833801,104833802,104835726,104836039,104836042,104836046,104838305,104838312,104838647,104842903,104843245,104845572,104857685,104782630,104833470,104833803,104834392,104836661,104836662,92220881,104626375,104778986,104786001,104786004,104786007,104840946,104845570,104850268,104829226,104838001,91837080,101381720,101381721,104565559,104699622,104805265,104833787,104833788,104836045,104838310,104838649,104840297,104840595,104840947,104842911,104842912,104842913,104785658,104847296,104700160,104792492,104829227,104829231,104833792,104841239,104836663,103179970,103179971,103179972,103179973,103179974,104765826,104792491,104805805,104829805,104833471,104833782,104833789,104836040,104836378,104840292,104841240,104842905,104842906,104842909,104845571,104857686,104779496,104845569,104828893,104833781,104833783,104838303,104838304,104840593,104840945,104842904,80945892,80945893,91580786,104082714,104111657,104493976,104703194,104785664,104800286,104805260,104840596,104785663,104782336,104786002,104843244,104785657,104785659,104836043,104838306,104838307,104840299,104849659,104772394,104838648,104838650,104840298,104840296,104700007,104720109,104786492,104793330,76788882,89971933,89971934,103265333,104329961,104778982,104778983,104778985,104778989,104778991,104778992,104779278,104786024,104834109,104835727,104836047,104837997,104837998,104838003,104838308,104838309,104840592,104842910,104845227,104778990,104782337,104843243,104329963,104329964,104565567,104706419,104778988,104785997,104842915,104842916,104845225,104845230,104849658,104853293,104853294,83206223,83206224,83206225,83206226,83206227,83206228,104700005,104617526,104700168,104778987,104857088,66687429,66687434,91580785,104700169,104779279,104833793,104838002,104840301,104842907,104842908,104845223,104847573,104857358,104700170,104838937,104844945,104778984,104779274,104779275,104779276,104782631,104785662,104838313,104838314,104840594,104779277,104617522,66687430,66687431,77418657,89971938,103662873,103662874,103662876,103662877,104617520,104617525,104772395,104818456,104818457,104818464,104833784,104836044,104843246,104843247,104847574,104847908,104850269,104700171,104700167,62646751,62646752,104805262,104838311,104840300,104842607,104842914,104844946,104845224,104847572,104849935,104857359,66687432,66687433,67391965,69696689,70815153,70815154,70815155,70815156,70815157,70815158,70815159,71513585,82832755,102296350,103662895,103662896,103662897,104626388,104807070,104847910,104848222,104617519,104789398,104617521,104617523,85373815,104151422,104151425,104845226,104845228,104845229,104849933,104857689,104857690,74066947,101898230,103662872,103662875,103662878,103662879,104312450,104626376,104713506,104817840,104817846,104845231,104847576,104857087,104857360,104857688,104876933,104804914,73210028,101898232,104326460,104850266,104617524,104786000,65105483,75096189,76225178,77418658,103613402,103613403,104626395,104796834,104800275,104849934,104877184,101457699,104876934,104544845,77491694,81628636,104151486,104626341,104626413,104626414,104626415,104626416,104626417,104626418,104684661,104700223,104700224,104800274,104823299,104823300,104847909,104857687,104876028,104811376,77491787,68482707,74230367,75096190,75096192,75096193,75096194,76788885,76788886,78886628,82832731,101898190,101898231,102657413,103235257,103310004,103674077,104220807,104476261,104626377,104713516,104818759,104833785,104852944,104858250,104612101,104479792,104635470,104684680,104684681,104684682,104825522,104834589,101898184,103476111,65105477,66665658,66665661,68036256,68036259,68088780,68088784,68088785,68089095,69930501,70529025,75913534,76224994,76224995,76224996,76224997,76224998,76224999,76225000,77890124,103045913,103235444,103235445,103310005,103674074,103674075,103674076,103747042,103747043,104055993,104082656,104090148,104093614,104093615,104104138,104104139,104104140,104612103,104635471,104805808,104825523,104833794,104876935,104792489,104804913,102604029,104090146,104858000,65105480,68035951,68939368,68939375,75913531,76561132,89971762,104476262,104612098,104612102,104626344,104684662,104713513,104713517,104713519,104832220,100776772,75913535,76788884,76788889,100776774,100776779,101827135,101874452,103652129,103717996,104090147,104479793,104626410,104684740,104823302,104825524,104832221,104862997,102864433,102864434,104814134,79592159,79592160,79592161,79592162,79592163,79592164,104805807,104825525,104862998,69204618,69930503,69930504,69930505,73249425,76789245,81628631,103645237,104626411,104815687,73249048,73249428,73249429,73249431,73249772,77491576,103476112,69930502,74105292,76788883,76788887,93197837,101898187,103235258,103265228,102864435,102864436,102864437,102864438,102864439,102864440,102864441,102864442,104862999,104804916,104867722,101137845,104609295,104812262,103235260,104876936,104451807,104451808,102487149,102487150,104865106,82672386,93585795,100273919,102487152,103783843,104312465,104684708,104684709,104822851,104874818,104881400,104881944,104881945,104881946,104883211,104883497,104883498,104883499,104883811) AND sports.id=10 and mat.start_time BETWEEN '2024-03-27 23:59:59' AND '2024-03-29 00:00:00' group by matches.sea_id,matches.round,matches.id order by com.com_name,col.col_name,mat.start_time DESC, mat.cor_id DESC, mat.id limit 800
More Information:
  • Mysql Error : 1054
  • Mysql Error no # : Unknown column 'mat.start_time' in 'where clause'
  • Date : March 28, 2024, 10:54 am
  • Referer: http://www.hokejlive.net/svet//live/
  • Script: /svet//live/