SELECT r.CLASS AS CLASS,CONCAT_WS(', ',r.CLUB,r.CITY) AS CLUB,e.TYPE AS TYPE,e.DATE AS DATE,e.WWW_TITLE AS WWW_TITLE,e.DISTRICT AS DISTRICT,e.DAYS_COUNT AS DAYS_COUNT,e.TOT_COUNT AS TOT_COUNT,rd.EVENT_SID AS EVENT_SID,IF(cr.SPORT IS NULL,e.SPORT,cr.SPORT) AS SPORT,ed.EDAYS AS EDAYS,ed.SEC01 AS SEC01,GROUP_CONCAT(rd.DAY ORDER BY rd.DAY SEPARATOR ',') AS RDAYS,GROUP_CONCAT(rd.RES_TYPE ORDER BY rd.DAY SEPARATOR ',') AS RES_TYPE,GROUP_CONCAT(rd.RESULT ORDER BY rd.DAY SEPARATOR ',') AS RESULT,GROUP_CONCAT(rd.PLACE ORDER BY rd.DAY SEPARATOR ',') AS PLACE,GROUP_CONCAT(rd.LEG ORDER BY rd.DAY SEPARATOR ',') AS LEG,td.TRES_TYPE AS TRES_TYPE,td.TRESULT AS TRESULT,td.TPLACE AS TPLACE FROM runner_day AS rd LEFT JOIN runners AS r ON r.EVENT_SID=rd.EVENT_SID AND r.NUMBER=rd.NUMBER AND r.LEG=rd.LEG LEFT JOIN events AS e ON e.SID=rd.EVENT_SID LEFT JOIN (SELECT EVENT_SID,GROUP_CONCAT(DAY ORDER BY DAY SEPARATOR ',') AS EDAYS,GROUP_CONCAT(SEC01 ORDER BY DAY SEPARATOR ',') AS SEC01 FROM event_day GROUP BY EVENT_SID) AS ed ON ed.EVENT_SID=rd.EVENT_SID LEFT JOIN classes AS cl ON cl.EVENT_SID=rd.EVENT_SID AND cl.CLASS=r.CLASS LEFT JOIN courses AS cr ON cr.EVENT_SID=rd.EVENT_SID AND cr.ID=cl.COURSE_ID LEFT JOIN (SELECT EVENT_SID,GROUP_CONCAT(DAY ORDER BY DAY SEPARATOR ',') AS TDAYS,GROUP_CONCAT(RES_TYPE ORDER BY DAY SEPARATOR ',') AS TRES_TYPE,GROUP_CONCAT(RESULT ORDER BY DAY SEPARATOR ',') AS TRESULT,GROUP_CONCAT(PLACE ORDER BY DAY SEPARATOR ',') AS TPLACE FROM team_day GROUP BY EVENT_SID,TEAM_ID ) AS td ON td.EVENT_SID=rd.EVENT_SID AND td.TEAM_ID=r.TEAM_ID WHERE r.ODB_SID IN (2884) AND r.DELETED=0 and IF(cr.SPORT IS NULL,e.SPORT,cr.SPORT)='ob' and year(e.date)=2009 GROUP BY rd.EVENT_SID,rd.NUMBER ORDER BY e.DATE DESC,rd.EVENT_SID Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /srv/www/takas/dalyviu_paieska.php on line 136 Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /srv/www/takas/dalyviu_paieska.php on line 194 Orientavimosi sporto programos "Takas" tinklalapis

Naujienos
Varžybos
Masinės
Dalyviai
Kortelės
Žemėlapiai
Šalys
Statistika
DUK
Parsisiųst
Nuorodos

Dalyvių paieška

Žagata Mikus

Sportas: Orientavimasis bėgte
Metai: 2009

Varžybų skaičius: 0

Data Varžybos Vietovė Sportas Grupė Klubas, Miestas Vieta Rezultatas Diena / Etapas

1 2 3 4 5