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 < '2015-08-29' OR R.DateEvents='2015-08-29') 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 >'2015-08-29') ORDER BY R.DateEvents ASC LIMIT 0 , 1
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