Panasonic
Camera AG-HCK10GE
MFR #AG-HCK10GE
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 = 1000004040
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 = 1000004040
)
GROUP BY cf.custom_field_name
ORDER BY cf.custom_field_order_number ASC, cfv.custom_field_value_order_number ASC
Mini Compact Camera HD
AG-HCK10GE
Type: Mini Compact Camera HD
CONNECTORS
Video out: 20pin (Connection with AG-HMR10E)
LENS SYSTEM
Image sensor: 3MOS 2.51Mpixels
Lens: Fixed Lens 1/4"
Aspect ratio: 16:9
Min. Illumination: 1LUX
OTHERS
Signals supported: 1080i, 720P 50HZ/60HZ
Consumption: 3.5Watt
Weight: 275g
Dimensions: 53.5mm(W) x 56mm(H) x 123.8mm(D)
Extra Features: Internal Stereo Microphone
Guarantee: 2-YEARS