DB Error: ERROR: column "ps.pub_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: select "s".*, "ps".*, COALESCE(stl.setting_value, stpl.setti... ^