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 Wintergrip Chelsea Boots' and a.categories_id=23 and d.language_id = ' 1 ' ' at line 1
in:
[SELECT * FROM categories a, categories_description b,products c,products_description d where c.products_status=1 and a.categories_id = b.categories_id and c.products_id = d.products_id and c.products_color = 'Womens Dr Martens 2976 Alyson Dm'S Wintergrip Chelsea Boots' and a.categories_id=23 and d.language_id = ' 1 ' ORDER BY rand() LIMIT 10]