- 号码 套餐资费 卡费 话费 操作
- 号码 套餐资费 卡费 话费 操作
MySQL Query : SELECT COUNT(*) AS num FROM `www_slj520_com`.`cms_haoma` WHERE `status` = '99' AND `yunyingshang` = 2 AND instr(haoma,888) > 0 AND kafei >= 20000 and kafei <= 30000 AND right(haoma,4) >= 2010 and right(haoma,4) < 2020 AND floor(mid(right(haoma,4),1,2)) = 06 and floor(mid(right(haoma,2),1,2)) <= 31 AND (
( floor(mid(haoma,2,5)) mod 11111 = 0 and floor(mid(haoma,6,1))<>floor(mid(haoma,7,1)) )
or ( floor(mid(haoma,3,5)) mod 11111 = 0 and floor(mid(haoma,7,1))<>floor(mid(haoma,8,1)) and floor(mid(haoma,3,1))<>floor(mid(haoma,2,1)) )
or ( floor(mid(haoma,4,5)) mod 11111 = 0 and floor(mid(haoma,8,1))<>floor(mid(haoma,9,1)) and floor(mid(haoma,4,1))<>floor(mid(haoma,3,1)) )
or ( floor(mid(haoma,5,5)) mod 11111 = 0 and floor(mid(haoma,9,1))<>floor(mid(haoma,10,1)) and floor(mid(haoma,5,1))<>floor(mid(haoma,4,1)) )
or ( floor(mid(haoma,6,5)) mod 11111 = 0 and floor(mid(haoma,10,1))<>floor(mid(haoma,11,1)) and floor(mid(haoma,6,1))<>floor(mid(haoma,5,1)) )
or ( floor(mid(haoma,7,5)) mod 11111 = 0 and floor(mid(haoma,7,1))<>floor(mid(haoma,6,1)) )
) LIMIT 1
MySQL Error : Table '.\www_slj520_com\cms_haoma' is marked as crashed and should be repaired
MySQL Errno : 145
Message : Table '.\www_slj520_com\cms_haoma' is marked as crashed and should be repaired
MySQL Error : Table '.\www_slj520_com\cms_haoma' is marked as crashed and should be repaired
MySQL Errno : 145
Message : Table '.\www_slj520_com\cms_haoma' is marked as crashed and should be repaired