SWEET COCOON

SELECT distinct p.id, p.code, p.name, p.uri, p.details, p.collections_id, p.notes, p.auxtext1, p.auxtext4, p.date_available, p.retail_price, p.stock, p.stockmin FROM products p INNER JOIN categories c on p.categories_id=c.id LEFT JOIN subcategories s ON p.subcategories_id = s.id WHERE p.dealers_id = :dealers_id AND p.categories_id = :categories_id AND p.subcategories_id = :subcategories_id AND s.status=1 AND p.status = 1 AND c.status = 1 AND (s.status = 1 OR ISNULL(s.status)) ORDER BY c.vieworder, c.code, s.vieworder, s.code, p.vieworder, p.code LIMIT 0,60
Array ( [:dealers_id] => 2 [:categories_id] => 31 [:subcategories_id] => 417 )

SWC - TREN DE CARACOL

REF. J04010

SWC - PATOS APILABLES

REF. J04059

SWC - CUENTAS DE PÁJAROS PARA ENHEBRAR

REF. J04050

SWC - CARACOL SENSORIAL APILABLE

REF. J04052

SWC - CARRITO CUBO CARACOL

REF. J04054

SWC - VEHICULO PARA PASEAR

REF. J04413

SWC - ÁBACO DE ORUGA

REF. J04014

SWC - ABLA DE ESTIMULACIÓN MUSICAL ORUGA

REF. J04058

SWC - CASITA DE PÁJAROS DE FORMAS

REF. J04062

SWC - CIRCUITO DE PÁJARO

REF. J04040

SWC - DESCENDOR HORMIGAS

REF. J04038

SWC - JUEGO DE EQUILIBRIO DE HORMIGA

REF. J04053

SWC - CAMINADOR MULTIACTIVIDADES

REF. J04410

SWC - MESA DE ACTIVIDADES DEL JARDIN

REF. J04045

SWC - PUZLE ABECEDARIO

REF. J04412

TORRE DE OBSERVACIÓN

REF. J09640