Filters for configurable userid exclusion added:

[mailer.git] / inc / modules / admin / what-list_rallye_prices.php

diff --git a/inc/modules/admin/what-list_rallye_prices.php b/inc/modules/admin/what-list_rallye_prices.php
index 66487027e7db5e0a93bc4ba2c92f9ab6976cdc92..1f2f3368affc0e13ad7b68132ecb96be0aa237d9 100644 (file)
--- a/inc/modules/admin/what-list_rallye_prices.php
+++ b/inc/modules/admin/what-list_rallye_prices.php
@@ -237,21 +237,21 @@ LIMIT 1",
 } 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 = '';