Products meeting the search criteria

Búsqueda

---

Ordenar por:

Nombre Precio: más Caros primeros Precio: más Baratos primeros Más Vendidos

---

Filtro por Animales:

Todos Perro Gato Roedores Pájaros Caballos Peces Tortugas y Reptiles

---

Categories

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 ') group by c.parent_id' at line 4

select distinct p.products_image, m.manufacturers_name, m.manufacturers_id, p.vendidos, p.agotados, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.sold_in_bundle_only, pd.etiqueta1 , p2c.categories_id as categories_id,p.products_quantity, cd.categories_name as categories_name, c.parent_id as parent_id, (SELECT cd2.categories_name FROM categories_description cd2 WHERE cd2.categories_id=c.parent_id AND cd2.language_id=3) nombre_padre from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id left join products_description pd ON pd.products_id = p.products_id , categories c, products_to_categories p2c, categories_description cd where p.products_status = '1' and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '4' and c.categories_id IN () group by c.parent_id

[TEP STOP]