gistfile1.txt

WITH rewrite_plan AS (
    SELECT json_object_field_text(ucm.rewrite, 'rewrite_build_type_to') as release_channel,
    json_array_elements(ucm.rewrite->'BuildID') AS buildid,
    product_versions.product_version_id
    FROM product_productid_map ppm
    JOIN update_channel_map ucm USING (productid)
    JOIN product_versions ON ppm.product_name = product_versions.product_name
    WHERE product_versions.version_string = trim(both '"' FROM (ucm.rewrite->'Version')::text)
    AND product_versions.product_name = 'B2G'
)

SELECT * FROM rewrite_plan;