Accepted Payment Methods
Tilta
Accessory Float-System-Baby-Pin
MFR #GSS-T01-PDABLK #544-0196
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 = 8959536788
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 = 8959536788
)
GROUP BY cf.custom_field_name
ORDER BY cf.custom_field_order_number ASC, cfv.custom_field_value_order_number ASC
- Baby Pin Adapter
- For Tilta Float System
- Easy Adjustment
- Durable Material
- Black Color
- Lightweight
- High Quality
