get_new_subscriber='SELECT lsmb_acct_id, addr1, addr2, city, state, zip, billing_plan, billing_cycle, fname, lname, email, phone FROM accounts a LEFT JOIN account_users u ON a.account_code = u.account_code WHERE account_billing_contact = \'yes\' AND a.account_code = ?'