- $result = SQL_QUERY("SELECT d.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!}_admins` AS a
-WHERE d.admin_id=a.id ORDER BY start_time DESC", __FILE__, __LINE__);
+ $result = SQL_QUERY("SELECT
+ d.id, d.admin_id, d.start_time, d.end_time, d.title, a.login, d.is_active
+FROM
+ `{?_MYSQL_PREFIX?}_rallye_data` AS d,
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_admins` AS a
+ON
+ d.admin_id=a.id
+ORDER BY
+ `d.start_time` DESC", __FILE__, __LINE__);