select * from user_registration where ureg_id like 'kanhaiy%'
select ureg_id, cust_mobile, count(*) from aw_customers where ureg_id is null and cust_mobile is not null group by ureg_id, cust_mobile having count(*)>1
pdate aw_customers set ureg_id=cust_mobile where ureg_id is null and cust_mobile is not null and cust_mobile not in (919416049399,919422072419,919811323636)
select ureg_id, count(*) from aw_customers group by ureg_id having count(*)>1
select * from aw_customers where cust_mobile in ('919416049399','919422072419','919811323636') order by cust_mobile

select * from aw_customers where cust_id=10316

pdate aw_customers set ureg_id=cust_id where cust_mobile in ('919416049399','919422072419','919811323636') and ureg_id is null

select cust_id, ureg_id, rtrim(ureg_id)+cast(cust_id as varchar(7)) from aw_customers where ureg_id in ('suresh','kanhaiya','rsrana','kedia','bhushan','anil','anurag','saurav','sunil')
pdate aw_customers set ureg_id=rtrim(ureg_id)+cast(cust_id as varchar(7)) where ureg_id in ('suresh','kanhaiya','rsrana','kedia','bhushan','anil','anurag','saurav','sunil')
pdate aw_customers set cust_city='bhi' where cust_id=11854
select cust_id, count(*) from aw_customers group by cust_id having count(*)>1

select * from aw_customers where cust_id=20654

select * from aw_customer_subscription where cust_id=20654


--------------
select count(*) from aw_customer_subscription 
select count(*) from aw_customers

select * from aw_operators


