danbarrese
1/10/2017 - 6:26 PM

all properties for certain group

all properties for certain group

SELECT
g.name, nv.name, nv.value
-- concat('"', g.name, '","', nv.name, '","', nv.value, '"')
-- concat(nv.name, '=', nv.value)
FROM ppc_property_name_value nv
INNER JOIN ppc_property_set g ON g.id = nv.property_set_id
WHERE g.name = 'common-domain-client';