select count(*) as cnt from breed_store_category a inner join breed_store_multicategory b on a.cateno=b.category_id inner join breed_store_goods c on b.goods_id=c.goodsno where a.lft between and and goods_display=0

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 and goods_display=0' at line 3