} else {
// No rallye selected so display all available without prices
$result = SQL_QUERY("SELECT
- d.id AS `rallye_id`,
- d.admin_id,
- d.start_time,
- d.end_time,
- d.title,
- a.login,
- d.is_active
+ `d`.`id` AS `rallye_id`,
+ `d`.`admin_id`,
+ `d`.`start_time`,
+ `d`.`end_time`,
+ `d`.`title`,
+ `a`.`login`,
+ `d`.`is_active`
FROM
- `{?_MYSQL_PREFIX?}_rallye_data` AS d
+ `{?_MYSQL_PREFIX?}_rallye_data` AS `d`
LEFT JOIN
- `{?_MYSQL_PREFIX?}_admins` AS a
+ `{?_MYSQL_PREFIX?}_admins` AS `a`
ON
- d.admin_id=a.id
+ `d`.`admin_id`=`a`.`id`
ORDER BY
- d.start_time DESC", __FILE__, __LINE__);
+ `d`.`start_time` DESC", __FILE__, __LINE__);
if (!SQL_HASZERONUMS($result)) {
// List found rallyes
$OUT = '';