query for single cir