|
|
 |
 |
 |
 |
 |
| Zeit |
# |
Name |
Fahrzeug |
Ort (Jahr) |
/homepages/44/d188269683/htdocs/LIVE/module/speedclub_10.php
47
SELECT
ee.CarNumber,
MIN(ee.1320Foot) AS 1320Foot,
ea.vorname,
ea.name,
ea.hersteller,
ea.typ,
e.event_id,
e.event_timestamp,
eo.name AS eoname
FROM
event_ergebnisse ee
LEFT JOIN
events e
ON e.event_id = ee.event_id
LEFT JOIN
event_orte eo
ON eo.id = e.event_ort_id
LEFT JOIN
event_anmeldungen ea
ON ea.CarNumber = ee.CarNumber AND ea.event_id = ee.event_id
WHERE
e.art = 1 AND -- VIERTEL MEILE
ea.klassen_id < 10 AND
ee.CarNumber >= 100 AND
ee.1320Foot BETWEEN 10000 AND 10999
GROUP BY
ee.CarNumber,
ee.event_id
ORDER BY
1320Foot ASC
Unknown column 'ea.vorname' in 'field list' | | |
