outputHtml('<div align="center">');
// Check for possible running rallyes
-$ADD = " AND d.`is_active`='Y'";
+$ADD = " AND `d`.`is_active`='Y'";
if (isAdmin()) $ADD = '';
$result = SQL_QUERY("SELECT
- d.`id`,
- d.`admin_id`,
- a.`login`,
- d.`title`,
- d.`descr`,
- d.`template`,
- d.`start_time`,
- d.`end_time`,
- d.`min_users`,
- d.`min_prices`
+ `d`.`id`,
+ `d`.`admin_id`,
+ `a`.`login`,
+ `d`.`title`,
+ `d`.`descr`,
+ `d`.`template`,
+ `d`.`start_time`,
+ `d`.`end_time`,
+ `d`.`min_users`,
+ `d`.`min_prices`
FROM
- `{?_MYSQL_PREFIX?}_rallye_data` AS d
+ `{?_MYSQL_PREFIX?}_rallye_data` AS `d`
INNER JOIN
- `{?_MYSQL_PREFIX?}_admins` AS a
+ `{?_MYSQL_PREFIX?}_admins` AS `a`
ON
- d.`admin_id`=a.`id`
+ `d`.`admin_id`=`a`.`id`
WHERE
- d.`notified`='Y'
+ `d`.`notified`='Y'
" . $ADD . "
ORDER BY
- d.`end_time` ASC
+ `d`.`end_time` ASC
LIMIT 1", __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {