SELECT S.*, R.Tur_ID, R.A_Res, R.B_Res, SUM(R.A_Res) AS Games FROM `sezon` AS S LEFT JOIN `result` AS R ON(S.Sezon_ID = R.Tur_ID) WHERE S.parent='4802' GROUP BY S.Sezon_ID ORDER BY S.Sezon_ID
Lost connection to MySQL server during query; KOD: 2013
SELECT `Sport_ID`, `Parent_ID`, `Sport_Name_RU` AS SportName, `Sport_Name_URL` AS URL FROM `sport_name` WHERE `Parent_ID` > 0 AND `Parent_ID` < 3 ORDER BY Parent_ID, `Sort` ASC
MySQL server has gone away; KOD: 2006 - Протокол. . Дивизия A - Футбол. тур - на Молдова.sports.md
    SELECT AL . * , A . * , IU.small_url FROM text AS A INNER JOIN `text_settings` TS ON ( TS.value = A.text_id ) INNER JOIN `text_lang` AL ON ( AL.text_id = A.text_id ) LEFT JOIN `img_all`IA ON ( IA.id_xxx = A.text_id ) LEFT JOIN `img_uploads` IU ON ( IU.img_id = IA.img_id ) WHERE TS.`field_name` IN ('heder_position_1', 'heder_position_2', 'heder_position_3', 'heder_position_4') AND A.`status_main` =1 AND AL.`status` =1 AND AL.`lang` =1 GROUP BY A.text_id ORDER BY TS.id ASC
    MySQL server has gone away; KOD: 2006
SELECT R.*, UNIX_TIMESTAMP(R.DateEvents) AS UNI_DATE, R.Game_URL , T1.Team_ID AS ID_A, T1.Team_ru AS Name_A, T1.Team_URL AS UrlA, T1.profile_img AS Img_A , T2.Team_ID AS ID_B, T2.Team_ru AS Name_B, T2.Team_URL AS UrlB, T2.profile_img AS Img_B , S.Name AS TurName, S.parent AS Sezon_ID , SPN.Sport_ID , SPN.Sport_Name_ru AS SportName, SPN.Sport_Name_URL AS URL , SPN2.Sport_Name_ru AS MAIN, SPN2.Sport_Name_URL AS MAIN_URL FROM `result` AS R INNER JOIN `sezon` AS S ON(R.Tur_ID = S.Sezon_ID) INNER JOIN `teams` AS T1 ON(T1.Team_ID = R.A_ID) INNER JOIN `teams` AS T2 ON(T2.Team_ID = R.B_ID) INNER JOIN `sport_name` AS SPN ON(SPN.Sport_ID = S.Sport_ID) INNER JOIN `sport_name` AS SPN2 ON(SPN2.Sport_ID = SPN.Parent_ID) WHERE R.Tur_ID = NULL ORDER BY R.DateEvents
MySQL server has gone away; KOD: 2006




Матч

,



