pcave

<?php

$result = db_query("SELECT f.did FROM fundraiser_sustainers_series s 
  INNER JOIN fundraiser_sustainers f ON f.master_did = s.did 
  INNER JOIN fundraiser_donation d ON d.did = f.did
  WHERE s.status = 'active' 
  AND gateway = 'authnet_aim|commerce_payment_authnet_aim' 
  AND card_id IS NULL 
  AND d.status = 'pending_future_payment' limit 100");