apollosadmin/1-summary.md

## 1-summary.md

      
    Raw
  

              1-summary.md
            
          
    Diff Summary.

diff File

The diff file describes the net changes across the total DB. You should expect changes to this file to represent intended changes to the shovel output. If you are performing a refactor, with no intended code changes, you should expect no changes to this file.
csv File

The csv file represents all operations that were performed that resulted in a data update. This doesn't including touching a content item (only updating a timestamp), but does include wiping a field out and then restoring that field to it's original contents. It will also track id changes.
Optimally, a dag that is not producing changes should not be wiping/restoring data on a run (should produce an empty csv). Practically, we have a long way to go in this area. Some operations (such as keeping track of content_tags) is easier to do by wiping the table and restoring, which produces operations, but doesn't result in a net diff.

  
## 2-diff-7054c07fb1446933d32997b6b06fa59d52bfa553.diff
33c33
< 2182cf87-aa35-4557-87ad-3cb573e6fc3e	Friends & Internet Campus						\N	\N	\N	\N	Campus	2	ministry_platform	\N	\N	t	\N	apollos_demo	campus
---
> 2182cf87-aa35-4557-87ad-3cb573e6fc3e	Friends & Internet Campus						\N	\N	\N	\N	Campus	2	ministry_platform	\N	\N	t	0db0e64f-e5f6-4da3-9f77-480975ac2ba3	apollos_demo	campus
36c36
< 38b7dcca-33be-4b94-8afa-a9b17bb9c458	Churchwide Activities						\N	\N	\N	\N	Campus	4	ministry_platform	\N	\N	t	\N	apollos_demo	campus
---
> 38b7dcca-33be-4b94-8afa-a9b17bb9c458	Churchwide Activities						\N	\N	\N	\N	Campus	4	ministry_platform	\N	\N	t	0db0e64f-e5f6-4da3-9f77-480975ac2ba3	apollos_demo	campus
82c82
< fc0a6550-c603-483d-90b9-bf6a54644895	Apollos Test Campus	\N	\N	\N	\N	\N	\N	\N	\N	f	Campus	1	touchpoint	\N	\N	t	\N	apollos_demo	campus
---
> fc0a6550-c603-483d-90b9-bf6a54644895	Apollos Test Campus	\N	\N	\N	\N	\N	\N	\N	\N	f	Campus	1	touchpoint	\N	\N	t	0db0e64f-e5f6-4da3-9f77-480975ac2ba3	apollos_demo	campus
147a148
> 10c003b2-81cb-4784-b2a7-09126adda221	3e08b8fa-23cb-4dae-8d1e-4719ae755916	d1c03319-fb2e-44bb-b060-c7dec134ef4c	t	apollos_demo	CommunityMember	\N	\N	PENDING	rock	783	community_members
151a153
> 4c1287b0-cc88-43b5-9e14-cc89029516f7	80d63c9a-f6a5-47ec-8944-7165eeac5d3b	2d2c23fc-1301-483f-85da-7870b235eb23	\N	apollos_demo	CommunityMember	\N	\N	PENDING	rock	866	community_members
157a160
> d6a53bc5-534e-4863-a9b8-19e8b8d64618	80d63c9a-f6a5-47ec-8944-7165eeac5d3b	f9cbd6ff-c5d8-4a7d-8beb-31a881fbed26	\N	apollos_demo	CommunityMember	\N	\N	PENDING	rock	892	community_members
712520a712524
> c1984d60-5815-49b5-bf49-7076e5299d52	\N	\N	\N	\N	\N	MALE	\N	f	Person	150	rock	\N	\N	apollos_demo	\N	people
799331d799334
< d91abde2-d722-4551-8b1f-9f15eb9e38b4	\N	\N	\N	\N	\N	MALE	\N	f	Person	150	rock	\N	\N	apollos_demo	\N	people
942120a942124
> a0115ac9-bf16-4863-ae28-8816fbadb9d9	188a71a2-05d3-4097-9bdc-ac578fa960c6	\N	\N	apollos_demo	system	people_tag
942150a942155
> a0115ac9-bf16-4863-ae28-8816fbadb9d9	3e08b8fa-23cb-4dae-8d1e-4719ae755916	\N	\N	apollos_demo	system	people_tag
942213a942219
> a0115ac9-bf16-4863-ae28-8816fbadb9d9	80d63c9a-f6a5-47ec-8944-7165eeac5d3b	\N	\N	apollos_demo	system	people_tag
942223a942230
> a0115ac9-bf16-4863-ae28-8816fbadb9d9	8a183ada-e706-4b1a-b5a2-d24eeccb1256	\N	\N	apollos_demo	system	people_tag
942270a942278
> a0115ac9-bf16-4863-ae28-8816fbadb9d9	c1984d60-5815-49b5-bf49-7076e5299d52	\N	\N	apollos_demo	system	people_tag
942285a942294
> a0115ac9-bf16-4863-ae28-8816fbadb9d9	ce9ad1bc-0fcc-437b-8a7f-0e9694a007a1	\N	\N	apollos_demo	system	people_tag
942287a942297
> a0115ac9-bf16-4863-ae28-8816fbadb9d9	d1e93a01-a3a9-435d-ae1e-be1327a75e4b	\N	\N	apollos_demo	system	people_tag
942293d942302
< a0115ac9-bf16-4863-ae28-8816fbadb9d9	d91abde2-d722-4551-8b1f-9f15eb9e38b4	\N	\N	apollos_demo	system	people_tag
942330a942340
> add44a01-5b1a-4949-af34-0fb4642726fc	188a71a2-05d3-4097-9bdc-ac578fa960c6	\N	\N	apollos_demo	system	people_tag
942338a942349
> add44a01-5b1a-4949-af34-0fb4642726fc	3e08b8fa-23cb-4dae-8d1e-4719ae755916	\N	\N	apollos_demo	system	people_tag
942353a942365
> add44a01-5b1a-4949-af34-0fb4642726fc	80d63c9a-f6a5-47ec-8944-7165eeac5d3b	\N	\N	apollos_demo	system	people_tag
942358a942371
> add44a01-5b1a-4949-af34-0fb4642726fc	88ea86d0-e38b-46b2-829b-2c6a9178cd78	\N	\N	apollos_demo	system	people_tag
942380a942394
> add44a01-5b1a-4949-af34-0fb4642726fc	c5cb4820-7fb7-4d82-abb3-176311159948	\N	\N	apollos_demo	system	people_tag
942384a942399
> add44a01-5b1a-4949-af34-0fb4642726fc	d3658c8f-6b06-4c5f-8b2e-c542cc609961	\N	\N	apollos_demo	system	people_tag

