and pidname="liantong" and (substring(cardname,-8,2) = substring(cardname,-4,2) and substring(cardname,-7,1) != substring(cardname,-6,1) and substring(cardname,-3,1) != substring(cardname,-4,1) ) and substring(cardname,-3,3)= "000"