SELECT c.id, c.nombre, count(rpc.id_producto) AS cantidad FROM categoria_cliente c LEFT JOIN renglon_producto_categoria rpc ON rpc.id_categoria=c.id WHERE c.id_padre=1581 AND c.visible!='no' GROUP BY c.id ORDER BY c.orden GUANTES

PERFUMERIA  

Se encontraron 20 resultados
whatsapp