|
|
 |
 |
 |
 |
 |
| KMH |
# |
Name |
Fahrzeug |
Ort (Jahr) |
/homepages/44/d188269683/htdocs/LIVE/module/speedclub_300.php
48
SELECT
ee.CarNumber,
ee.KMH2,
ea.name,
ea.vorname,
ea.hersteller,
ea.typ,
e.event_timestamp,
e.event_id,
eo.name AS ort
FROM
event_ergebnisse ee
LEFT JOIN
events e
ON e.event_id = ee.event_id
LEFT JOIN
event_anmeldungen ea
ON ea.CarNumber = ee.CarNumber AND ea.event_id = e.event_id
INNER JOIN
event_orte eo
ON eo.id = e.event_ort_id
WHERE
ee.KMH2 >= 30000 AND
e.gps = 1 AND
ea.klassen_id != 18
GROUP BY
ee.CarNumber
ORDER BY
ee.KMH2 DESC
Unknown column 'ea.name' in 'field list' | | |
