and pidname="zuoji" and price_net > 10000 and ((substring(cardname,4,4)%1111=0 or substring(cardname,5,4)%1111=0 or substring(cardname,6,4)%1111=0) and substring(cardname,7,4)%1111<>0) and substring(cardname,-3,3)= "111"