IN Linux Отличный SQL не работает с UNNEST

Когда я запускаю этот запрос в оконной системе, корректно ведет себя UNNSET, но когда я запускаю этот запрос, то Linux ведет себя по-разному. Дублирует список записей в разных строках

SELECT DISTINCT "billing_billmanagement"."creation_date", "billing_billmanagement"."bill_number", unnest(array_agg(DISTINCT "inventory_product"."product_name")) AS "product", unnest(array_agg(DISTINCT "services_service"."name")) AS "service" FROM "billing_billmanagement" INNER JOIN "users_staffuser" ON ("billing_billmanagement"."staff_id" = "users_staffuser"."id") INNER JOIN "auth_user" ON ("users_staffuser"."user_id" = "auth_user"."id") LEFT OUTER JOIN "billing_customerproductbill" ON ("billing_billmanagement"."id" = "billing_customerproductbill"."bill_id") LEFT OUTER JOIN "inventory_product" ON ("billing_customerproductbill"."product_id" = "inventory_product"."id") LEFT OUTER JOIN "billing_customerservicebill" ON ("billing_billmanagement"."id" = "billing_customerservicebill"."bill_id") LEFT OUTER JOIN "services_service" ON ("billing_customerservicebill"."service_id" = "services_service"."id") WHERE "billing_billmanagement"."creation_date" BETWEEN '2017-12-04' AND '2017-12-06' GROUP BY billing_billmanagement.creation_date, billing_billmanagement.bill_number ORDER BY "billing_billmanagement"."creation_date" ASC 

    Если получение повторяющихся строк является проблемой, попробуйте это

      SELECT billing_billmanagement.creation_date, billing_billmanagement.bill_number, inventory_product.product_name AS product, services_service.name AS service FROM billing_billmanagement INNER JOIN users_staffuser ON (billing_billmanagement.staff_id = users_staffuser.id) INNER JOIN auth_user ON (users_staffuser.user_id = auth_user.id) LEFT OUTER JOIN billing_customerproductbill ON (billing_billmanagement.id = billing_customerproductbill.bill_id) LEFT OUTER JOIN inventory_product ON (billing_customerproductbill.product_id = inventory_product.id) LEFT OUTER JOIN billing_customerservicebill ON (billing_billmanagement.id = billing_customerservicebill.bill_id) LEFT OUTER JOIN services_service ON (billing_customerservicebill.service_id = services_service.id) WHERE billing_billmanagement.creation_date BETWEEN '2017-12-04' AND '2017-12-06' GROUP BY 1, 2, 3, 4 ORDER BY 1 ASC;