SELECT R.* , T1.Team_en AS TeamA, T1.Team_URL AS UrlA, T1.Location_ID AS ALocation_ID, T1.img_avatar AS img_avatarA,T1.profile_img AS profile_imgA , T2.Team_en AS TeamB, T2.Team_URL AS UrlB, T2.Location_ID AS BLocation_ID, T2.img_avatar AS img_avatarB,T2.profile_img AS profile_imgB , T.Name AS TurName , SPN.Sport_Name_en AS SportName, SPN.Sport_Name_URL AS SportURL,SPN.Sport_URL , L.name_en AS Stadion,L.city_en as city,L.ID as locId , SPN_P.Sport_Name_en AS P_SportName, SPN_P.Sport_Name_URL AS P_SportURL,SPN_P.Sport_URL as P_Sport_URL , SPN_P_P.Sport_Name_en AS P_P_SportName, SPN_P_P.Sport_Name_URL AS P_P_SportURL,SPN_P_P.Sport_URL as P_P_Sport_URL FROM `result` AS R INNER JOIN `sezon` AS T ON(T.Sezon_ID = R.Tur_ID) INNER JOIN `sport_name` AS SPN ON(SPN.Sport_ID = T.Sport_ID) LEFT JOIN `sport_name` AS SPN_P ON(SPN_P.Sport_ID = SPN.Parent_ID and SPN_P.Level>=3) LEFT JOIN `sport_name` AS SPN_P_P ON(SPN_P_P.Sport_ID = SPN_P.Parent_ID and SPN_P_P.Level>=3) INNER JOIN `teams` AS T1 ON(R.A_ID = T1.Team_ID) INNER JOIN `teams` AS T2 ON(R.B_ID = T2.Team_ID) LEFT JOIN `location` AS L ON(L.ID = R.Location_ID) WHERE (R.A_ID=4 OR B_ID=4) AND (R.DateEvents < '2017-06-23' OR R.DateEvents='2017-06-23') ORDER BY R.DateEvents DESC LIMIT 0 , 1
Unknown column 'L.name_en' in 'field list'; KOD: 1054
SELECT R.* , T1.Team_en AS TeamA, T1.Team_URL AS UrlA, T1.Location_ID AS ALocation_ID, T1.img_avatar AS img_avatarA,T1.profile_img AS profile_imgA , T2.Team_en AS TeamB, T2.Team_URL AS UrlB, T2.Location_ID AS BLocation_ID, T2.img_avatar AS img_avatarB,T2.profile_img AS profile_imgB , T.Name AS TurName , SPN.Sport_Name_en AS SportName, SPN.Sport_Name_URL AS SportURL,SPN.Sport_URL , L.name_en AS Stadion,L.city_en as city,L.ID as locId , SPN_P.Sport_Name_en AS P_SportName, SPN_P.Sport_Name_URL AS P_SportURL,SPN_P.Sport_URL as P_Sport_URL , SPN_P_P.Sport_Name_en AS P_P_SportName, SPN_P_P.Sport_Name_URL AS P_P_SportURL,SPN_P_P.Sport_URL as P_P_Sport_URL FROM `result` AS R INNER JOIN `sezon` AS T ON(T.Sezon_ID = R.Tur_ID) INNER JOIN `sport_name` AS SPN ON(SPN.Sport_ID = T.Sport_ID) LEFT JOIN `sport_name` AS SPN_P ON(SPN_P.Sport_ID = SPN.Parent_ID and SPN_P.Level>=3) LEFT JOIN `sport_name` AS SPN_P_P ON(SPN_P_P.Sport_ID = SPN_P.Parent_ID and SPN_P_P.Level>=3) INNER JOIN `teams` AS T1 ON(R.A_ID = T1.Team_ID) INNER JOIN `teams` AS T2 ON(R.B_ID = T2.Team_ID) LEFT JOIN `location` AS L ON(L.ID = R.Location_ID) WHERE (R.A_ID=4 OR B_ID=4) AND (R.DateEvents >'2017-06-23') ORDER BY R.DateEvents ASC LIMIT 0 , 1
Unknown column 'L.name_en' in 'field list'; KOD: 1054
SELECT R.Res_ID, R.A_Res, R.B_Res,R.A_ID,R.B_ID, R.Point_A, R.Point_B , R.DateEvents, R.TimeEvents, R.Game_URL , T1.Team_en AS TeamA, T1.Team_URL AS UrlA,T1.Team_ID AS TeamA_ID,T1.img_avatar AS img_avatarA,T1.profile_img AS profile_imgA , T2.Team_en AS TeamB, T2.Team_URL AS UrlB,T2.Team_ID AS TeamB_ID,T2.img_avatar AS img_avatarB,T2.profile_img AS profile_imgB , T.Name AS TurName , S.Name AS SezonName , SPN.Sport_Name_en AS SportName, SPN.Sport_URL AS Sport_URL ,SPN.Sport_Name_URL AS SportURL , L.name_en AS Stadion, L.city_en AS city , CA.name_en AS TeamALoc,CB.name_en AS TeamBLoc , SPN_P.Sport_Name_en AS P_SportName, SPN_P.Sport_Name_URL AS P_SportURL,SPN_P.Sport_URL as P_Sport_URL , SPN_P_P.Sport_Name_en AS P_P_SportName, SPN_P_P.Sport_Name_URL AS P_P_SportURL,SPN_P_P.Sport_URL as P_P_Sport_URL FROM `result` AS R INNER JOIN `sezon` AS T ON(T.Sezon_ID = R.Tur_ID) INNER JOIN `sezon` AS S ON(T.parent = S.Sezon_ID) INNER JOIN `sport_name` AS SPN ON(SPN.Sport_ID = S.Sport_ID) LEFT JOIN `sport_name` AS SPN_P ON(SPN_P.Sport_ID = SPN.Parent_ID and SPN_P.Level>=3) LEFT JOIN `sport_name` AS SPN_P_P ON(SPN_P_P.Sport_ID = SPN_P.Parent_ID and SPN_P_P.Level>=3) INNER JOIN `teams` AS T1 ON(R.A_ID = T1.Team_ID) INNER JOIN `teams` AS T2 ON(R.B_ID = T2.Team_ID) LEFT JOIN `location` AS L ON(L.ID = R.Location_ID) LEFT JOIN `countries` AS CA ON(CA.id_country = T1.Location_ID) LEFT JOIN `countries` AS CB ON(CB.id_country = T2.Location_ID) WHERE R.Res_ID AND S.Sport_ID = 369 AND S.Sezon_ID = 873 AND ( R.A_ID = 4 OR R.B_ID = 4) ORDER BY DateEvents DESC LIMIT 0 , 100
Unknown column 'L.name_en' in 'field list'; KOD: 1054
FC DACIA
  • 2010/2011

  • 2011/2012

  • 2014/2015 2012/2013 2011/2012 2008/2009 2007/2008

  • 2004/2005

Latest news

All news

Iskra-Stal-Dacia :photo gallery

We propose to your attention the most beautiful pictures ...

  • 22 April 2012

Stiliyan Petrov,get well soon!

FC Dacia wants to express the univocal support for Petrov Stylian ...

  • 18 April 2012

Picture story :FC Dacia-FC Tiraspol

FC Dacia has qualified for the seventh time in Moldova Cup ...

  • 10 April 2012

Latest photos

Photo galleries

Latest video

Video