|
|
| TEST-RS-SERVER auf new.remoteschach.de |
|
Current Tournaments...
| Tournament search filter |  |
|
|
|
|
|
|
|
|
SELECT
t.ID AS ID,
t.chesstyp,
t.startfen,
t.txt AS txt,
t.startdat AS start,
DATE_FORMAT(t.startdat, '%d.%m.%Y') AS tstart,
DATE_FORMAT(t.beendet, '%d.%m.%Y') AS tende,
t.privat AS privat,
t.beendet AS beendet,
t.turniertyp AS turniertyp,
t.ID_themen AS ID_themen,
th.txtkurz AS thema,
u.nick AS tleitername
FROM turniere AS t
LEFT JOIN user AS u ON u.ID = IFNULL(t.ID_leiter_org,t.ID_leiter)
LEFT JOIN spiele AS s ON s.ID_turnier = t.ID
LEFT JOIN themen AS th ON th.ID = t.ID_themen
WHERE t.ID>2 AND t.beendet IS NULL AND t.startdatEs ist ein Fehler aufgetreten. Das RS-Team wurde per EMail benachrichtigt.
© Copyright 2000-2026 remoteSchach.de [ Home | Imprint | Terms and conditions | Email ] |
Loading...
Home
Download
Prices/Membership
Help
Feedback
