GoPro
Camera Hero Session
MFR #CHDHS-102BLK #320-0050
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 = 9681790987
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 = 9681790987
)
GROUP BY cf.custom_field_name
ORDER BY cf.custom_field_order_number ASC, cfv.custom_field_value_order_number ASC
- Action Camera 8MP
- HD recording
- Fixed Lens - Auto Focus
- 10m waterproof
- Micro SD-HC/SD-XC Card
- WiFi Connection
- Built-in Mic
- 1-year Warranty
Hero Session
High-Performance Video + Photo
High resolution of 1440 pixels per inch delivers sharp, professional video. Frame rates up to 100 frames per second creates smooth slow-motion playback.
Compact Mounting
Sleek and compact, HERO Session captures amazing new perspectives.
Time Lapse + Burst Photos
Set time lapse at intervals from 0.5 to 60 seconds. HERO Session can also take a burst of photos up to 10 frames per second.
Bluetooth® + Wi-Fi
Bluetooth and Wi-Fi make it easy to stay connected with GoPro apps, accessories and more.
Simple One-Button Control
A single press of the shutter button powers the camera on and starts recording automatically.
Rugged + Waterproof
Durable by design, HERO Session is waterproof to 33ft (10m) without a housing.
Wear it. Mount it. Love it.™
Capture life in a whole new way with 30+ GoPro mounts and accessories, including Karma™ Grip, 3-Way™, Chesty and more.
Access + share from anywhere.
An optional GoPro Plus subscription makes it easy to access, edit and share your photos and videos on your phone—anytime, anywhere.
High resolution of 1440 pixels per inch delivers sharp, professional video. Frame rates up to 100 frames per second creates smooth slow-motion playback.
Compact Mounting
Sleek and compact, HERO Session captures amazing new perspectives.
Time Lapse + Burst Photos
Set time lapse at intervals from 0.5 to 60 seconds. HERO Session can also take a burst of photos up to 10 frames per second.
Bluetooth® + Wi-Fi
Bluetooth and Wi-Fi make it easy to stay connected with GoPro apps, accessories and more.
Simple One-Button Control
A single press of the shutter button powers the camera on and starts recording automatically.
Rugged + Waterproof
Durable by design, HERO Session is waterproof to 33ft (10m) without a housing.
Wear it. Mount it. Love it.™
Capture life in a whole new way with 30+ GoPro mounts and accessories, including Karma™ Grip, 3-Way™, Chesty and more.
Access + share from anywhere.
An optional GoPro Plus subscription makes it easy to access, edit and share your photos and videos on your phone—anytime, anywhere.
Πηγή: http://shop.gopro.com/EMEA/cameras/hero-session/CHDHS-104-master.html