Panasonic
Camera AW-HE870E
MFR #AW-HE870E
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 = 1000004073
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 = 1000004073
)
GROUP BY cf.custom_field_name
ORDER BY cf.custom_field_order_number ASC, cfv.custom_field_value_order_number ASC
Compact Camera HD/SD with Component out
AW-HE870E
Type: Compact Camera HD/SD with Component out
CONNECTORS
Video out: 1xYPbPr(HD or SD, 50pin) or CVBS
LENS SYSTEM
Image sensor: 3CCD
Lens: Changeable Lens 2/3"
Aspect ratio: 16:9
Min. Illumination: 0.015LUX
OTHERS
Format: 1080i & 720P 50HZ/60HZ, 576i PAL, 480i NTSC
Consumption: 18.5Watt, 12V
Weight: 1.2Kg
Dimensions: 83mm x 104.5mm x 192mm
Extra Features: GAIN/SHUTTER/GAMMA/AWB functions
Guarantee: 2-YEARS
Πηγή: http://www.panasonic.com/sg/business/broadcast/camera-systems/hd-box-camera/aw-he870e.html