1064 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 's-clothing-online-Wholesale-clothing-suppliers-of-authentic-urban-clothing-and-w' at line 3
in:
[select count(p.products_id) as total FROM products p, products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 and ( pd.products_name LIKE '%-do-wholesale-business-with-wholesale-suppliers-We-are-the-largest-wholesaler-of-New-Overstock-Clothing-Wholesale-Juniors-ClothingWholesale-Clothing-high-quality-wholesale-Apparel-directly-from-top-Chinese-reliable-Apparel-wholesalers-Korean-Fashion-Wholesale-Japanese-Clothing-for-you-wholesale-woman's-clothing-online-Wholesale-clothing-suppliers-of-authentic-urban-clothing-and-wholesale-apparel-International-sales-agent-and-dealer-for-clothing-and-fashion-clothing-retailing-clothes-retailing-dress-retailing-fashion-dress-wholesaler-Wholesale-Clothing-Distributor%' OR p.products_model LIKE '%-do-wholesale-business-with-wholesale-suppliers-We-are-the-largest-wholesaler-of-New-Overstock-Clothing-Wholesale-Juniors-ClothingWholesale-Clothing-high-quality-wholesale-Apparel-directly-from-top-Chinese-reliable-Apparel-wholesalers-Korean-Fashion-Wholesale-Japanese-Clothing-for-you-wholesale-woman's-clothing-online-Wholesale-clothing-suppliers-of-authentic-urban-clothing-and-wholesale-apparel-International-sales-agent-and-dealer-for-clothing-and-fashion-clothing-retailing-clothes-retailing-dress-retailing-fashion-dress-wholesaler-Wholesale-Clothing-Distributor%') ]