{"param1":"
SELECT 
  ppg.`pg_id` pgId,
  ppg.`name`,
  ppg.`description`,
  ppg.`create_time` createTime,
  ppg.`store_id` storeId,
  ppg.`domain` 
FROM
  p_privilege_group ppg 
WHERE ppg.`domain` = #storeTypeCd#
  AND ppg.`store_id` = #storeId#
  AND ppg.`status_cd` = '0' 
  AND NOT EXISTS 
  (SELECT 
    1 
  FROM
    p_privilege_user ppu 
  WHERE ppu.`status_cd` = '0' 
    AND ppu.`user_id` = #userId#
    AND ppu.`p_id` = ppg.`pg_id` 
    AND ppu.`privilege_flag` = '1')
"
}