and price_net between 501 and 1000 and (substring(cardname,-4,3) = substring(cardname,-8,3) and substring(cardname,-1) != substring(cardname,-5,1) ) and substring(cardname,-3,3)= "777" and cardname not like '5%' and cardname like "9999%"