instrument_x_instrument_specification.id,instrument.id,instrument.ts,instrument.title,instrument.card_title,instrument.brand,instrument.price_rrp,instrument.price_without_tax,instrument.sku,instrument.upc,instrument.availability,instrument.condition,instrument.feature_1,instrument.feature_2,instrument.feature_4,instrument.detail_1,instrument.product_description,instrument.features,instrument.specifications_content,instrument.description,instrument_specification.id,instrument_specification.ts,instrument_specification.key,instrument_specification.value
52,49,"2018-01-02 03:32:04",Yamaha,"Yamaha YPC-62 Piccolo; Grenadilla Body",Yamaha,"$3,215.00","$2,272.99",YAM-BO-YPC-62,086792503059,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"This has long been a favorite of professional musicians and can be found in many top orchestras. Characterized by excellent intonation and playability. It features a headjoint and body of carefully seasoned grenadilla for a warm full tone.",52,"2018-01-02 03:32:04","Body Material","Grenadilla Wood"
53,49,"2018-01-02 03:32:04",Yamaha,"Yamaha YPC-62 Piccolo; Grenadilla Body",Yamaha,"$3,215.00","$2,272.99",YAM-BO-YPC-62,086792503059,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"This has long been a favorite of professional musicians and can be found in many top orchestras. Characterized by excellent intonation and playability. It features a headjoint and body of carefully seasoned grenadilla for a warm full tone.",53,"2018-01-02 03:32:04",Headjoint,"Grenadilla Wood; Conical Bore"
56,49,"2018-01-02 03:32:04",Yamaha,"Yamaha YPC-62 Piccolo; Grenadilla Body",Yamaha,"$3,215.00","$2,272.99",YAM-BO-YPC-62,086792503059,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"This has long been a favorite of professional musicians and can be found in many top orchestras. Characterized by excellent intonation and playability. It features a headjoint and body of carefully seasoned grenadilla for a warm full tone.",56,"2018-01-02 03:32:04",Plating,"Silver (keys and posts)"
65,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",35,"2018-01-02 03:31:59","Key of",C
66,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",36,"2018-01-02 03:31:59","Body Style",Standard
69,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",39,"2018-01-02 03:31:59","Key Material","Nickel Silver"
70,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",40,"2018-01-02 03:31:59",Footjoint,N/A
72,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",42,"2018-01-02 03:31:59","Tone Holes",Undercut
73,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",43,"2018-01-02 03:31:59","Key System",N/A
74,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",44,"2018-01-02 03:31:59","Key Types","Concave contoured with ribbed key post"
75,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",45,"2018-01-02 03:31:59","Key Mechanism","Split E"
76,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",46,"2018-01-02 03:31:59","Spring Type","Stainless Steel"
77,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",47,"2018-01-02 03:31:59","Screw Type",Straight
78,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",48,"2018-01-02 03:31:59","Bumper Type",Neoprene
64,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",49,"2018-01-02 03:32:04",Level,Professional
67,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",52,"2018-01-02 03:32:04","Body Material","Grenadilla Wood"
71,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",56,"2018-01-02 03:32:04",Plating,"Silver (keys and posts)"
68,50,"2018-01-02 03:32:10",Yamaha,"Yamaha YPC-62R Piccolo; Wave Cut Headjoint",Yamaha,"$3,735.00","$2,563.99",YAM-BO-YPC-62R,086792958286,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"A long-time favorite of professional musicians, the YPC-62 can be found in many top orchestras worldwide. Sharing many of the characteristics of the Yamaha handcrafted series, the YPC-62R features a similar design and boasts a high degree of hand-craftsma",68,"2018-01-02 03:32:10",Headjoint,
80,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",35,"2018-01-02 03:31:59","Key of",C
81,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",36,"2018-01-02 03:31:59","Body Style",Standard
84,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",39,"2018-01-02 03:31:59","Key Material","Nickel Silver"
85,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",40,"2018-01-02 03:31:59",Footjoint,N/A
87,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",42,"2018-01-02 03:31:59","Tone Holes",Undercut
88,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",43,"2018-01-02 03:31:59","Key System",N/A
89,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",44,"2018-01-02 03:31:59","Key Types","Concave contoured with ribbed key post"
90,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",45,"2018-01-02 03:31:59","Key Mechanism","Split E"
91,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",46,"2018-01-02 03:31:59","Spring Type","Stainless Steel"
92,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",47,"2018-01-02 03:31:59","Screw Type",Straight
93,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",48,"2018-01-02 03:31:59","Bumper Type",Neoprene
82,51,"2018-01-02 03:32:21",Yamaha,"Yamaha YPC-81 Handcrafted Piccolo",Yamaha,"$4,590.00","$3,275.99",YAM-BO-YPC-81,086792503066,"Usually ships in 4-5 business days.",New,Professional,"Key of C",,"With Case",,,,"These piccolos are handcrafted by accomplished artisans and have bodies of top grade grenadilla. The YPC-82 features a sterling silver headjoint while the YPC-81 features a headjoint of grenadilla.",52,"2018-01-02 03:32:04","Body Material","Grenadilla Wood"