- 号码 套餐资费 卡费 话费 操作
- 号码 套餐资费 卡费 话费 操作
MySQL Query : SELECT COUNT(*) AS num FROM `www_haomahao_com`.`cms_haoma` WHERE `status` = '99' AND `yunyingshang` = 3 AND AND kafei > 0 and kafei < 100 AND floor(mid(right(haoma,4),1,2)) = 03 and floor(mid(right(haoma,2),1,2)) <= 31 AND (
floor(mid(right(haoma,2),1,1))=floor(mid(right(haoma,1),1,1)) and floor(mid(right(haoma,5),1,1))= floor(mid(right(haoma,4),1,1)) and floor(mid(right(haoma,3),1,1))<> floor(mid(right(haoma,4),1,1)) and floor(mid(right(haoma,5),1,1))<> floor(mid(right(haoma,6),1,1)) and floor(mid(right(haoma,3),1,1))<> floor(mid(right(haoma,2),1,1)) and floor(mid(right(haoma,6),1,1))=floor(mid(right(haoma,3),1,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 kafei > 0 and kafei < 100 AND floor(mid(right(haoma,4),1,2)) = 03 and floor(' 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 kafei > 0 and kafei < 100 AND floor(mid(right(haoma,4),1,2)) = 03 and floor(' 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 kafei > 0 and kafei < 100 AND floor(mid(right(haoma,4),1,2)) = 03 and floor(' 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 kafei > 0 and kafei < 100 AND floor(mid(right(haoma,4),1,2)) = 03 and floor(' at line 1