wie mache ich das :-)

[Parl]

Na dann vielleicht so:

$kamp = db_query("SELECT t1.* FROM vms_gebuchte_werbung AS t1 
LEFT JOIN vms_reloads_mail AS t2 ON (t1.tan = t2.tan AND (t2.uid = '".$_SESSION['uid']."' OR t2.ip = '".$ip."') AND t2.bis >= '".time()."') 
LEFT JOIN stg_interface AS t3 ON t1.sponsor = t3.sponsor  
WHERE t3.sonderregel = 0 AND t1.tan = '".$_GET['tan']."' AND t2.tan IS NULL AND t1.werbeart = 'paidmail' AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 LIMIT 1"); 

MFG