Syrp

Case Magic-Carpet-Bag

MFR #SY0044-0001BLK #330-0018
Τιμή: € 74.18 + ΦΠΑ
Online τιμή: € 71.21 + ΦΠΑ
✓ Σε 6 άτοκες δόσεις ή μέχρι 36 έντοκες δόσεις.
3τεμ σε στοκ
SELECT cf.custom_field_name, cfm.custom_field_custom_id, GROUP_CONCAT(DISTINCT cfv.custom_field_value_option ORDER BY cfv.custom_field_value_order_number ASC SEPARATOR '|') as value FROM cms_products_customfields_map cfm LEFT JOIN cms_custom_fields cf ON cf.custom_field_custom_id = cfm.custom_field_custom_id LEFT JOIN cms_custom_fields_values cfv ON cfv.custom_field_custom_id = cfm.custom_field_custom_id AND cfv.custom_field_value_option = cfm.product_customfield_value WHERE cfm.product_custom_id IN( SELECT rp2.product_custom_id FROM cms_relative_products rp LEFT JOIN cms_relative_products rp2 ON rp2.relative_id = rp.relative_id LEFT JOIN cms_products p ON p.product_custom_id = rp2.product_custom_id WHERE rp.product_custom_id = 12576855912 AND p.product_status NOT IN ('Discontinued','NoView') ) AND cfm.custom_field_custom_id IN( SELECT rcf.custom_field_custom_id FROM cms_relative_customfields rcf LEFT JOIN cms_relative_products rp2 ON rp2.relative_id = rcf.relative_id WHERE rp2.product_custom_id = 12576855912 ) GROUP BY cf.custom_field_name ORDER BY cf.custom_field_order_number ASC, cfv.custom_field_value_order_number ASC
Array ( [customFields] => Array ( [Size] => Array ( [0] => Array ( [cfValue] => Array ( [0] => 0.8m ) [cfCustomId] => 1587128819 ) ) ) [curCustomFields] => Array ( [Size] => 0.8m ) [relativeId] => 94 ) Array ( [Size] => Array ( [0] => Array ( [cfValue] => Array ( [0] => 0.8m ) [cfCustomId] => 1587128819 ) ) )
Size
$curCustomFields[key]:0.8m
0.8m

  • Handheld/Shoulder Bag?
  • For Syrp Magic Carpet Short Slider
  • Protective Padding
  • Interior(WxHxD): 800x160x60mm

Magic-Carpet-Bag

Protect your Magic Carpet short track with this soft carry case, made from durable black nylon material with brown leather detailing. Internal protective padding means no dings on your Magic Carpet rails.  Product highlights include a carry handle, over the shoulder carry strap and an outside pocket. The short bag is 800mm x 160mm x 60 mm (LxWxH) and is designed to carry the Magic Carpet short track setup with ends caps + carriage. 


Πηγή: https://syrp.co/us-en/magic-carpet-carbon-bag-sy0044-0001/