SELECT CONTRACT_REF_NO,count(*) FROM LDTBS_CONTRACT_ACCRUAL_HISTORY GROUP BY CONTRACT_REF_NO HAVING COUNT(*) > 1000 result of the query the contract_ref_no has been replaced with xxxxxxxx CONTRACT_REF_NO COUNT{*} XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,054.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,109.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,080.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,137.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,099.00 XXXXXXXXX 1,099.00 XXXXXXXXX 1,099.00 XXXXXXXXX 1,107.00 XXXXXXXXX 1,099.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,131.00 XXXXXXXXX 1,131.00 XXXXXXXXX 1,131.00 XXXXXXXXX 1,126.00 XXXXXXXXX 1,099.00 XXXXXXXXX 1,091.00 XXXXXXXXX 1,099.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,140.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,133.00 XXXXXXXXX 1,133.00 XXXXXXXXX 1,137.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,132.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,132.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,137.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,132.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,140.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,140.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,086.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,110.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,126.00 XXXXXXXXX 1,053.00 XXXXXXXXX 1,095.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,153.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,051.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,077.00 XXXXXXXXX 1,160.00 XXXXXXXXX 1,001.00 XXXXXXXXX 1,124.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,025.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,027.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,048.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,025.00 XXXXXXXXX 1,029.00 XXXXXXXXX 1,005.00 XXXXXXXXX 1,007.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,074.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,006.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,005.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,006.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,005.00 XXXXXXXXX 1,024.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,023.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,145.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,049.00 XXXXXXXXX 1,041.00 XXXXXXXXX 1,024.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,053.00 XXXXXXXXX 1,043.00 XXXXXXXXX 1,043.00 XXXXXXXXX 1,160.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,126.00 XXXXXXXXX 1,041.00 XXXXXXXXX 1,094.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,058.00 XXXXXXXXX 1,125.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,041.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,013.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,126.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,004.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,131.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,043.00 XXXXXXXXX 1,021.00 XXXXXXXXX 1,099.00 XXXXXXXXX 1,150.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,055.00 XXXXXXXXX 1,153.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,069.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,026.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,148.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,046.00 XXXXXXXXX 1,149.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,146.00 XXXXXXXXX 1,148.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,153.00 XXXXXXXXX 1,175.00 XXXXXXXXX 1,152.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,107.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,032.00 XXXXXXXXX 1,148.00 XXXXXXXXX 1,082.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,028.00 XXXXXXXXX 1,051.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,150.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,175.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,175.00 XXXXXXXXX 1,175.00 XXXXXXXXX 1,175.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,036.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,046.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,032.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,126.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,079.00 XXXXXXXXX 1,079.00 XXXXXXXXX 1,146.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,160.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,019.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,030.00 XXXXXXXXX 1,175.00 XXXXXXXXX 1,115.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,123.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,145.00 XXXXXXXXX 1,132.00 XXXXXXXXX 1,125.00 XXXXXXXXX 1,174.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,169.00 XXXXXXXXX 1,136.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,146.00 XXXXXXXXX 1,148.00 XXXXXXXXX 1,017.00 XXXXXXXXX 1,015.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,019.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,076.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,127.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,124.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,138.00 XXXXXXXXX 1,028.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,146.00 XXXXXXXXX 1,020.00 XXXXXXXXX 1,146.00 XXXXXXXXX 1,124.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,127.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,028.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,173.00 XXXXXXXXX 1,126.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,173.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,078.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,127.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,124.00 XXXXXXXXX 1,097.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,124.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,024.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,150.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,149.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,007.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,030.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,143.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,148.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,148.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,144.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,145.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,173.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,175.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,018.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,171.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,024.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,174.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,106.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,171.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,163.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,022.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,106.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,110.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,021.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,147.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,124.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,126.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,140.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,124.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,143.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,176.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,153.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,143.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,137.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,131.00 XXXXXXXXX 1,106.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,130.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,182.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,027.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,138.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,141.00 XXXXXXXXX 1,048.00 XXXXXXXXX 1,148.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,148.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,141.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,141.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,127.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,005.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,035.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,128.00 XXXXXXXXX 1,131.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,123.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,142.00 XXXXXXXXX 1,160.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,156.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,026.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,141.00 XXXXXXXXX 1,143.00 XXXXXXXXX 1,055.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,179.00 XXXXXXXXX 1,165.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,136.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,181.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,153.00 XXXXXXXXX 1,180.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,178.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,177.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,160.00 XXXXXXXXX 1,004.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,159.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,134.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,081.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,160.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,160.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,160.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,158.00 XXXXXXXXX 1,157.00 XXXXXXXXX 1,161.00 XXXXXXXXX 1,111.00 XXXXXXXXX 1,153.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,151.00 XXXXXXXXX 1,154.00 XXXXXXXXX 1,155.00 XXXXXXXXX 1,133.00 XXXXXXXXX 1,135.00 XXXXXXXXX 1,131.00 XXXXXXXXX 1,129.00 XXXXXXXXX 1,091.00 XXXXXXXXX 1,091.00 XXXXXXXXX 1,090.00 XXXXXXXXX 1,090.00 XXXXXXXXX 1,090.00 XXXXXXXXX 1,090.00 XXXXXXXXX 1,090.00 XXXXXXXXX 1,102.00 XXXXXXXXX 1,102.00 XXXXXXXXX 1,083.00 XXXXXXXXX 1,084.00 XXXXXXXXX 1,082.00 XXXXXXXXX 1,080.00 XXXXXXXXX 1,022.00 XXXXXXXXX 1,022.00 XXXXXXXXX 1,022.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,094.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,104.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,103.00 XXXXXXXXX 1,105.00 XXXXXXXXX 1,021.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,089.00 XXXXXXXXX 1,089.00 XXXXXXXXX 1,089.00 XXXXXXXXX 1,101.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,075.00 XXXXXXXXX 1,055.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,055.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,055.00 XXXXXXXXX 1,053.00 XXXXXXXXX 1,051.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,052.00 XXXXXXXXX 1,051.00 XXXXXXXXX 1,058.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,057.00 XXXXXXXXX 1,058.00 XXXXXXXXX 1,054.00 XXXXXXXXX 1,042.00 XXXXXXXXX 1,046.00 XXXXXXXXX 1,042.00 XXXXXXXXX 1,033.00 XXXXXXXXX 1,048.00 XXXXXXXXX 1,048.00 XXXXXXXXX 1,047.00 XXXXXXXXX 1,046.00 XXXXXXXXX 1,049.00 XXXXXXXXX 1,033.00 XXXXXXXXX 1,139.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,137.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,056.00 XXXXXXXXX 1,137.00 XXXXXXXXX 1,133.00 XXXXXXXXX 1,148.00 the second query SELECT CONTRACT_REF_NO, COUNT(*) FROM LDTB_AMOUNT_DUE GROUP BY CONTRACT_REF_NO HAVING COUNT(*) > 1000 didn't got any result . i tried with 500 also