galaxy

select distinct pbx_call_id,
       first_value(clid) over (partition by pbx_call_id order by callstart) clid,
       ... -- остальные поля
  from calls;

select pbx_call_id,
       jsonb_agg(json_build_object('disposition', disposition, 'sip', sip)) as sips
  from calls
 group by pbx_call_id

struct mystruct s;
struct mystruct *ps;

s.field = 1; /* если s - структура, то  точка */
ps->field = 1; /* если ps - указатель на структуру, то стрелка */

$stmt = $pdo->prepare("TRUNCATE TABLE `rests`");
$stmt->execute();
$stmt = $pdo->prepare("
INSERT INTO
`cg_rests`(
`Name`,