SELECT CONCAT(IFNULL(P.Player_Name_ru, ''), ' ', P.Player_Famili_ru) AS Player_Name , P.Player_URL , Loc.Name_ru AS Loc_Name, Loc.Name_EN AS Loc_URL FROM `result_inspekt` AS Sud INNER JOIN `players` AS P ON(Sud.Player_ID = P.Player_ID) INNER JOIN `location` AS Loc ON(Loc.ID = P.Location_ID) WHERE Sud.Res_ID = '11090' LIMIT 0, 1
MySQL server has gone away; KOD: 2006
SELECT CONCAT(IFNULL(P.Player_Name_RU, ''), ' ', P.Player_Famili_RU) AS Player_Name , P.Player_URL, P.profile_img , A.*, Tr.Team_ID FROM `players` AS P INNER JOIN `result_trener` AS Tr ON(Tr.Player_ID = P.Player_ID) INNER JOIN `amplua` AS A ON(A.ID = Tr.Amplua_ID) WHERE Tr.Res_ID = '11090' LIMIT 0, 2
MySQL server has gone away; KOD: 2006
SELECT CONCAT(IFNULL(P.Player_Name_RU, ''), ' ', P.Player_Famili_RU) AS Player_Name , P.Player_URL, P.profile_img , A.Name_RU AS AmpluaName, A.Name_EN AS AmpluaURL , Loc.Name_RU AS LocName, Loc.Name_EN AS LocURL FROM `result_inspekt` AS SI INNER JOIN `players` AS P ON(SI.Player_ID = P.Player_ID) #LEFT JOIN `players_amplua` AS PA ON(PA.Player_ID = P.Player_ID) LEFT JOIN `amplua` AS A ON(A.ID = SI.Amplua) LEFT JOIN `location` AS Loc ON(Loc.ID = P.Location_ID) WHERE SI.Res_ID = '11090' AND SI.Amplua =95
MySQL server has gone away; KOD: 2006
SELECT CONCAT(IFNULL(P.Player_Name_RU, ''), ' ', P.Player_Famili_RU) AS Player_Name , P.Player_URL, P.profile_img , A.Name_RU AS AmpluaName, A.Name_EN AS AmpluaURL , Loc.Name_RU AS LocName, Loc.Name_EN AS LocURL FROM `result_inspekt` AS SI INNER JOIN `players` AS P ON(SI.Player_ID = P.Player_ID) #LEFT JOIN `players_amplua` AS PA ON(PA.Player_ID = P.Player_ID) LEFT JOIN `amplua` AS A ON(A.ID = SI.Amplua) LEFT JOIN `location` AS Loc ON(Loc.ID = P.Location_ID) WHERE SI.Res_ID = '11090' AND SI.Amplua =96
MySQL server has gone away; KOD: 2006
SELECT CONCAT(IFNULL(P.Player_Name_RU, ''), ' ', P.Player_Famili_RU) AS Player_Name , P.Player_URL, P.profile_img , A.Name_RU AS AmpluaName, A.Name_EN AS AmpluaURL , Loc.Name_RU AS LocName, Loc.Name_EN AS LocURL FROM `result_inspekt` AS SI INNER JOIN `players` AS P ON(SI.Player_ID = P.Player_ID) #LEFT JOIN `players_amplua` AS PA ON(PA.Player_ID = P.Player_ID) LEFT JOIN `amplua` AS A ON(A.ID = SI.Amplua) LEFT JOIN `location` AS Loc ON(Loc.ID = P.Location_ID) WHERE SI.Res_ID = '11090' AND SI.Amplua =97
MySQL server has gone away; KOD: 2006
SELECT CONCAT(IFNULL(P.Player_Name_RU, ''), ' ', P.Player_Famili_RU) AS Player_Name , P.Player_URL, P.profile_img , A.Name_RU AS AmpluaName, A.Name_EN AS AmpluaURL , Loc.Name_RU AS LocName, Loc.Name_EN AS LocURL FROM `result_inspekt` AS SI INNER JOIN `players` AS P ON(SI.Player_ID = P.Player_ID) #LEFT JOIN `players_amplua` AS PA ON(PA.Player_ID = P.Player_ID) LEFT JOIN `amplua` AS A ON(A.ID = SI.Amplua) LEFT JOIN `location` AS Loc ON(Loc.ID = P.Location_ID) WHERE SI.Res_ID = '11090' AND SI.Amplua =51
MySQL server has gone away; KOD: 2006
SELECT PR.id_player_time, PT.zamena_id, P.player_id , CONCAT(IFNULL(P.Player_Name_ru, ''), ' ', P.Player_Famili_ru) AS Player_Name , P.Player_URL, P.profile_img , AM.*, PT.time_set, A.Name_ru AS AmpluaName FROM `result_players_time` AS PR LEFT JOIN `result_time` AS PT ON(PR.id_player_time = PT.id_player_time) INNER JOIN `players` AS P ON(PR.Player_ID = P.Player_ID) LEFT JOIN `players_amplua` AS AM ON(AM.Player_ID = PR.Player_ID AND AM.amplua_id > 45 AND AM.amplua_id < 50) LEFT JOIN `amplua` AS A ON(A.ID = AM.Amplua_ID) WHERE PR.Res_ID = '11090' AND PR.Team_ID = NULL ORDER BY PR.Sort, IFNULL(AM.amplua_id, 1000), Player_Name
MySQL server has gone away; KOD: 2006
SELECT PR.id_player_time, PT.zamena_id, P.player_id , CONCAT(IFNULL(P.Player_Name_ru, ''), ' ', P.Player_Famili_ru) AS Player_Name , P.Player_URL, P.profile_img , AM.*, PT.time_set, A.Name_ru AS AmpluaName FROM `result_players_time` AS PR LEFT JOIN `result_time` AS PT ON(PR.id_player_time = PT.id_player_time) INNER JOIN `players` AS P ON(PR.Player_ID = P.Player_ID) LEFT JOIN `players_amplua` AS AM ON(AM.Player_ID = PR.Player_ID AND AM.amplua_id > 45 AND AM.amplua_id < 50) LEFT JOIN `amplua` AS A ON(A.ID = AM.Amplua_ID) WHERE PR.Res_ID = '11090' AND PR.Team_ID = NULL ORDER BY PR.Sort, IFNULL(AM.amplua_id, 1000), Player_Name
MySQL server has gone away; KOD: 2006

