sql = SELECT * FROM [Poker] WHERE PM_CLICK2PAY = 'Click2Pay' AND STATUS='Live' ORDER BY TRUST_RANK_NO DESCsqlC = SELECT count(*) AS num_rec FROM [Poker] WHERE PM_CLICK2PAY = 'Click2Pay' AND STATUS='Live'