- 号码 套餐资费 卡费 话费 操作
- 号码 套餐资费 卡费 话费 操作
MySQL Query : SELECT COUNT(*) AS num FROM `sylhao`.`cms_haoma` WHERE `status` = '99' AND haoma not like '%6%' AND AND haoma like '%3%3%3%3%' AND instr(haoma,168) > 0 AND right(haoma,4) >= 1980 and right(haoma,4) < 1990 AND `taocan` = '0' AND (
( floor(mid(haoma,2,2)) mod 11 = 0 and floor(mid(haoma,4,2)) mod 11 =0 and floor(mid(haoma,2,2))<>floor(mid(haoma,4,2)) and floor(mid(haoma,5,1))<>floor(mid(haoma,6,1)) and floor(mid(haoma,2,1))<>floor(mid(haoma,1,1)) )
or ( floor(mid(haoma,3,2)) mod 11 = 0 and floor(mid(haoma,5,2)) mod 11 =0 and floor(mid(haoma,3,2))<>floor(mid(haoma,5,2)) and floor(mid(haoma,6,1))<>floor(mid(haoma,7,1)) and floor(mid(haoma,3,1))<>floor(mid(haoma,2,1)) )
or ( floor(mid(haoma,4,2)) mod 11 = 0 and floor(mid(haoma,6,2)) mod 11 =0 and floor(mid(haoma,4,2))<>floor(mid(haoma,6,2)) and floor(mid(haoma,7,1))<>floor(mid(haoma,8,1)) and floor(mid(haoma,4,1))<>floor(mid(haoma,3,1)) )
or ( floor(mid(haoma,5,2)) mod 11 = 0 and floor(mid(haoma,7,2)) mod 11 =0 and floor(mid(haoma,5,2))<>floor(mid(haoma,7,2)) and floor(mid(haoma,8,1))<>floor(mid(haoma,9,1)) and floor(mid(haoma,5,1))<>floor(mid(haoma,4,1)) )
or ( floor(mid(haoma,6,2)) mod 11 = 0 and floor(mid(haoma,8,2)) mod 11 =0 and floor(mid(haoma,6,2))<>floor(mid(haoma,8,2)) and floor(mid(haoma,9,1))<>floor(mid(haoma,10,1)) and floor(mid(haoma,6,1))<>floor(mid(haoma,5,1)) )
or ( floor(mid(haoma,7,2)) mod 11 = 0 and floor(mid(haoma,9,2)) mod 11 =0 and floor(mid(haoma,7,2))<>floor(mid(haoma,9,2)) and floor(mid(haoma,10,1))<>floor(mid(haoma,11,1)) and floor(mid(haoma,7,1))<>floor(mid(haoma,6,1)) )
or ( floor(mid(haoma,8,2)) mod 11 = 0 and floor(mid(haoma,10,2)) mod 11 =0 and floor(mid(haoma,8,2))<>floor(mid(haoma,10,2)) and floor(mid(haoma,8,1))<>floor(mid(haoma,7,1)) )
) LIMIT 1
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND haoma like '%3%3%3%3%' AND instr(haoma,168) > 0 AND right(haoma,4) >= 1980 a' at line 1
MySQL Errno : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND haoma like '%3%3%3%3%' AND instr(haoma,168) > 0 AND right(haoma,4) >= 1980 a' at line 1
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND haoma like '%3%3%3%3%' AND instr(haoma,168) > 0 AND right(haoma,4) >= 1980 a' at line 1
MySQL Errno : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND haoma like '%3%3%3%3%' AND instr(haoma,168) > 0 AND right(haoma,4) >= 1980 a' at line 1