select record from justreg by ticket