USE nphic_prod;
SELECT
	b.value->'$**.name' AS Source,
    a.title 'Title',
    DATE_FORMAT(a.created, '%m/%e/%Y') 'Date Shared',
    a.hits 'Total Hits',
    b.id,
    b.value->'$**.value',
    a.extra_fields,
    TRIM(TRAILING '\"]' FROM TRIM(LEADING '[\"' FROM a.extra_fields->>'$**.id')) AS id,
    TRIM(TRAILING '\"]' FROM TRIM(LEADING '[\"' FROM a.extra_fields->'$**.value')) AS value,
    TRIM(TRAILING '\"]' FROM TRIM(LEADING '[\"' FROM JSON_EXTRACT(a.extra_fields, '$**.id'))) AS id2
FROM
	m7alm_k2_items a,
    m7alm_k2_extra_fields b
WHERE
	a.id = 12942 AND
    TRIM(TRAILING '\"]' FROM TRIM(LEADING '[\"' FROM a.extra_fields->'$**.id')) = b.id;