)]}'
[{"id":"openstack%2Fplacement~801419","triplet_id":"openstack%2Fplacement~master~Ie0bee79c1ee185c0f68fa170c668395d9058c56d","project":"openstack/placement","branch":"master","topic":"fixsqlinstatus","hashtags":[],"change_id":"Ie0bee79c1ee185c0f68fa170c668395d9058c56d","subject":"Fix SQL query counting the number of individual consumers having allocations by only selecting the aggregated consumer_id column.","status":"MERGED","created":"2021-07-20 07:17:10.000000000","updated":"2021-07-29 11:11:37.000000000","submitted":"2021-07-29 11:07:41.000000000","submitter":{"_account_id":22348},"insertions":3,"deletions":2,"total_comment_count":1,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"801419-fixsqlinstatus","meta_rev_id":"90c39b6b8da0d0eeb164219c322a6bc6c6a0030b","_number":801419,"virtual_id_number":801419,"owner":{"_account_id":32755},"current_revision_number":3,"requirements":[],"submit_records":[{"status":"CLOSED","labels":[{"label":"Verified","status":"OK","applied_by":{"_account_id":22348}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":11564}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":11564}}]}]}]