unmerged delivery changes

select * from changes join pipelines on changes.pipeline_id = pipelines.id join projects on projects.id = pipelines.project_Id where merge_sha is null and project_id = 1;
-[ RECORD 1 ]-------------+----------------------------------------------------------------------------------------------------------------------------------------
id                        | 3dc4a095-87e8-4419-96f3-6bd2dc50d6f0
pipeline_id               | 2
feature_branch            | BAT-161/search-bar
merge_sha                 |
title                     | [BAT-161] Add the search bar to workflow screens
description               |
approved_by               |
changeset_id              |
latest_patchset_status    | open
latest_patchset           | 2
submitted_at              | 2016-06-29 18:44:02.779036+00
submitted_by              | jblack
delivered_at              |
delivered_by              |
pipeline_name_at_creation | master
superseding_change_id     |
approved_at               |
id                        | 2
project_id                | 1
name                      | master
id                        | 1
organization_id           | 1
guid                      | 0b3d559a-29b8-4bb9-b697-34de324472ce
name                      | delivery
scm_module                | deliv_scm_local
-[ RECORD 2 ]-------------+----------------------------------------------------------------------------------------------------------------------------------------
id                        | d291b122-e91f-49e7-9756-4346eccd6ca2
pipeline_id               | 2
feature_branch            | BP-187/prompt-for-node-overwrite
merge_sha                 |
title                     | [BP-187] Add flag support for overwriting build nodes
description               |
approved_by               |
changeset_id              |
latest_patchset_status    | open
latest_patchset           | 1
submitted_at              | 2016-06-29 16:04:53.105618+00
submitted_by              | jmink
delivered_at              |
delivered_by              |
pipeline_name_at_creation | master
superseding_change_id     |
approved_at               |
id                        | 2
project_id                | 1
name                      | master
id                        | 1
organization_id           | 1
guid                      | 0b3d559a-29b8-4bb9-b697-34de324472ce
name                      | delivery
scm_module                | deliv_scm_local
-[ RECORD 3 ]-------------+----------------------------------------------------------------------------------------------------------------------------------------
id                        | e5a6f16d-28f6-4df1-91ff-ca67c84946d0
pipeline_id               | 2
feature_branch            | BP-197/aws
merge_sha                 |
title                     | Update instructions around fqdn for delivery and chef servers
description               |
approved_by               |
changeset_id              |
latest_patchset_status    | open
latest_patchset           | 1
submitted_at              | 2016-06-28 19:28:28.953244+00
submitted_by              | marc
delivered_at              |
delivered_by              |
pipeline_name_at_creation | master
superseding_change_id     |
approved_at               |
id                        | 2
project_id                | 1
name                      | master
id                        | 1
organization_id           | 1
guid                      | 0b3d559a-29b8-4bb9-b697-34de324472ce
name                      | delivery
scm_module                | deliv_scm_local
-[ RECORD 4 ]-------------+----------------------------------------------------------------------------------------------------------------------------------------
id                        | 0cb469a8-c72a-4183-a744-addeeb978224
pipeline_id               | 2
feature_branch            | BP-226/latency_warnings
merge_sha                 |
title                     | [BP-226] Warn for long running reconfigure and notify when not creating enterprise
description               |
approved_by               |
changeset_id              |
latest_patchset_status    | open
latest_patchset           | 1
submitted_at              | 2016-06-28 20:11:37.167472+00
submitted_by              | marc
delivered_at              |
delivered_by              |
pipeline_name_at_creation | master
superseding_change_id     |
approved_at               |
id                        | 2
project_id                | 1
name                      | master
id                        | 1
organization_id           | 1
guid                      | 0b3d559a-29b8-4bb9-b697-34de324472ce
name                      | delivery
scm_module                | deliv_scm_local
-[ RECORD 5 ]-------------+----------------------------------------------------------------------------------------------------------------------------------------
id                        | 1d667dd8-891d-41ae-92d2-a504d3ed424d
pipeline_id               | 2
feature_branch            | afiune/enable-multiple-pipelines-for-github-scm
merge_sha                 |
title                     | Enable multiple pipelines for Github SCM
description               | Alright guys! The Github Integration wan't capable to manupulate
                          | multiple pipelines and we all know that that's the power of Delivery.
                          |
                          | This tiny change will enable the users to be able to create different
                          | pipelines for `github` projects, which was the last missing piece of the
                          | puzzle.
                          |
                          | I have verified that the following process to configure a new pipeline
                          | for Github Projects works fine:
                          | 1. You must have the project already configured, that means that you are
                          | able to create PR's and trigger the pipelines in Delivery.
                          | 2. You must have the new pipeline branch already created on github with
                          | at least one commit
                          | 3. Create a new pipeline (same name as the branch above) in Delivery.
                          | 4. Create a PR against the new pipeline in Github.
                          |
                          | Here an example:
                          | https://github.com/chef-cookbooks/delivery-github-demo/pull/17
                          |
                          | Feedback from customers:
                          | https://feedback.chef.io/forums/289357-delivery-product-feedback/suggestions/14896782-github-integration-should-allow-for-more-than-one