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 '83 Zapatos para Mujer Zapatilla de deporte' and a.categories_id=6 and d.langua' 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 = 'Nike air pegasus '83 Zapatos para Mujer Zapatilla de deporte' and a.categories_id=6 and d.language_id = ' 1 ' ORDER BY rand() LIMIT 10]