## 3-changes-7054c07fb1446933d32997b6b06fa59d52bfa553.csv

          
            table_name
            changed_fields
            client_query
            action
            row_data

            
              node_slug
              "node_id"=>"d574afbf-29f5-40ce-a2e3-7ad48eab3288"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', 'giving', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '56'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"08bdd56c-de93-4d48-bad4-75686372f08f","slug"=>"giving","node_id"=>"c139366d-85d1-4c55-a8c6-5c8b9526993a","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"c139366d-85d1-4c55-a8c6-5c8b9526993a"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', 'giving', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '55'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"08bdd56c-de93-4d48-bad4-75686372f08f","slug"=>"giving","node_id"=>"d574afbf-29f5-40ce-a2e3-7ad48eab3288","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"60386580-1e1a-4945-b74e-2d30b1de8e75"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', 'at-the-movies', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '45'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"bf30fdab-9c34-458e-aca0-15200f977c6e","slug"=>"at-the-movies","node_id"=>"834b7cf8-1467-44e7-b34e-1a106e8cf800","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"66ea4d38-559b-48a4-91fb-83b431438f5f"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', '1x8', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '44'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"a6ba2a73-ea77-42f3-aece-3eee4870b3f5","slug"=>"1x8","node_id"=>"48f177aa-58a3-4845-8209-d8677982dc75","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"85e38be6-35ce-48ed-a5b5-6b6367abe78a"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', 'potential', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '43'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"2ae778ef-3957-4480-b55a-ea62538b2010","slug"=>"potential","node_id"=>"c335f957-2d0d-420c-a0d2-0683f258b537","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"7e7e7e60-d87b-4b9c-858e-3808a0c87c93"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', 'arrival', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '41'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"fc8d5276-852d-4f1b-9b16-2585173433f8","slug"=>"arrival","node_id"=>"1c11e29d-bcf4-45ff-81b7-1e606081086d","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"834b7cf8-1467-44e7-b34e-1a106e8cf800"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', 'at-the-movies', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '29'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"bf30fdab-9c34-458e-aca0-15200f977c6e","slug"=>"at-the-movies","node_id"=>"60386580-1e1a-4945-b74e-2d30b1de8e75","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"48f177aa-58a3-4845-8209-d8677982dc75"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', '1x8', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '28'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"a6ba2a73-ea77-42f3-aece-3eee4870b3f5","slug"=>"1x8","node_id"=>"66ea4d38-559b-48a4-91fb-83b431438f5f","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"c335f957-2d0d-420c-a0d2-0683f258b537"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', 'potential', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '27'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"2ae778ef-3957-4480-b55a-ea62538b2010","slug"=>"potential","node_id"=>"85e38be6-35ce-48ed-a5b5-6b6367abe78a","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"1c11e29d-bcf4-45ff-81b7-1e606081086d"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:55:56.840761+00:00', '2025-02-05 02:55:56.840761+00:00', 'arrival', 'ContentItem', content_item.id
                FROM content_item
                WHERE origin_id = '25'
                AND origin_type = 'rock'
                ON CONFLICT (slug, church_slug)
                DO UPDATE SET node_id = EXCLUDED.node_id
                
              U
              "id"=>"fc8d5276-852d-4f1b-9b16-2585173433f8","slug"=>"arrival","node_id"=>"7e7e7e60-d87b-4b9c-858e-3808a0c87c93","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              content_tag
              
              
                DELETE
                FROM content_tag
                WHERE
                    content_item_id = '7528c696-ea31-4e6c-a8aa-9b94438105e2'
                    AND tag_id IN ('90098e19-1b60-4f1c-ae1a-ed7a2a088f60', '88677b4a-9161-41da-a193-f06116446f37', '5f392570-dbd5-4456-bbd5-ea2168d3fe60', '8560e7cd-e10e-48cc-a6cf-3b9279959012', '998a5b4f-ecc9-47aa-8a87-a03ac04ea513', '3069bb43-3dbd-42d4-b66e-39a1822dc1ce', 'd98a1935-3cc9-42d6-beaf-14ad47cf4a52')
                
              D
              "tag_id"=>"8560e7cd-e10e-48cc-a6cf-3b9279959012","church_slug"=>"apollos_demo","content_item_id"=>"7528c696-ea31-4e6c-a8aa-9b94438105e2"

            
              content_tag
              
              
                    INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
                    VALUES ('8560e7cd-e10e-48cc-a6cf-3b9279959012', '7528c696-ea31-4e6c-a8aa-9b94438105e2', NOW(), NOW())
                    
              I
              "tag_id"=>"8560e7cd-e10e-48cc-a6cf-3b9279959012","church_slug"=>"apollos_demo","content_item_id"=>"7528c696-ea31-4e6c-a8aa-9b94438105e2"

            
              content_tag
              
              
                DELETE
                FROM content_tag
                WHERE
                    content_item_id = '40db3fd4-13cc-4e03-8822-ce1404d110ca'
                    AND tag_id IN ('90098e19-1b60-4f1c-ae1a-ed7a2a088f60', '88677b4a-9161-41da-a193-f06116446f37', '5f392570-dbd5-4456-bbd5-ea2168d3fe60', '8560e7cd-e10e-48cc-a6cf-3b9279959012', '998a5b4f-ecc9-47aa-8a87-a03ac04ea513', '3069bb43-3dbd-42d4-b66e-39a1822dc1ce', 'd98a1935-3cc9-42d6-beaf-14ad47cf4a52')
                
              D
              "tag_id"=>"8560e7cd-e10e-48cc-a6cf-3b9279959012","church_slug"=>"apollos_demo","content_item_id"=>"40db3fd4-13cc-4e03-8822-ce1404d110ca"

            
              content_tag
              
              
                    INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
                    VALUES ('8560e7cd-e10e-48cc-a6cf-3b9279959012', '40db3fd4-13cc-4e03-8822-ce1404d110ca', NOW(), NOW())
                    
              I
              "tag_id"=>"8560e7cd-e10e-48cc-a6cf-3b9279959012","church_slug"=>"apollos_demo","content_item_id"=>"40db3fd4-13cc-4e03-8822-ce1404d110ca"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/22'
                          AND p.origin_id IN ('518', '517', '513', '512', '498', '90', '451', '132', '124', '131', '455', '474', '152', '13', '294', '452', '423', '205', '11', '425', '422', '421', '420', '414', '290', '349', '412', '408', '405', '389', '381', '379', '363', '358', '351', '348', '326', '299', '7', '94', '107', '282', '317', '232', '76', '291', '284', '122', '123', '214', '207', '30', '283', '35', '8', '5', '288', '281', '261', '248', '83', '77', '68', '36', '31', '16')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"add44a01-5b1a-4949-af34-0fb4642726fc","person_id"=>"88ea86d0-e38b-46b2-829b-2c6a9178cd78","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/22'
                          AND p.origin_id IN ('518', '517', '513', '512', '498', '90', '451', '132', '124', '131', '455', '474', '152', '13', '294', '452', '423', '205', '11', '425', '422', '421', '420', '414', '290', '349', '412', '408', '405', '389', '381', '379', '363', '358', '351', '348', '326', '299', '7', '94', '107', '282', '317', '232', '76', '291', '284', '122', '123', '214', '207', '30', '283', '35', '8', '5', '288', '281', '261', '248', '83', '77', '68', '36', '31', '16')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"add44a01-5b1a-4949-af34-0fb4642726fc","person_id"=>"188a71a2-05d3-4097-9bdc-ac578fa960c6","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/22'
                          AND p.origin_id IN ('518', '517', '513', '512', '498', '90', '451', '132', '124', '131', '455', '474', '152', '13', '294', '452', '423', '205', '11', '425', '422', '421', '420', '414', '290', '349', '412', '408', '405', '389', '381', '379', '363', '358', '351', '348', '326', '299', '7', '94', '107', '282', '317', '232', '76', '291', '284', '122', '123', '214', '207', '30', '283', '35', '8', '5', '288', '281', '261', '248', '83', '77', '68', '36', '31', '16')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"add44a01-5b1a-4949-af34-0fb4642726fc","person_id"=>"80d63c9a-f6a5-47ec-8944-7165eeac5d3b","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/22'
                          AND p.origin_id IN ('518', '517', '513', '512', '498', '90', '451', '132', '124', '131', '455', '474', '152', '13', '294', '452', '423', '205', '11', '425', '422', '421', '420', '414', '290', '349', '412', '408', '405', '389', '381', '379', '363', '358', '351', '348', '326', '299', '7', '94', '107', '282', '317', '232', '76', '291', '284', '122', '123', '214', '207', '30', '283', '35', '8', '5', '288', '281', '261', '248', '83', '77', '68', '36', '31', '16')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"add44a01-5b1a-4949-af34-0fb4642726fc","person_id"=>"3e08b8fa-23cb-4dae-8d1e-4719ae755916","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/22'
                          AND p.origin_id IN ('518', '517', '513', '512', '498', '90', '451', '132', '124', '131', '455', '474', '152', '13', '294', '452', '423', '205', '11', '425', '422', '421', '420', '414', '290', '349', '412', '408', '405', '389', '381', '379', '363', '358', '351', '348', '326', '299', '7', '94', '107', '282', '317', '232', '76', '291', '284', '122', '123', '214', '207', '30', '283', '35', '8', '5', '288', '281', '261', '248', '83', '77', '68', '36', '31', '16')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"add44a01-5b1a-4949-af34-0fb4642726fc","person_id"=>"d3658c8f-6b06-4c5f-8b2e-c542cc609961","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/22'
                          AND p.origin_id IN ('518', '517', '513', '512', '498', '90', '451', '132', '124', '131', '455', '474', '152', '13', '294', '452', '423', '205', '11', '425', '422', '421', '420', '414', '290', '349', '412', '408', '405', '389', '381', '379', '363', '358', '351', '348', '326', '299', '7', '94', '107', '282', '317', '232', '76', '291', '284', '122', '123', '214', '207', '30', '283', '35', '8', '5', '288', '281', '261', '248', '83', '77', '68', '36', '31', '16')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"add44a01-5b1a-4949-af34-0fb4642726fc","person_id"=>"c5cb4820-7fb7-4d82-abb3-176311159948","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/23'
                          AND p.origin_id IN ('530', '529', '525', '523', '522', '521', '520', '519', '518', '517', '514', '512', '506', '499', '498', '451', '491', '490', '489', '132', '124', '131', '455', '475', '474', '473', '213', '462', '461', '457', '152', '460', '459', '13', '453', '294', '15', '452', '449', '444', '443', '442', '441', '440', '439', '438', '437', '436', '423', '268', '410', '435', '434', '433', '432', '431', '430', '429', '428', '427', '205', '11', '426', '425', '424', '422', '421', '420', '312', '325', '334', '336', '419', '418', '417', '361', '304', '290', '324', '349', '412', '360', '157', '158', '71', '407', '406', '405', '404', '292', '402', '401', '400', '398', '397', '396', '395', '394', '393', '392', '391', '81', '389', '270', '388', '387', '382', '381', '345', '375', '374', '373', '372', '371', '370', '369', '367', '365', '364', '363', '362', '358', '355', '354', '351', '350', '347', '346', '344', '343', '342', '340', '339', '338', '333', '332', '330', '328', '326', '322', '321', '320', '319', '305', '301', '299', '302', '94', '101', '107', '282', '317', '316', '280', '232', '76', '296', '237', '291', '285', '284', '150', '123', '140', '115', '84', '86', '211', '82', '214', '207', '154', '295', '30', '283', '35', '165', '5', '10', '308', '306', '298', '297', '286', '281', '9', '261', '258', '249', '248', '246', '244', '241', '231', '230', '216', '168', '166', '163', '138', '116', '103', '95', '93', '92', '91', '89', '85', '83', '80', '79', '77', '75', '74', '70', '69', '68', '36', '34', '31', '21', '20', '17', '318', '311', '310', '309')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","person_id"=>"ce9ad1bc-0fcc-437b-8a7f-0e9694a007a1","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/23'
                          AND p.origin_id IN ('530', '529', '525', '523', '522', '521', '520', '519', '518', '517', '514', '512', '506', '499', '498', '451', '491', '490', '489', '132', '124', '131', '455', '475', '474', '473', '213', '462', '461', '457', '152', '460', '459', '13', '453', '294', '15', '452', '449', '444', '443', '442', '441', '440', '439', '438', '437', '436', '423', '268', '410', '435', '434', '433', '432', '431', '430', '429', '428', '427', '205', '11', '426', '425', '424', '422', '421', '420', '312', '325', '334', '336', '419', '418', '417', '361', '304', '290', '324', '349', '412', '360', '157', '158', '71', '407', '406', '405', '404', '292', '402', '401', '400', '398', '397', '396', '395', '394', '393', '392', '391', '81', '389', '270', '388', '387', '382', '381', '345', '375', '374', '373', '372', '371', '370', '369', '367', '365', '364', '363', '362', '358', '355', '354', '351', '350', '347', '346', '344', '343', '342', '340', '339', '338', '333', '332', '330', '328', '326', '322', '321', '320', '319', '305', '301', '299', '302', '94', '101', '107', '282', '317', '316', '280', '232', '76', '296', '237', '291', '285', '284', '150', '123', '140', '115', '84', '86', '211', '82', '214', '207', '154', '295', '30', '283', '35', '165', '5', '10', '308', '306', '298', '297', '286', '281', '9', '261', '258', '249', '248', '246', '244', '241', '231', '230', '216', '168', '166', '163', '138', '116', '103', '95', '93', '92', '91', '89', '85', '83', '80', '79', '77', '75', '74', '70', '69', '68', '36', '34', '31', '21', '20', '17', '318', '311', '310', '309')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","person_id"=>"8a183ada-e706-4b1a-b5a2-d24eeccb1256","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/23'
                          AND p.origin_id IN ('530', '529', '525', '523', '522', '521', '520', '519', '518', '517', '514', '512', '506', '499', '498', '451', '491', '490', '489', '132', '124', '131', '455', '475', '474', '473', '213', '462', '461', '457', '152', '460', '459', '13', '453', '294', '15', '452', '449', '444', '443', '442', '441', '440', '439', '438', '437', '436', '423', '268', '410', '435', '434', '433', '432', '431', '430', '429', '428', '427', '205', '11', '426', '425', '424', '422', '421', '420', '312', '325', '334', '336', '419', '418', '417', '361', '304', '290', '324', '349', '412', '360', '157', '158', '71', '407', '406', '405', '404', '292', '402', '401', '400', '398', '397', '396', '395', '394', '393', '392', '391', '81', '389', '270', '388', '387', '382', '381', '345', '375', '374', '373', '372', '371', '370', '369', '367', '365', '364', '363', '362', '358', '355', '354', '351', '350', '347', '346', '344', '343', '342', '340', '339', '338', '333', '332', '330', '328', '326', '322', '321', '320', '319', '305', '301', '299', '302', '94', '101', '107', '282', '317', '316', '280', '232', '76', '296', '237', '291', '285', '284', '150', '123', '140', '115', '84', '86', '211', '82', '214', '207', '154', '295', '30', '283', '35', '165', '5', '10', '308', '306', '298', '297', '286', '281', '9', '261', '258', '249', '248', '246', '244', '241', '231', '230', '216', '168', '166', '163', '138', '116', '103', '95', '93', '92', '91', '89', '85', '83', '80', '79', '77', '75', '74', '70', '69', '68', '36', '34', '31', '21', '20', '17', '318', '311', '310', '309')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","person_id"=>"188a71a2-05d3-4097-9bdc-ac578fa960c6","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/23'
                          AND p.origin_id IN ('530', '529', '525', '523', '522', '521', '520', '519', '518', '517', '514', '512', '506', '499', '498', '451', '491', '490', '489', '132', '124', '131', '455', '475', '474', '473', '213', '462', '461', '457', '152', '460', '459', '13', '453', '294', '15', '452', '449', '444', '443', '442', '441', '440', '439', '438', '437', '436', '423', '268', '410', '435', '434', '433', '432', '431', '430', '429', '428', '427', '205', '11', '426', '425', '424', '422', '421', '420', '312', '325', '334', '336', '419', '418', '417', '361', '304', '290', '324', '349', '412', '360', '157', '158', '71', '407', '406', '405', '404', '292', '402', '401', '400', '398', '397', '396', '395', '394', '393', '392', '391', '81', '389', '270', '388', '387', '382', '381', '345', '375', '374', '373', '372', '371', '370', '369', '367', '365', '364', '363', '362', '358', '355', '354', '351', '350', '347', '346', '344', '343', '342', '340', '339', '338', '333', '332', '330', '328', '326', '322', '321', '320', '319', '305', '301', '299', '302', '94', '101', '107', '282', '317', '316', '280', '232', '76', '296', '237', '291', '285', '284', '150', '123', '140', '115', '84', '86', '211', '82', '214', '207', '154', '295', '30', '283', '35', '165', '5', '10', '308', '306', '298', '297', '286', '281', '9', '261', '258', '249', '248', '246', '244', '241', '231', '230', '216', '168', '166', '163', '138', '116', '103', '95', '93', '92', '91', '89', '85', '83', '80', '79', '77', '75', '74', '70', '69', '68', '36', '34', '31', '21', '20', '17', '318', '311', '310', '309')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","person_id"=>"80d63c9a-f6a5-47ec-8944-7165eeac5d3b","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/23'
                          AND p.origin_id IN ('530', '529', '525', '523', '522', '521', '520', '519', '518', '517', '514', '512', '506', '499', '498', '451', '491', '490', '489', '132', '124', '131', '455', '475', '474', '473', '213', '462', '461', '457', '152', '460', '459', '13', '453', '294', '15', '452', '449', '444', '443', '442', '441', '440', '439', '438', '437', '436', '423', '268', '410', '435', '434', '433', '432', '431', '430', '429', '428', '427', '205', '11', '426', '425', '424', '422', '421', '420', '312', '325', '334', '336', '419', '418', '417', '361', '304', '290', '324', '349', '412', '360', '157', '158', '71', '407', '406', '405', '404', '292', '402', '401', '400', '398', '397', '396', '395', '394', '393', '392', '391', '81', '389', '270', '388', '387', '382', '381', '345', '375', '374', '373', '372', '371', '370', '369', '367', '365', '364', '363', '362', '358', '355', '354', '351', '350', '347', '346', '344', '343', '342', '340', '339', '338', '333', '332', '330', '328', '326', '322', '321', '320', '319', '305', '301', '299', '302', '94', '101', '107', '282', '317', '316', '280', '232', '76', '296', '237', '291', '285', '284', '150', '123', '140', '115', '84', '86', '211', '82', '214', '207', '154', '295', '30', '283', '35', '165', '5', '10', '308', '306', '298', '297', '286', '281', '9', '261', '258', '249', '248', '246', '244', '241', '231', '230', '216', '168', '166', '163', '138', '116', '103', '95', '93', '92', '91', '89', '85', '83', '80', '79', '77', '75', '74', '70', '69', '68', '36', '34', '31', '21', '20', '17', '318', '311', '310', '309')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","person_id"=>"3e08b8fa-23cb-4dae-8d1e-4719ae755916","church_slug"=>"apollos_demo"

            
              people_tag
              
              
                        INSERT INTO people_tag (tag_id, person_id, created_at, updated_at)
                        SELECT t.id,
                               p.id,
                               NOW(),
                               NOW()
                        FROM people p,
                             tag t
                        WHERE t.origin_id = 'dataview/23'
                          AND p.origin_id IN ('530', '529', '525', '523', '522', '521', '520', '519', '518', '517', '514', '512', '506', '499', '498', '451', '491', '490', '489', '132', '124', '131', '455', '475', '474', '473', '213', '462', '461', '457', '152', '460', '459', '13', '453', '294', '15', '452', '449', '444', '443', '442', '441', '440', '439', '438', '437', '436', '423', '268', '410', '435', '434', '433', '432', '431', '430', '429', '428', '427', '205', '11', '426', '425', '424', '422', '421', '420', '312', '325', '334', '336', '419', '418', '417', '361', '304', '290', '324', '349', '412', '360', '157', '158', '71', '407', '406', '405', '404', '292', '402', '401', '400', '398', '397', '396', '395', '394', '393', '392', '391', '81', '389', '270', '388', '387', '382', '381', '345', '375', '374', '373', '372', '371', '370', '369', '367', '365', '364', '363', '362', '358', '355', '354', '351', '350', '347', '346', '344', '343', '342', '340', '339', '338', '333', '332', '330', '328', '326', '322', '321', '320', '319', '305', '301', '299', '302', '94', '101', '107', '282', '317', '316', '280', '232', '76', '296', '237', '291', '285', '284', '150', '123', '140', '115', '84', '86', '211', '82', '214', '207', '154', '295', '30', '283', '35', '165', '5', '10', '308', '306', '298', '297', '286', '281', '9', '261', '258', '249', '248', '246', '244', '241', '231', '230', '216', '168', '166', '163', '138', '116', '103', '95', '93', '92', '91', '89', '85', '83', '80', '79', '77', '75', '74', '70', '69', '68', '36', '34', '31', '21', '20', '17', '318', '311', '310', '309')
                        ON CONFLICT (tag_id, person_id, type) DO NOTHING
                    
              I
              "type"=>"system","tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","person_id"=>"d1e93a01-a3a9-435d-ae1e-be1327a75e4b","church_slug"=>"apollos_demo"

            
              content_tag
              
              
        DELETE FROM content_tag ct
            USING content_item c, tag t
            WHERE t.type = 'Persona'
                AND t.id = ct.tag_id
                AND c.id = ct.content_item_id;
        
              D
              "tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","church_slug"=>"apollos_demo","content_item_id"=>"af4bb25a-79d3-4e19-8bff-d55fb5632873"

            
              content_tag
              
              
            INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
            SELECT t.id,
                   i.id,
                   NOW(),
                   NOW()
            FROM tag t,
                 content_item i
            WHERE t.data ->> 'guid' = '2509783b-f0d4-4492-a4bc-747cfcc9b1f8'
              AND i.origin_id = '73'
            ON CONFLICT (tag_id, content_item_id) DO NOTHING
        
              I
              "tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","church_slug"=>"apollos_demo","content_item_id"=>"af4bb25a-79d3-4e19-8bff-d55fb5632873"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"cc736525-3229-4599-bf08-5d246544e9b9","event_id"=>"6ee1dcfe-4eb5-424e-961f-01129d4ca7ba","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"f1459a64-bef0-4bff-af41-d067ed4ed0e5","event_id"=>"6ee1dcfe-4eb5-424e-961f-01129d4ca7ba","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"0d8045e3-50b3-495d-aaf9-f38a4acf1087","event_id"=>"6ee1dcfe-4eb5-424e-961f-01129d4ca7ba","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"cc736525-3229-4599-bf08-5d246544e9b9","event_id"=>"98671546-ce6d-47df-b89e-3ad5feece604","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"f1459a64-bef0-4bff-af41-d067ed4ed0e5","event_id"=>"98671546-ce6d-47df-b89e-3ad5feece604","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"8fc66073-c214-42df-9635-b87ee3d1aed2","event_id"=>"98671546-ce6d-47df-b89e-3ad5feece604","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"0d8045e3-50b3-495d-aaf9-f38a4acf1087","event_id"=>"98671546-ce6d-47df-b89e-3ad5feece604","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"cc736525-3229-4599-bf08-5d246544e9b9","event_id"=>"3b0f0e23-5ee9-4828-a844-c0c75385a156","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"0d8045e3-50b3-495d-aaf9-f38a4acf1087","event_id"=>"3b0f0e23-5ee9-4828-a844-c0c75385a156","church_slug"=>"apollos_demo"

            
              event_tag
              
              
                DELETE FROM event_tag
                WHERE tag_id IN (
                        SELECT
                            id
                        FROM
                            tag
                        WHERE
                            origin_type = 'rock'
                            AND origin_id LIKE 'eventAudience-%')
                
              D
              "tag_id"=>"8102de79-55ee-4c72-a820-93be89506cca","event_id"=>"3b0f0e23-5ee9-4828-a844-c0c75385a156","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-148' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^2(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"cc736525-3229-4599-bf08-5d246544e9b9","event_id"=>"6ee1dcfe-4eb5-424e-961f-01129d4ca7ba","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-151' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^2(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"f1459a64-bef0-4bff-af41-d067ed4ed0e5","event_id"=>"6ee1dcfe-4eb5-424e-961f-01129d4ca7ba","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-24' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^2(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"0d8045e3-50b3-495d-aaf9-f38a4acf1087","event_id"=>"6ee1dcfe-4eb5-424e-961f-01129d4ca7ba","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-148' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^3(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"cc736525-3229-4599-bf08-5d246544e9b9","event_id"=>"98671546-ce6d-47df-b89e-3ad5feece604","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-151' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^3(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"f1459a64-bef0-4bff-af41-d067ed4ed0e5","event_id"=>"98671546-ce6d-47df-b89e-3ad5feece604","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-152' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^3(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"8fc66073-c214-42df-9635-b87ee3d1aed2","event_id"=>"98671546-ce6d-47df-b89e-3ad5feece604","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-24' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^3(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"0d8045e3-50b3-495d-aaf9-f38a4acf1087","event_id"=>"98671546-ce6d-47df-b89e-3ad5feece604","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-148' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^4(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"cc736525-3229-4599-bf08-5d246544e9b9","event_id"=>"3b0f0e23-5ee9-4828-a844-c0c75385a156","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-24' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^4(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"0d8045e3-50b3-495d-aaf9-f38a4acf1087","event_id"=>"3b0f0e23-5ee9-4828-a844-c0c75385a156","church_slug"=>"apollos_demo"

            
              event_tag
              
              
            INSERT INTO event_tag (event_id, tag_id, created_at, updated_at)
            SELECT event.id, tag.id, tag.created_at, tag.updated_at
            FROM event
            INNER JOIN tag ON tag.origin_id = 'eventAudience-147' AND tag.origin_type = 'rock'
            WHERE event.origin_id ~ '^4(-\d+)?$' AND event.origin_type = 'rock'
            ON CONFLICT (tag_id, event_id) DO NOTHING
            
              I
              "tag_id"=>"8102de79-55ee-4c72-a820-93be89506cca","event_id"=>"3b0f0e23-5ee9-4828-a844-c0c75385a156","church_slug"=>"apollos_demo"

            
              community_members
              
              
                                insert into community_members (community_id, person_id, status, origin_type, origin_id, updated_at)
                                select c.id,
                                       p.id,
                                       'PENDING',
                                       'rock',
                                       '783',
                                       '2025-02-05T02:56:38.158061+00:00'::timestamptz
                                from people p
                                JOIN community c ON c.origin_id = '336' AND p.origin_id = '5'
                                ON CONFLICT (community_id,person_id,origin_type,origin_id,church_slug) DO NOTHING
                            
              I
              "id"=>"10c003b2-81cb-4784-b2a7-09126adda221","status"=>"PENDING","is_host"=>NULL,"origin_id"=>"783","person_id"=>"3e08b8fa-23cb-4dae-8d1e-4719ae755916","apollos_id"=>"CommunityMember:10c003b2-81cb-4784-b2a7-09126adda221","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"CommunityMember","community_id"=>"d1c03319-fb2e-44bb-b060-c7dec134ef4c"

            
              community_members
              
              
                                insert into community_members (community_id, person_id, status, origin_type, origin_id, updated_at)
                                select c.id,
                                       p.id,
                                       'PENDING',
                                       'rock',
                                       '866',
                                       '2025-02-05T02:56:38.158061+00:00'::timestamptz
                                from people p
                                JOIN community c ON c.origin_id = '923' AND p.origin_id = '13'
                                ON CONFLICT (community_id,person_id,origin_type,origin_id,church_slug) DO NOTHING
                            
              I
              "id"=>"4c1287b0-cc88-43b5-9e14-cc89029516f7","status"=>"PENDING","is_host"=>NULL,"origin_id"=>"866","person_id"=>"80d63c9a-f6a5-47ec-8944-7165eeac5d3b","apollos_id"=>"CommunityMember:4c1287b0-cc88-43b5-9e14-cc89029516f7","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"CommunityMember","community_id"=>"2d2c23fc-1301-483f-85da-7870b235eb23"

            
              community_members
              
              
                                insert into community_members (community_id, person_id, status, origin_type, origin_id, updated_at)
                                select c.id,
                                       p.id,
                                       'PENDING',
                                       'rock',
                                       '892',
                                       '2025-02-05T02:56:38.158061+00:00'::timestamptz
                                from people p
                                JOIN community c ON c.origin_id = '946' AND p.origin_id = '13'
                                ON CONFLICT (community_id,person_id,origin_type,origin_id,church_slug) DO NOTHING
                            
              I
              "id"=>"d6a53bc5-534e-4863-a9b8-19e8b8d64618","status"=>"PENDING","is_host"=>NULL,"origin_id"=>"892","person_id"=>"80d63c9a-f6a5-47ec-8944-7165eeac5d3b","apollos_id"=>"CommunityMember:d6a53bc5-534e-4863-a9b8-19e8b8d64618","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"CommunityMember","community_id"=>"f9cbd6ff-c5d8-4a7d-8beb-31a881fbed26"

            
              community_members
              "is_host"=>"t"
              
                                update community_members as cm
                                set is_host = true, updated_at = '2025-02-05T02:56:38.158061+00:00'::timestamptz
                                from people p
                                join community c on c.origin_id = '336' and p.origin_id = '5'
                                where cm.person_id = p.id and cm.community_id = c.id
                            
              U
              "id"=>"10c003b2-81cb-4784-b2a7-09126adda221","status"=>"PENDING","is_host"=>NULL,"origin_id"=>"783","person_id"=>"3e08b8fa-23cb-4dae-8d1e-4719ae755916","apollos_id"=>"CommunityMember:10c003b2-81cb-4784-b2a7-09126adda221","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"CommunityMember","community_id"=>"d1c03319-fb2e-44bb-b060-c7dec134ef4c"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('cacfee28-be48-4be2-9784-daa04076490c')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"9898d6b8-8f33-488c-9c68-8a27819e2cec","church_slug"=>"apollos_demo","content_item_id"=>"cacfee28-be48-4be2-9784-daa04076490c"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('cacfee28-be48-4be2-9784-daa04076490c','2025-02-05T02:56:47.125937+00:00'::timestamptz,'9898d6b8-8f33-488c-9c68-8a27819e2cec','2025-02-05T02:56:47.125937+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"9898d6b8-8f33-488c-9c68-8a27819e2cec","church_slug"=>"apollos_demo","content_item_id"=>"cacfee28-be48-4be2-9784-daa04076490c"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68','c561c777-4336-42b6-bcdc-d27ff08fcd16','0e96c8f9-506e-47bb-b8da-0e6ebc9c0d72','94d9c721-e490-44d1-a3ae-5a0804b15a20','47c64226-6936-4bf4-9349-b658f1e7af8d')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"9a931a9e-11f0-4dde-852d-d017e6044806","church_slug"=>"apollos_demo","content_item_id"=>"7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68','c561c777-4336-42b6-bcdc-d27ff08fcd16','0e96c8f9-506e-47bb-b8da-0e6ebc9c0d72','94d9c721-e490-44d1-a3ae-5a0804b15a20','47c64226-6936-4bf4-9349-b658f1e7af8d')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"52cf15f5-1afa-4f14-82d6-151e58e92b60","church_slug"=>"apollos_demo","content_item_id"=>"7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68','c561c777-4336-42b6-bcdc-d27ff08fcd16','0e96c8f9-506e-47bb-b8da-0e6ebc9c0d72','94d9c721-e490-44d1-a3ae-5a0804b15a20','47c64226-6936-4bf4-9349-b658f1e7af8d')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"9a931a9e-11f0-4dde-852d-d017e6044806","church_slug"=>"apollos_demo","content_item_id"=>"94d9c721-e490-44d1-a3ae-5a0804b15a20"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68','c561c777-4336-42b6-bcdc-d27ff08fcd16','0e96c8f9-506e-47bb-b8da-0e6ebc9c0d72','94d9c721-e490-44d1-a3ae-5a0804b15a20','47c64226-6936-4bf4-9349-b658f1e7af8d')
                    AND content_tag.tag_id = tag.id
                    AND (tag.origin_id like 'tag-%' or tag.origin_id like 'category-%')
                    AND tag.origin_type = 'wordpress'
                
              D
              "tag_id"=>"88b6daf2-1bf4-45e4-ada8-e232f09f0bd9","church_slug"=>"apollos_demo","content_item_id"=>"94d9c721-e490-44d1-a3ae-5a0804b15a20"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68','2025-02-05T02:56:47.125937+00:00'::timestamptz,'9a931a9e-11f0-4dde-852d-d017e6044806','2025-02-05T02:56:47.125937+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"9a931a9e-11f0-4dde-852d-d017e6044806","church_slug"=>"apollos_demo","content_item_id"=>"7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68','2025-02-05T02:56:47.125937+00:00'::timestamptz,'52cf15f5-1afa-4f14-82d6-151e58e92b60','2025-02-05T02:56:47.125937+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"52cf15f5-1afa-4f14-82d6-151e58e92b60","church_slug"=>"apollos_demo","content_item_id"=>"7cadbbd4-5b5e-4d85-9e1f-698ff3c4ea68"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('94d9c721-e490-44d1-a3ae-5a0804b15a20','2025-02-05T02:56:47.125937+00:00'::timestamptz,'9a931a9e-11f0-4dde-852d-d017e6044806','2025-02-05T02:56:47.125937+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"9a931a9e-11f0-4dde-852d-d017e6044806","church_slug"=>"apollos_demo","content_item_id"=>"94d9c721-e490-44d1-a3ae-5a0804b15a20"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('94d9c721-e490-44d1-a3ae-5a0804b15a20','2025-02-05T02:56:47.125937+00:00'::timestamptz,'88b6daf2-1bf4-45e4-ada8-e232f09f0bd9','2025-02-05T02:56:47.125937+00:00'::timestamptz) ON CONFLICT (tag_id, content_item_id) DO UPDATE SET created_at = excluded.created_at, updated_at = excluded.updated_at
              I
              "tag_id"=>"88b6daf2-1bf4-45e4-ada8-e232f09f0bd9","church_slug"=>"apollos_demo","content_item_id"=>"94d9c721-e490-44d1-a3ae-5a0804b15a20"

            
              tag
              
              INSERT INTO tag
             (name, origin_id, origin_type, apollos_type, created_at, updated_at, church_slug)
                             SELECT 'Apollos Test Campus', 'campus-1', 'touchpoint', 'Tag' , NOW(), NOW(), 'apollos_demo'
                            WHERE NOT EXISTS (SELECT id FROM tag WHERE origin_id='campus-1' AND origin_type='touchpoint'); 
              I
              "id"=>"c0ea6c10-780f-4397-a4d9-d6ebd3562d61","data"=>NULL,"name"=>"Apollos Test Campus","type"=>NULL,"origin_id"=>"campus-1","apollos_id"=>"Tag:c0ea6c10-780f-4397-a4d9-d6ebd3562d61","church_slug"=>"apollos_demo","origin_type"=>"touchpoint","apollos_type"=>"Tag"

            
              tag
              
              
                DELETE FROM tag
                WHERE origin_id NOT IN ('7f56d1d0-c576-41d1-b907-0d1bb68f43a8', 'eee06dd1-35d2-40e3-9c77-15e9d0113edd', 'a4bfbfa7-91be-414f-b00e-3bca9619a989', '3f1dca9e-814f-49b7-a0bb-508d8769420a', 'e46c046d-c13a-428d-b117-509c8cd52cce', '1aec42d8-56cf-4123-8b4c-560fe8930b74', '4898a84d-bda0-4420-99c7-57294d4bbb1e', '398b9ba1-f7c8-4717-a3a4-5ff7931baa58', 'b8e212d3-6a0e-4de7-988f-691117df1780', 'd087cb55-4bc7-4599-baa3-6a3fc20327a9', '1f730f25-2186-4335-b1b2-6fff82d70f38', '48e6b5ac-7fa8-46a0-a87f-709732590a6e', 'e0ec1005-427d-4f6b-97f8-84b51d57f5fd', '8887f5f6-8bd2-4612-9c51-88f9943fc91c', 'fda20220-df02-4fab-b463-8bd6bf549d7b', '7394ce83-47a2-4464-a847-aa848b25abd9', 'b6f066bb-840c-4c46-9d9f-acbbe6128289', '3d864d5c-0b6a-4253-984b-ae989171f881', '2c145e9d-5c97-493b-af22-b40883a6095f', '877300b6-bb34-4898-bd00-bb31f1019a6d', '785ac91d-8328-4f09-b1b1-bbf1aaa25cee', 'ef1de5e4-12fb-48b4-bf70-be19cefd9b14', '4db89ecb-bea1-4e6f-b53f-c8bbc9cdd8e7', 'acdfcf75-6ca0-4e54-87ca-daf9acac5714', '3facca1e-a661-4bbd-92b0-dd3b8c1f3cda', '4ae2791c-c52f-41fb-b762-dfd74efda9ac', '552ba5ed-4d5d-410b-b0a7-e103f075fc48', 'be81fde4-c38c-4c1c-9a3f-eafc30bc35ac', '06a58409-b98f-468a-a7d0-ecbcceb8ec77', '950ad469-153f-4bc0-9fc7-f71bf4237b60')
                    AND origin_id LIKE '%'
                    AND origin_type = 'touchpoint'
                
              D
              "id"=>"c0ea6c10-780f-4397-a4d9-d6ebd3562d61","data"=>NULL,"name"=>"Apollos Test Campus","type"=>NULL,"origin_id"=>"campus-1","apollos_id"=>"Tag:c0ea6c10-780f-4397-a4d9-d6ebd3562d61","church_slug"=>"apollos_demo","origin_type"=>"touchpoint","apollos_type"=>"Tag"

            
              campus
              "image_id"=>"0db0e64f-e5f6-4da3-9f77-480975ac2ba3"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = 'fc0a6550-c603-483d-90b9-bf6a54644895' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"fc0a6550-c603-483d-90b9-bf6a54644895","city"=>NULL,"name"=>"Apollos Test Campus","state"=>NULL,"active"=>"t","digital"=>"f","street1"=>NULL,"street2"=>NULL,"image_id"=>NULL,"latitude"=>NULL,"image_url"=>NULL,"longitude"=>NULL,"origin_id"=>"1","apollos_id"=>"Campus:fc0a6550-c603-483d-90b9-bf6a54644895","church_slug"=>"apollos_demo","origin_type"=>"touchpoint","postal_code"=>NULL,"apollos_type"=>"Campus"

            
              campus
              "image_id"=>"0db0e64f-e5f6-4da3-9f77-480975ac2ba3"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '2182cf87-aa35-4557-87ad-3cb573e6fc3e' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"2182cf87-aa35-4557-87ad-3cb573e6fc3e","city"=>"","name"=>"Friends & Internet Campus","state"=>"","active"=>"t","digital"=>NULL,"street1"=>"","street2"=>"","image_id"=>NULL,"latitude"=>NULL,"image_url"=>NULL,"longitude"=>NULL,"origin_id"=>"2","apollos_id"=>"Campus:2182cf87-aa35-4557-87ad-3cb573e6fc3e","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"

            
              campus
              "image_id"=>"0db0e64f-e5f6-4da3-9f77-480975ac2ba3"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '38b7dcca-33be-4b94-8afa-a9b17bb9c458' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"38b7dcca-33be-4b94-8afa-a9b17bb9c458","city"=>"","name"=>"Churchwide Activities","state"=>"","active"=>"t","digital"=>NULL,"street1"=>"","street2"=>"","image_id"=>NULL,"latitude"=>NULL,"image_url"=>NULL,"longitude"=>NULL,"origin_id"=>"4","apollos_id"=>"Campus:38b7dcca-33be-4b94-8afa-a9b17bb9c458","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"

            
              people_tag
              "person_id"=>"c1984d60-5815-49b5-bf49-7076e5299d52"
              
                BEGIN TRANSACTION;
                    -- We need to pull the people tags over to the correct person
                    -- Sometimes, someone already has a tag, so we can skip it
                    UPDATE people_tag SET person_id = 'c1984d60-5815-49b5-bf49-7076e5299d52' WHERE person_id = 'd91abde2-d722-4551-8b1f-9f15eb9e38b4' and NOT EXISTS (SELECT 1 FROM people_tag WHERE person_id = 'c1984d60-5815-49b5-bf49-7076e5299d52' and tag_id = people_tag.tag_id);
                    -- Now we can delete the old person
                    DELETE FROM people WHERE id = 'd91abde2-d722-4551-8b1f-9f15eb9e38b4' AND apollos_user is false;
                    -- And update our person to have the correct origin_id
                    UPDATE people SET origin_id = '150' WHERE id = 'c1984d60-5815-49b5-bf49-7076e5299d52';
                COMMIT;
                
              U
              "type"=>"system","tag_id"=>"a0115ac9-bf16-4863-ae28-8816fbadb9d9","person_id"=>"d91abde2-d722-4551-8b1f-9f15eb9e38b4","church_slug"=>"apollos_demo"

            
              people
              
              
                BEGIN TRANSACTION;
                    -- We need to pull the people tags over to the correct person
                    -- Sometimes, someone already has a tag, so we can skip it
                    UPDATE people_tag SET person_id = 'c1984d60-5815-49b5-bf49-7076e5299d52' WHERE person_id = 'd91abde2-d722-4551-8b1f-9f15eb9e38b4' and NOT EXISTS (SELECT 1 FROM people_tag WHERE person_id = 'c1984d60-5815-49b5-bf49-7076e5299d52' and tag_id = people_tag.tag_id);
                    -- Now we can delete the old person
                    DELETE FROM people WHERE id = 'd91abde2-d722-4551-8b1f-9f15eb9e38b4' AND apollos_user is false;
                    -- And update our person to have the correct origin_id
                    UPDATE people SET origin_id = '150' WHERE id = 'c1984d60-5815-49b5-bf49-7076e5299d52';
                COMMIT;
                
              D
              "id"=>"d91abde2-d722-4551-8b1f-9f15eb9e38b4","email"=>NULL,"phone"=>NULL,"gender"=>"MALE","campus_id"=>NULL,"last_name"=>"Wilson","origin_id"=>"150","apollos_id"=>"Person:d91abde2-d722-4551-8b1f-9f15eb9e38b4","birth_date"=>NULL,"first_name"=>"Vincent","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"Person","apollos_user"=>"f","profile_image_url"=>NULL

            
              people
              "origin_id"=>"150"
              
                BEGIN TRANSACTION;
                    -- We need to pull the people tags over to the correct person
                    -- Sometimes, someone already has a tag, so we can skip it
                    UPDATE people_tag SET person_id = 'c1984d60-5815-49b5-bf49-7076e5299d52' WHERE person_id = 'd91abde2-d722-4551-8b1f-9f15eb9e38b4' and NOT EXISTS (SELECT 1 FROM people_tag WHERE person_id = 'c1984d60-5815-49b5-bf49-7076e5299d52' and tag_id = people_tag.tag_id);
                    -- Now we can delete the old person
                    DELETE FROM people WHERE id = 'd91abde2-d722-4551-8b1f-9f15eb9e38b4' AND apollos_user is false;
                    -- And update our person to have the correct origin_id
                    UPDATE people SET origin_id = '150' WHERE id = 'c1984d60-5815-49b5-bf49-7076e5299d52';
                COMMIT;
                
              U
              "id"=>"c1984d60-5815-49b5-bf49-7076e5299d52","email"=>NULL,"phone"=>NULL,"gender"=>"MALE","campus_id"=>NULL,"last_name"=>NULL,"origin_id"=>"163","apollos_id"=>"Person:c1984d60-5815-49b5-bf49-7076e5299d52","birth_date"=>NULL,"first_name"=>NULL,"church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"Person","apollos_user"=>"f","profile_image_url"=>NULL

            
              people
              "last_name"=>"Wilson","first_name"=>"Vincent"
              INSERT INTO people (apollos_type, birth_date, campus_id, email, first_name, gender, last_name, origin_id, origin_type, profile_image_url, updated_at) VALUES ('Person',NULL,NULL,NULL,'Vincent','MALE','Wilson',150,'rock',NULL,'2025-02-05T02:53:51.440244+00:00'::timestamptz) ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, birth_date = excluded.birth_date, campus_id = excluded.campus_id, email = excluded.email, first_name = excluded.first_name, gender = excluded.gender, last_name = excluded.last_name, profile_image_url = excluded.profile_image_url, updated_at = excluded.updated_at
              U
              "id"=>"d91abde2-d722-4551-8b1f-9f15eb9e38b4","email"=>NULL,"phone"=>NULL,"gender"=>"MALE","campus_id"=>NULL,"last_name"=>NULL,"origin_id"=>"150","apollos_id"=>"Person:d91abde2-d722-4551-8b1f-9f15eb9e38b4","birth_date"=>NULL,"first_name"=>NULL,"church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"Person","apollos_user"=>"f","profile_image_url"=>NULL

            
              people
              
              INSERT INTO people (apollos_type, birth_date, campus_id, email, first_name, gender, last_name, origin_id, origin_type, profile_image_url, updated_at) VALUES ('Person',NULL,NULL,NULL,NULL,'MALE',NULL,163,'rock',NULL,'2025-02-05T02:53:51.440244+00:00'::timestamptz) ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, birth_date = excluded.birth_date, campus_id = excluded.campus_id, email = excluded.email, first_name = excluded.first_name, gender = excluded.gender, last_name = excluded.last_name, profile_image_url = excluded.profile_image_url, updated_at = excluded.updated_at
              I
              "id"=>"c1984d60-5815-49b5-bf49-7076e5299d52","email"=>NULL,"phone"=>NULL,"gender"=>"MALE","campus_id"=>NULL,"last_name"=>NULL,"origin_id"=>"163","apollos_id"=>"Person:c1984d60-5815-49b5-bf49-7076e5299d52","birth_date"=>NULL,"first_name"=>NULL,"church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"Person","apollos_user"=>"f","profile_image_url"=>NULL

            
              media
              "node_id"=>"fc0a6550-c603-483d-90b9-bf6a54644895"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2025-02-05T02:53:51.440244+00:00'::timestamptz,'2025-02-05T02:53:51.440244+00:00'::timestamptz,'fc0a6550-c603-483d-90b9-bf6a54644895','Campus','IMAGE','https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb','campusimage-71','rock') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url
              U
              "id"=>"0db0e64f-e5f6-4da3-9f77-480975ac2ba3","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"a04e449e-64c6-4927-9eb6-f3e7b0b40d55","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:0db0e64f-e5f6-4da3-9f77-480975ac2ba3","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"2182cf87-aa35-4557-87ad-3cb573e6fc3e"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2025-02-05T02:53:51.440244+00:00'::timestamptz,'2025-02-05T02:53:51.440244+00:00'::timestamptz,'2182cf87-aa35-4557-87ad-3cb573e6fc3e','Campus','IMAGE','https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb','campusimage-71','rock') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url
              U
              "id"=>"0db0e64f-e5f6-4da3-9f77-480975ac2ba3","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"fc0a6550-c603-483d-90b9-bf6a54644895","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:0db0e64f-e5f6-4da3-9f77-480975ac2ba3","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"38b7dcca-33be-4b94-8afa-a9b17bb9c458"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2025-02-05T02:53:51.440244+00:00'::timestamptz,'2025-02-05T02:53:51.440244+00:00'::timestamptz,'38b7dcca-33be-4b94-8afa-a9b17bb9c458','Campus','IMAGE','https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb','campusimage-71','rock') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url
              U
              "id"=>"0db0e64f-e5f6-4da3-9f77-480975ac2ba3","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"2182cf87-aa35-4557-87ad-3cb573e6fc3e","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:0db0e64f-e5f6-4da3-9f77-480975ac2ba3","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"a04e449e-64c6-4927-9eb6-f3e7b0b40d55"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2025-02-05T02:53:51.440244+00:00'::timestamptz,'2025-02-05T02:53:51.440244+00:00'::timestamptz,'a04e449e-64c6-4927-9eb6-f3e7b0b40d55','Campus','IMAGE','https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb','campusimage-71','rock') ON CONFLICT (origin_id, church_slug, origin_type) DO UPDATE SET apollos_type = excluded.apollos_type, created_at = excluded.created_at, updated_at = excluded.updated_at, node_id = excluded.node_id, node_type = excluded.node_type, type = excluded.type, url = excluded.url
              U
              "id"=>"0db0e64f-e5f6-4da3-9f77-480975ac2ba3","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"38b7dcca-33be-4b94-8afa-a9b17bb9c458","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:0db0e64f-e5f6-4da3-9f77-480975ac2ba3","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"
	33c33
	< 2182cf87-aa35-4557-87ad-3cb573e6fc3e Friends & Internet Campus \N \N \N \N Campus 2 ministry_platform \N \N t \N apollos_demo campus
	---
	> 2182cf87-aa35-4557-87ad-3cb573e6fc3e Friends & Internet Campus \N \N \N \N Campus 2 ministry_platform \N \N t 0db0e64f-e5f6-4da3-9f77-480975ac2ba3 apollos_demo campus
	36c36
	< 38b7dcca-33be-4b94-8afa-a9b17bb9c458 Churchwide Activities \N \N \N \N Campus 4 ministry_platform \N \N t \N apollos_demo campus
	---
	> 38b7dcca-33be-4b94-8afa-a9b17bb9c458 Churchwide Activities \N \N \N \N Campus 4 ministry_platform \N \N t 0db0e64f-e5f6-4da3-9f77-480975ac2ba3 apollos_demo campus
	82c82
	< fc0a6550-c603-483d-90b9-bf6a54644895 Apollos Test Campus \N \N \N \N \N \N \N \N f Campus 1 touchpoint \N \N t \N apollos_demo campus
	---
	> fc0a6550-c603-483d-90b9-bf6a54644895 Apollos Test Campus \N \N \N \N \N \N \N \N f Campus 1 touchpoint \N \N t 0db0e64f-e5f6-4da3-9f77-480975ac2ba3 apollos_demo campus
	147a148
	> 10c003b2-81cb-4784-b2a7-09126adda221 3e08b8fa-23cb-4dae-8d1e-4719ae755916 d1c03319-fb2e-44bb-b060-c7dec134ef4c t apollos_demo CommunityMember \N \N PENDING rock 783 community_members
	151a153
	> 4c1287b0-cc88-43b5-9e14-cc89029516f7 80d63c9a-f6a5-47ec-8944-7165eeac5d3b 2d2c23fc-1301-483f-85da-7870b235eb23 \N apollos_demo CommunityMember \N \N PENDING rock 866 community_members
	157a160
	> d6a53bc5-534e-4863-a9b8-19e8b8d64618 80d63c9a-f6a5-47ec-8944-7165eeac5d3b f9cbd6ff-c5d8-4a7d-8beb-31a881fbed26 \N apollos_demo CommunityMember \N \N PENDING rock 892 community_members
	712520a712524
	> c1984d60-5815-49b5-bf49-7076e5299d52 \N \N \N \N \N MALE \N f Person 150 rock \N \N apollos_demo \N people
	799331d799334
	< d91abde2-d722-4551-8b1f-9f15eb9e38b4 \N \N \N \N \N MALE \N f Person 150 rock \N \N apollos_demo \N people
	942120a942124
	> a0115ac9-bf16-4863-ae28-8816fbadb9d9 188a71a2-05d3-4097-9bdc-ac578fa960c6 \N \N apollos_demo system people_tag
	942150a942155
	> a0115ac9-bf16-4863-ae28-8816fbadb9d9 3e08b8fa-23cb-4dae-8d1e-4719ae755916 \N \N apollos_demo system people_tag
	942213a942219
	> a0115ac9-bf16-4863-ae28-8816fbadb9d9 80d63c9a-f6a5-47ec-8944-7165eeac5d3b \N \N apollos_demo system people_tag
	942223a942230
	> a0115ac9-bf16-4863-ae28-8816fbadb9d9 8a183ada-e706-4b1a-b5a2-d24eeccb1256 \N \N apollos_demo system people_tag
	942270a942278
	> a0115ac9-bf16-4863-ae28-8816fbadb9d9 c1984d60-5815-49b5-bf49-7076e5299d52 \N \N apollos_demo system people_tag
	942285a942294
	> a0115ac9-bf16-4863-ae28-8816fbadb9d9 ce9ad1bc-0fcc-437b-8a7f-0e9694a007a1 \N \N apollos_demo system people_tag
	942287a942297
	> a0115ac9-bf16-4863-ae28-8816fbadb9d9 d1e93a01-a3a9-435d-ae1e-be1327a75e4b \N \N apollos_demo system people_tag
	942293d942302
	< a0115ac9-bf16-4863-ae28-8816fbadb9d9 d91abde2-d722-4551-8b1f-9f15eb9e38b4 \N \N apollos_demo system people_tag
	942330a942340
	> add44a01-5b1a-4949-af34-0fb4642726fc 188a71a2-05d3-4097-9bdc-ac578fa960c6 \N \N apollos_demo system people_tag
	942338a942349
	> add44a01-5b1a-4949-af34-0fb4642726fc 3e08b8fa-23cb-4dae-8d1e-4719ae755916 \N \N apollos_demo system people_tag
	942353a942365
	> add44a01-5b1a-4949-af34-0fb4642726fc 80d63c9a-f6a5-47ec-8944-7165eeac5d3b \N \N apollos_demo system people_tag
	942358a942371
	> add44a01-5b1a-4949-af34-0fb4642726fc 88ea86d0-e38b-46b2-829b-2c6a9178cd78 \N \N apollos_demo system people_tag
	942380a942394
	> add44a01-5b1a-4949-af34-0fb4642726fc c5cb4820-7fb7-4d82-abb3-176311159948 \N \N apollos_demo system people_tag
	942384a942399
	> add44a01-5b1a-4949-af34-0fb4642726fc d3658c8f-6b06-4c5f-8b2e-c542cc609961 \N \N apollos_demo system people_tag