Abfrage: SELECT stops.id , stops.x , stops.y , stops.name ,', Linie(n): ', GROUP_CONCAT(stoproutes.routes_id ORDER BY stoproutes.routes_id) FROM stops , stoproutes WHERE stops.id = stoproutes.stops_id GROUP BY stops.id;
Abfrage: SELECT DISTINCT routes.id , routes.colorhex FROM routes ORDER BY routes.id;
SELECT DISTINCT routes.id , routes.colorhex FROM routes ORDER BY routes.id;