select * from resallocation
select * from rccategory
select * from rc
select * from resource_dependency
select * from subscriber order by id desc  where id in (select subscriber from resallocation)

select * from subscriber_config
select * from customerrc order by id desc
select * from resallocation order by id desc for update
select * from subscriber order by id desc
select * from subscription order by id desc where subscriber = 113327
select * from subscriber where describer like 'yiyi1'
select * from subscriber 

update app set pay_status = 1;

select * from app order by id desc
update payment set status = 0 where id > 105932 and status != 0
select * from payment order by id desc
commit
select * from vpnoption order by id desc

select * from  rc d, rcplan c, rcplanprofile b,rcfirstfee a ,rclastfee o where a.rc_plan_profile = b.id and b.rc_plan = c.id and c.rc = d.id and o.rc_plan_profile = b.id

select * from rclastfee r where r.rc_plan_profile in (select id from rcplanprofile where rc_plan = 100121 or rc_plan = 1)
select * from 
select * from fee where id = 9
select * from subscriber where describer like '%萧山市第一人%'
select * from customer where id = 11234
select * from be where id = 9118

select id,app_no, be, customer, pay_status, total_amount, balance from app order by id desc for update
select * from noninstantfeehistory order by id desc

select * from instantfeehistory order by id desc
select * from resallocation where subscriber = 11854
select * from customerrc where resallocation in (select id from resallocation where subscriber = 11854) order by id desc
select * from rc


select * from subscription where subscriber = 11854

select * from resallocation where subscriber = 113358