GIOIA

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] => 399 )

GIOIA - TROMPETA

REF. J07645

GIOIA - MARACAS DOBLES

REF. J07651

GIOIA - SET DE INSTRUMENTOS MUSICALES

REF. J07656

GIOIA - PALO DE LLUVIA

REF. J07657

GIOIA - SONAJERO

REF. J07658

GIOIA - SILBATO

REF. J07665

GIOIA - PANDERETA

REF. J07666

GIOIA - CAMPANILLAS

REF. J07638

GIOIA - UKELELE

REF. J07652

GIOIA - ARMÓNICAS

REF. J07653

GIOIA - ACORDEÓN

REF. J07654

GIOIA - FLAUTA

REF. J07664

GIOIA - MESA MUSICAL

REF. J07655

GIOIA - KALIMBA

REF. J07659

GIOIA - TAMBOR DE MANO DE MONO

REF. J07660

GIOIA - BANJO DE LA JUNGLA

REF. J07661

GIOIA - PANDERETA

REF. J07662

GIOIA - XILÓFONO

REF. J07663