Протокол матча "" - ""


Показывать:  без фотографий | с фотографиями
Команды
   
   
   
   
   
   
   
   
   
   
   

Cамые обсуждаемые

SELECT A.*, AL.*, IU.medium_url #,(SELECT COUNT(com_id) FROM comments AS C WHERE C.xxx_id = A.text_id) AS Ccaount #,FROM_UNIXTIME(A.date_set) AS asas FROM text AS A INNER JOIN `text_lang` AL ON(AL.text_id = A.text_id) LEFT JOIN `img_all` IA ON(IA.id_xxx = A.text_id) LEFT JOIN `img_uploads` IU ON(IU.img_id = IA.img_id) WHERE A.text_id AND A.cat_id NOT IN (7,9,12,13) AND A.`status_main` = 1 AND AL.`status` = 1 AND AL.`lang` = 1 AND A.cat_id !=7 AND A.date_set >= UNIX_TIMESTAMP(Date_Add( NOW(), Interval -DayOfWeek( NOW()) - 168 hour )) GROUP BY A.text_id ORDER BY A.date_set DESC, A.text_id DESC
MySQL server has gone away; KOD: 2006
Все новости

Самые популярные

SELECT CC.counts, CC.type_ago, A.*, AL.*, IU.medium_url,IU.img_id FROM comments_counts AS CC INNER JOIN `text` AS A ON A.`text_id` = CC.`text_id` INNER JOIN `text_lang` AL ON(AL.text_id = A.text_id AND AL.`lang` = 1) INNER JOIN `img_all` IA ON(IA.id_xxx = CC.text_id) INNER JOIN `img_uploads` IU ON(IU.img_id = IA.img_id) WHERE CC.`type_ago` = '1 YEAR' AND A.`status_main` = 1 AND AL.`status` = 1 AND AL.`lang` = 1 GROUP BY CC.text_id ORDER BY CC.counts DESC #/template3/PrintMostDiscussedYearWidget.php
MySQL server has gone away; KOD: 2006
SELECT CC.counts, CC.type_ago, A.*, AL.*, IU.medium_url,IU.img_id FROM comments_counts AS CC INNER JOIN `text` AS A ON A.`text_id` = CC.`text_id` INNER JOIN `text_lang` AL ON(AL.text_id = A.text_id AND AL.`lang` = 1) INNER JOIN `img_all` IA ON(IA.id_xxx = CC.text_id) INNER JOIN `img_uploads` IU ON(IU.img_id = IA.img_id) WHERE CC.`type_ago` = '6 MONTH' AND A.`status_main` = 1 AND AL.`status` = 1 AND AL.`lang` = 1 GROUP BY CC.text_id ORDER BY CC.counts DESC #/template3/PrintMostDiscussedYearWidget.php
MySQL server has gone away; KOD: 2006
  • за год
  • за 6 месяцев
Все новости
Все новости
Loading...
Наверх ↑