Paidmails - User abfragen die nicht in der Reload sind

[Lokutos]

$mails = db_query('SELECT * FROM vms_gebuchte_werbung WHERE werbeart = "paidmail" AND menge > 0 AND status = 1 AND uid != 0 ORDER BY RAND() LIMIT 1');

zum Paidmails hast du ja bereits.

nun brauchen wir noch die User.

SELECT * FROM `vms_emaildaten` AS `e`LEFT JOIN `vms_reload` AS `r` ON (`r`.`uid` = `e`.`uid` AND `r`.`tan` = ".$abfrage1['tan']."  AND t2.bis >= ".time().")
WHERE `e`.`freigabe_fuer` = 1 AND `e`.`uid` != ".$abfrage1['uid']." AND `r`.`tan` IS NULL
ORDER BY RAND()
LIMIT ".$abfrage1['menge']."

in php:

<?php
$abfrage1 = mysql_fetch_assoc(db_query("SELECT * FROM vms_gebuchte_werbung WHERE werbeart = 'paidmail' AND menge > 0 AND status = 1 AND uid != 0 ORDER BY RAND() LIMIT 1"));
$abfrage2 = db_query("SELECT * FROM `vms_emaildaten` AS `e`                        
LEFT JOIN `vms_reload` AS `r` ON (`r`.`uid` = `e`.`uid` AND `r`.`tan` = '".$abfrage1['tan']."'  AND `r`.`bis` >= ".time().")                        
WHERE `e`.`freigabe_fuer` = 1 AND `e`.`uid` != ".$abfrage1['uid']." AND `r`.`tan` IS NULL                        
ORDER BY RAND()                       
LIMIT ".$abfrage1['menge']."");

while($data = mysql_fetch_assoc($abfrage2)){    

    $data['emailadresse'];   
    $abfrage1['gebuchte_werbung spalten'];

}