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 classid in (117,118,120,122,123,124,125,126,127,128,129,130,131,132,133,134,' at line 1
SELECT COUNT(*) as total FROM `***_ecms_shop` WHERE and classid in (117,118,120,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162) and ((title LIKE '%黑色花架%'))