Paidmails - User abfragen die nicht in der Reload sind

[breaker]

Dieses System ist bei mir im orw.Control schon seit Jahren verbaut. Allerdings mit einigen Features mehr,- zb. wechselndes Mail-Templates, Fakeschutz, wirklich eindeutige TANs, Reload vom System, Reload der Kampagnen, Blackliste usw.

        $sql1 = $db->setQuery ('SELECT
            p.*,
            g.code AS ordered,
            b.code AS blacklist,
            r.reload AS reload
        FROM ' . $db->quoteName ('#__paidmails') . ' AS p
        LEFT JOIN ' . $db->quoteName ('#__paidmails_ordered') . ' AS g
            ON (p.code = g.code)
        LEFT JOIN ' . $db->quoteName ('#__blacklist') . ' AS b
            ON (p.code = b.code)
            AND (b.w_art = ' . $db->escape ('pm') . ')
        LEFT JOIN ' . $db->quoteName ('#__paidmails_reload') . ' AS r
            ON (p.code = r.code)
        WHERE p.sponsor = ' . $db->escape ($this->id) . '
        AND p.art = ' . $db->escape ($this->art) . '
        GROUP BY p.code
        ORDER BY p.ver_admin DESC');