group owners without paying

<--?php $sql = "select u2.uid, u2.name, agg.nid, agg.abbreviation, agg.artist_first_name, agg.artist_last_name from users u2 join og_uid ou2 on ou2.uid=u2.uid join artistworks_groups_groups agg on agg.nid=ou2.nid where u2.uid not in ( select distinct u.uid from users u join users_roles ur on ur.uid=u.uid join role r on r.rid=ur.rid where u.uid>0 and (r.name = 'administrator' or r.name = 'vip' or r.name = 'artist') ) and ou2.nid != 999999 and agg.type='school' and agg.integration='' and artist_first_name != 'scott' and artist_last_name not like '%theory%' order by u2.uid, ou2.nid"; $result = //db_query($sql); while ($row = db_fetch_object($result)) { $abb = strtoupper($row->abbreviation); if ($abb == 'EMSJ') $abb = 'EMSS'; $sql2 = "select * from uc_recurring_users uru join uc_order_products uop on uop.order_product_id=uru.order_product_id where uid=$row->uid and model like '%$abb%' and created <= unix_timestamp() and next_charge >= unix_timestamp()"; $result2 = db_query($sql2); if (!($row2 = db_fetch_object($result2))) { print "$row->uid, $row->name, $row->nid, $row->abbreviation, $row->artist_first_name $row->artist_last_name - NO MATCH
\n"; } } ?>