- $result = SQL_QUERY("SELECT p.id, p.userid AS uid, p.payout_total, p.target_account, p.target_bank, t.type, p.payout_timestamp, p.status, t.allow_url AS allow, p.target_url AS url, p.link_text AS alt, p.banner_url AS banner
-FROM `{!_MYSQL_PREFIX!}_user_payouts` AS p, `{!_MYSQL_PREFIX!}_payout_types` AS t
-WHERE p.payout_id=t.id
-ORDER BY p.payout_timestamp DESC", __FILE__, __LINE__);
-
- if (SQL_NUMROWS($result) > 0) {
+ $result = SQL_QUERY("SELECT
+ p.id, p.userid, p.payout_total, p.target_account,
+ p.target_bank, t.type, p.payout_timestamp, p.status,
+ t.allow_url AS allow, p.target_url AS url, p.link_text AS alt,
+ p.banner_url AS banner
+FROM
+ `{?_MYSQL_PREFIX?}_user_payouts` AS p
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_payout_types` AS t
+ON
+ p.payout_id=t.id
+ORDER BY
+ p.payout_timestamp DESC", __FILE__, __LINE__);
+
+ if (!SQL_HASZERONUMS($result)) {