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-3f1a055da0f7efd8c0b3921cd4b4538a84c2ca10.diff
32c32
< 0bfc4836-8a01-4937-a995-f3d356296680	Friends & Internet Campus						\N	\N	\N	\N	Campus	2	ministry_platform	\N	\N	t	\N	apollos_demo	campus
---
> 0bfc4836-8a01-4937-a995-f3d356296680	Friends & Internet Campus						\N	\N	\N	\N	Campus	2	ministry_platform	\N	\N	t	bdd92b5d-eaae-4a50-9ffe-23d74a8eb979	apollos_demo	campus
35c35
< 1d701c43-697c-4126-9c70-e5889338c741	Central Congregation	 Carlanna Dam Road	\N	KETCHIKAN	AK	99901	55.3685879	-131.6910983	\N	\N	Campus	1	ministry_platform	\N	\N	t	\N	apollos_demo	campus
---
> 1d701c43-697c-4126-9c70-e5889338c741	Central Congregation	 Carlanna Dam Road	\N	KETCHIKAN	AK	99901	55.3685879	-131.6910983	\N	\N	Campus	1	ministry_platform	\N	\N	t	bdd92b5d-eaae-4a50-9ffe-23d74a8eb979	apollos_demo	campus
58c58
< 9ebc53be-49c3-4f04-abc5-13cfc8c4023b	Churchwide Activities						\N	\N	\N	\N	Campus	4	ministry_platform	\N	\N	t	\N	apollos_demo	campus
---
> 9ebc53be-49c3-4f04-abc5-13cfc8c4023b	Churchwide Activities						\N	\N	\N	\N	Campus	4	ministry_platform	\N	\N	t	bdd92b5d-eaae-4a50-9ffe-23d74a8eb979	apollos_demo	campus
156a157,158
> c721d156-6544-468f-8bb6-8477f29a8cc0	58d8b771-0d61-48b7-80fe-5f8f495d44d2	a3bc50ea-fef4-44c6-847b-dc7ab1440bec	\N	apollos_demo	CommunityMember	\N	\N	PENDING	rock	892	community_members
> db5c632f-3d8e-458a-9474-1e71fd49e1a1	58d8b771-0d61-48b7-80fe-5f8f495d44d2	126ca31e-5679-4906-8749-ff65e92f966d	\N	apollos_demo	CommunityMember	\N	\N	PENDING	rock	866	community_members
159a162
> f10173fd-ce5a-4e3e-9010-c1d7defdc78d	79bfe229-cc27-4fa6-abb1-a52c82d3f875	517a104b-f663-43de-ae42-3252c8382ba1	t	apollos_demo	CommunityMember	\N	\N	PENDING	rock	783	community_members
869654a869658
> ec175145-d119-4015-826b-5ae3cf76f0fd	\N	\N	\N	\N	\N	MALE	\N	f	Person	150	rock	\N	\N	apollos_demo	\N	people
872044d872047
< ecc20f31-f9d3-40e8-90a4-786da3c9fbba	\N	\N	\N	\N	\N	MALE	\N	f	Person	150	rock	\N	\N	apollos_demo	\N	people
942064a942068
> 3df55b4f-9e35-4bca-b116-7746728e7e2c	1a538fa8-361c-439e-bc14-c6b967e8b787	\N	\N	apollos_demo	system	people_tag
942111a942116
> 3df55b4f-9e35-4bca-b116-7746728e7e2c	583b9b6a-6835-4f76-b764-ba83116d912f	\N	\N	apollos_demo	system	people_tag
942112a942118
> 3df55b4f-9e35-4bca-b116-7746728e7e2c	58d8b771-0d61-48b7-80fe-5f8f495d44d2	\N	\N	apollos_demo	system	people_tag
942140a942147
> 3df55b4f-9e35-4bca-b116-7746728e7e2c	79bfe229-cc27-4fa6-abb1-a52c82d3f875	\N	\N	apollos_demo	system	people_tag
942226a942234
> 3df55b4f-9e35-4bca-b116-7746728e7e2c	cbc40fb9-3161-4a1b-afb5-d7e82864e8d1	\N	\N	apollos_demo	system	people_tag
942229a942238
> 3df55b4f-9e35-4bca-b116-7746728e7e2c	cf07ef22-32df-4ac0-b8a1-8fc7657c027e	\N	\N	apollos_demo	system	people_tag
942259a942269
> 3df55b4f-9e35-4bca-b116-7746728e7e2c	ec175145-d119-4015-826b-5ae3cf76f0fd	\N	\N	apollos_demo	system	people_tag
942261d942270
< 3df55b4f-9e35-4bca-b116-7746728e7e2c	ecc20f31-f9d3-40e8-90a4-786da3c9fbba	\N	\N	apollos_demo	system	people_tag
942312a942322
> 6039df31-bd9f-4e2a-b914-0d32d2874443	1386fe27-7855-48e1-91b3-e4e7a9a1d64c	\N	\N	apollos_demo	system	people_tag
942327a942338
> 6039df31-bd9f-4e2a-b914-0d32d2874443	58d8b771-0d61-48b7-80fe-5f8f495d44d2	\N	\N	apollos_demo	system	people_tag
942329a942341
> 6039df31-bd9f-4e2a-b914-0d32d2874443	6170aa8c-b52f-4441-80ee-2594de0b5b64	\N	\N	apollos_demo	system	people_tag
942332a942345
> 6039df31-bd9f-4e2a-b914-0d32d2874443	79bfe229-cc27-4fa6-abb1-a52c82d3f875	\N	\N	apollos_demo	system	people_tag
942359a942373,942374
> 6039df31-bd9f-4e2a-b914-0d32d2874443	cbc40fb9-3161-4a1b-afb5-d7e82864e8d1	\N	\N	apollos_demo	system	people_tag
> 6039df31-bd9f-4e2a-b914-0d32d2874443	cdd81dc4-e83e-41f3-bb06-e11e16f1607e	\N	\N	apollos_demo	system	people_tag

## 3-changes-3f1a055da0f7efd8c0b3921cd4b4538a84c2ca10.csv

          
            table_name
            changed_fields
            client_query
            action
            row_data

            
              node_slug
              "node_id"=>"c17e36cf-1fd7-46aa-bff7-94aa0420d480"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"fd4241b2-658b-4a26-9da0-4d4703c8152c","slug"=>"giving","node_id"=>"87652ba5-6586-4b2c-a436-658f11c0b282","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"87652ba5-6586-4b2c-a436-658f11c0b282"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"fd4241b2-658b-4a26-9da0-4d4703c8152c","slug"=>"giving","node_id"=>"c17e36cf-1fd7-46aa-bff7-94aa0420d480","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"a0d441a5-0322-4a29-8b99-999e5afe4871"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"56bb5537-8efe-4e7e-879f-a4b42e57cfcc","slug"=>"at-the-movies","node_id"=>"cceb7039-6696-4951-88f9-ee5280cf416c","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"2c99190a-1b4c-4b7c-a416-6f2fd3367276"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"6b1c00d5-58f6-497d-aba1-808cdc316e1d","slug"=>"1x8","node_id"=>"76fe92f8-a163-4304-8981-168657a8747c","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"3ab00e97-096b-46a8-b03e-1eef17c4a441"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"54b5cea9-b53d-4d5e-9b53-37a19d3819e8","slug"=>"potential","node_id"=>"e40c6350-ecde-461b-9944-d467991a9f1d","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"eedb8188-821e-4dbb-933d-18eb136458d7"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"3b7d579f-646f-45c3-aac0-b239f210e822","slug"=>"arrival","node_id"=>"d04b7edb-cf77-4259-95ae-f8f2052bff5c","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"cceb7039-6696-4951-88f9-ee5280cf416c"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"56bb5537-8efe-4e7e-879f-a4b42e57cfcc","slug"=>"at-the-movies","node_id"=>"a0d441a5-0322-4a29-8b99-999e5afe4871","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"76fe92f8-a163-4304-8981-168657a8747c"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"6b1c00d5-58f6-497d-aba1-808cdc316e1d","slug"=>"1x8","node_id"=>"2c99190a-1b4c-4b7c-a416-6f2fd3367276","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"e40c6350-ecde-461b-9944-d467991a9f1d"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"54b5cea9-b53d-4d5e-9b53-37a19d3819e8","slug"=>"potential","node_id"=>"3ab00e97-096b-46a8-b03e-1eef17c4a441","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              node_slug
              "node_id"=>"d04b7edb-cf77-4259-95ae-f8f2052bff5c"
              
                INSERT INTO node_slug (created_at, updated_at, slug, node_type, node_id)
                SELECT '2025-02-05 02:05:34.809696+00:00', '2025-02-05 02:05:34.809696+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"=>"3b7d579f-646f-45c3-aac0-b239f210e822","slug"=>"arrival","node_id"=>"eedb8188-821e-4dbb-933d-18eb136458d7","node_type"=>"ContentItem","church_slug"=>"apollos_demo"

            
              content_tag
              
              
                DELETE
                FROM content_tag
                WHERE
                    content_item_id = '0fd6c0a5-2fe9-472f-af97-f2940eccdc1d'
                    AND tag_id IN ('9405c41f-76bc-4fa1-b6b3-3944ebce7c3b', '45c7f1a9-8941-48a4-ab3e-20790fa64f99', 'd0005e93-61ad-459f-9aca-5d342023c2c5', 'e629bde0-4bc7-494a-95c3-af58667a6f1c', '13a51909-e7bc-457d-9bbd-08c37bb3e3d6', 'fb845bbb-049e-41b7-99cc-f3590fc1e86f', '17f1c183-e8ad-438c-a4a9-d6d45cf7f75b')
                
              D
              "tag_id"=>"e629bde0-4bc7-494a-95c3-af58667a6f1c","church_slug"=>"apollos_demo","content_item_id"=>"0fd6c0a5-2fe9-472f-af97-f2940eccdc1d"

            
              content_tag
              
              
                    INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
                    VALUES ('e629bde0-4bc7-494a-95c3-af58667a6f1c', '0fd6c0a5-2fe9-472f-af97-f2940eccdc1d', NOW(), NOW())
                    
              I
              "tag_id"=>"e629bde0-4bc7-494a-95c3-af58667a6f1c","church_slug"=>"apollos_demo","content_item_id"=>"0fd6c0a5-2fe9-472f-af97-f2940eccdc1d"

            
              content_tag
              
              
                DELETE
                FROM content_tag
                WHERE
                    content_item_id = 'bdf0c73b-9331-4760-99aa-7460463def1f'
                    AND tag_id IN ('9405c41f-76bc-4fa1-b6b3-3944ebce7c3b', '45c7f1a9-8941-48a4-ab3e-20790fa64f99', 'd0005e93-61ad-459f-9aca-5d342023c2c5', 'e629bde0-4bc7-494a-95c3-af58667a6f1c', '13a51909-e7bc-457d-9bbd-08c37bb3e3d6', 'fb845bbb-049e-41b7-99cc-f3590fc1e86f', '17f1c183-e8ad-438c-a4a9-d6d45cf7f75b')
                
              D
              "tag_id"=>"e629bde0-4bc7-494a-95c3-af58667a6f1c","church_slug"=>"apollos_demo","content_item_id"=>"bdf0c73b-9331-4760-99aa-7460463def1f"

            
              content_tag
              
              
                    INSERT INTO content_tag (tag_id, content_item_id, created_at, updated_at)
                    VALUES ('e629bde0-4bc7-494a-95c3-af58667a6f1c', 'bdf0c73b-9331-4760-99aa-7460463def1f', NOW(), NOW())
                    
              I
              "tag_id"=>"e629bde0-4bc7-494a-95c3-af58667a6f1c","church_slug"=>"apollos_demo","content_item_id"=>"bdf0c73b-9331-4760-99aa-7460463def1f"

            
              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"=>"6039df31-bd9f-4e2a-b914-0d32d2874443","person_id"=>"cdd81dc4-e83e-41f3-bb06-e11e16f1607e","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"=>"6039df31-bd9f-4e2a-b914-0d32d2874443","person_id"=>"cbc40fb9-3161-4a1b-afb5-d7e82864e8d1","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"=>"6039df31-bd9f-4e2a-b914-0d32d2874443","person_id"=>"58d8b771-0d61-48b7-80fe-5f8f495d44d2","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"=>"6039df31-bd9f-4e2a-b914-0d32d2874443","person_id"=>"79bfe229-cc27-4fa6-abb1-a52c82d3f875","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"=>"6039df31-bd9f-4e2a-b914-0d32d2874443","person_id"=>"1386fe27-7855-48e1-91b3-e4e7a9a1d64c","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"=>"6039df31-bd9f-4e2a-b914-0d32d2874443","person_id"=>"6170aa8c-b52f-4441-80ee-2594de0b5b64","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"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","person_id"=>"cf07ef22-32df-4ac0-b8a1-8fc7657c027e","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"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","person_id"=>"583b9b6a-6835-4f76-b764-ba83116d912f","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"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","person_id"=>"cbc40fb9-3161-4a1b-afb5-d7e82864e8d1","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"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","person_id"=>"58d8b771-0d61-48b7-80fe-5f8f495d44d2","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"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","person_id"=>"79bfe229-cc27-4fa6-abb1-a52c82d3f875","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"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","person_id"=>"1a538fa8-361c-439e-bc14-c6b967e8b787","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"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","church_slug"=>"apollos_demo","content_item_id"=>"9d3fe289-14f9-4562-8289-0f93ba6924ae"

            
              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"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","church_slug"=>"apollos_demo","content_item_id"=>"9d3fe289-14f9-4562-8289-0f93ba6924ae"

            
              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"=>"bd058000-3a78-4fd3-ad80-8904619d03ba","event_id"=>"50ea6183-d140-49a6-8773-a1e94057d92c","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"=>"dd7535e2-cd7a-4ffd-8b0c-cc22008eb058","event_id"=>"50ea6183-d140-49a6-8773-a1e94057d92c","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"=>"ac3111ff-b256-4d76-8250-d1c5da94a93c","event_id"=>"50ea6183-d140-49a6-8773-a1e94057d92c","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"=>"bd058000-3a78-4fd3-ad80-8904619d03ba","event_id"=>"81c7ad23-d0b7-45e9-9147-f92e4b3bfaf4","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"=>"dd7535e2-cd7a-4ffd-8b0c-cc22008eb058","event_id"=>"81c7ad23-d0b7-45e9-9147-f92e4b3bfaf4","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"=>"8a78f9b6-8292-4b2b-88ba-3c458adcce6c","event_id"=>"81c7ad23-d0b7-45e9-9147-f92e4b3bfaf4","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"=>"ac3111ff-b256-4d76-8250-d1c5da94a93c","event_id"=>"81c7ad23-d0b7-45e9-9147-f92e4b3bfaf4","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"=>"bd058000-3a78-4fd3-ad80-8904619d03ba","event_id"=>"f266f970-4013-49fd-8de4-fccbeaafb054","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"=>"ac3111ff-b256-4d76-8250-d1c5da94a93c","event_id"=>"f266f970-4013-49fd-8de4-fccbeaafb054","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"=>"2a6174eb-3988-4edc-8641-be57313deb7d","event_id"=>"f266f970-4013-49fd-8de4-fccbeaafb054","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"=>"bd058000-3a78-4fd3-ad80-8904619d03ba","event_id"=>"50ea6183-d140-49a6-8773-a1e94057d92c","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"=>"dd7535e2-cd7a-4ffd-8b0c-cc22008eb058","event_id"=>"50ea6183-d140-49a6-8773-a1e94057d92c","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"=>"ac3111ff-b256-4d76-8250-d1c5da94a93c","event_id"=>"50ea6183-d140-49a6-8773-a1e94057d92c","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"=>"bd058000-3a78-4fd3-ad80-8904619d03ba","event_id"=>"81c7ad23-d0b7-45e9-9147-f92e4b3bfaf4","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"=>"dd7535e2-cd7a-4ffd-8b0c-cc22008eb058","event_id"=>"81c7ad23-d0b7-45e9-9147-f92e4b3bfaf4","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"=>"8a78f9b6-8292-4b2b-88ba-3c458adcce6c","event_id"=>"81c7ad23-d0b7-45e9-9147-f92e4b3bfaf4","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"=>"ac3111ff-b256-4d76-8250-d1c5da94a93c","event_id"=>"81c7ad23-d0b7-45e9-9147-f92e4b3bfaf4","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"=>"bd058000-3a78-4fd3-ad80-8904619d03ba","event_id"=>"f266f970-4013-49fd-8de4-fccbeaafb054","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"=>"ac3111ff-b256-4d76-8250-d1c5da94a93c","event_id"=>"f266f970-4013-49fd-8de4-fccbeaafb054","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"=>"2a6174eb-3988-4edc-8641-be57313deb7d","event_id"=>"f266f970-4013-49fd-8de4-fccbeaafb054","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:06:14.062321+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"=>"f10173fd-ce5a-4e3e-9010-c1d7defdc78d","status"=>"PENDING","is_host"=>NULL,"origin_id"=>"783","person_id"=>"79bfe229-cc27-4fa6-abb1-a52c82d3f875","apollos_id"=>"CommunityMember:f10173fd-ce5a-4e3e-9010-c1d7defdc78d","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"CommunityMember","community_id"=>"517a104b-f663-43de-ae42-3252c8382ba1"

            
              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:06:14.062321+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"=>"db5c632f-3d8e-458a-9474-1e71fd49e1a1","status"=>"PENDING","is_host"=>NULL,"origin_id"=>"866","person_id"=>"58d8b771-0d61-48b7-80fe-5f8f495d44d2","apollos_id"=>"CommunityMember:db5c632f-3d8e-458a-9474-1e71fd49e1a1","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"CommunityMember","community_id"=>"126ca31e-5679-4906-8749-ff65e92f966d"

            
              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:06:14.062321+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"=>"c721d156-6544-468f-8bb6-8477f29a8cc0","status"=>"PENDING","is_host"=>NULL,"origin_id"=>"892","person_id"=>"58d8b771-0d61-48b7-80fe-5f8f495d44d2","apollos_id"=>"CommunityMember:c721d156-6544-468f-8bb6-8477f29a8cc0","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"CommunityMember","community_id"=>"a3bc50ea-fef4-44c6-847b-dc7ab1440bec"

            
              community_members
              "is_host"=>"t"
              
                                update community_members as cm
                                set is_host = true, updated_at = '2025-02-05T02:06:14.062321+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"=>"f10173fd-ce5a-4e3e-9010-c1d7defdc78d","status"=>"PENDING","is_host"=>NULL,"origin_id"=>"783","person_id"=>"79bfe229-cc27-4fa6-abb1-a52c82d3f875","apollos_id"=>"CommunityMember:f10173fd-ce5a-4e3e-9010-c1d7defdc78d","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"CommunityMember","community_id"=>"517a104b-f663-43de-ae42-3252c8382ba1"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('df191e22-d958-4148-b86b-d99d9b111fa6')
                    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"=>"aa393942-4a79-44da-8837-d7dc353eae1a","church_slug"=>"apollos_demo","content_item_id"=>"df191e22-d958-4148-b86b-d99d9b111fa6"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('df191e22-d958-4148-b86b-d99d9b111fa6','2025-02-05T02:06:23.017095+00:00'::timestamptz,'aa393942-4a79-44da-8837-d7dc353eae1a','2025-02-05T02:06:23.017095+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"=>"aa393942-4a79-44da-8837-d7dc353eae1a","church_slug"=>"apollos_demo","content_item_id"=>"df191e22-d958-4148-b86b-d99d9b111fa6"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('ece4fd85-b4c0-418b-a3e8-854c554f21a1','2c9636d0-d2a6-4f87-a506-ad14fd9de7d7','dd3e2ba8-d933-4f02-9622-52af76fc65e7','fa47401e-cdba-4a7f-a449-5b53e19c0d43','b51eda4b-b579-48d7-ac3e-393ab8ef0324')
                    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"=>"d6eaae33-765b-4fa6-99d6-5fdd6df77294","church_slug"=>"apollos_demo","content_item_id"=>"ece4fd85-b4c0-418b-a3e8-854c554f21a1"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('ece4fd85-b4c0-418b-a3e8-854c554f21a1','2c9636d0-d2a6-4f87-a506-ad14fd9de7d7','dd3e2ba8-d933-4f02-9622-52af76fc65e7','fa47401e-cdba-4a7f-a449-5b53e19c0d43','b51eda4b-b579-48d7-ac3e-393ab8ef0324')
                    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"=>"7176ac7c-ac1a-429b-9173-9ba6cf23e38e","church_slug"=>"apollos_demo","content_item_id"=>"ece4fd85-b4c0-418b-a3e8-854c554f21a1"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('ece4fd85-b4c0-418b-a3e8-854c554f21a1','2c9636d0-d2a6-4f87-a506-ad14fd9de7d7','dd3e2ba8-d933-4f02-9622-52af76fc65e7','fa47401e-cdba-4a7f-a449-5b53e19c0d43','b51eda4b-b579-48d7-ac3e-393ab8ef0324')
                    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"=>"d6eaae33-765b-4fa6-99d6-5fdd6df77294","church_slug"=>"apollos_demo","content_item_id"=>"fa47401e-cdba-4a7f-a449-5b53e19c0d43"

            
              content_tag
              
              
                    DELETE from content_tag
                    USING tag
                    WHERE content_tag.content_item_id in ('ece4fd85-b4c0-418b-a3e8-854c554f21a1','2c9636d0-d2a6-4f87-a506-ad14fd9de7d7','dd3e2ba8-d933-4f02-9622-52af76fc65e7','fa47401e-cdba-4a7f-a449-5b53e19c0d43','b51eda4b-b579-48d7-ac3e-393ab8ef0324')
                    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"=>"7fb20264-9acc-4fbb-9561-c72a2c0f8cd9","church_slug"=>"apollos_demo","content_item_id"=>"fa47401e-cdba-4a7f-a449-5b53e19c0d43"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('ece4fd85-b4c0-418b-a3e8-854c554f21a1','2025-02-05T02:06:23.017095+00:00'::timestamptz,'d6eaae33-765b-4fa6-99d6-5fdd6df77294','2025-02-05T02:06:23.017095+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"=>"d6eaae33-765b-4fa6-99d6-5fdd6df77294","church_slug"=>"apollos_demo","content_item_id"=>"ece4fd85-b4c0-418b-a3e8-854c554f21a1"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('ece4fd85-b4c0-418b-a3e8-854c554f21a1','2025-02-05T02:06:23.017095+00:00'::timestamptz,'7176ac7c-ac1a-429b-9173-9ba6cf23e38e','2025-02-05T02:06:23.017095+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"=>"7176ac7c-ac1a-429b-9173-9ba6cf23e38e","church_slug"=>"apollos_demo","content_item_id"=>"ece4fd85-b4c0-418b-a3e8-854c554f21a1"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('fa47401e-cdba-4a7f-a449-5b53e19c0d43','2025-02-05T02:06:23.017095+00:00'::timestamptz,'d6eaae33-765b-4fa6-99d6-5fdd6df77294','2025-02-05T02:06:23.017095+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"=>"d6eaae33-765b-4fa6-99d6-5fdd6df77294","church_slug"=>"apollos_demo","content_item_id"=>"fa47401e-cdba-4a7f-a449-5b53e19c0d43"

            
              content_tag
              
              INSERT INTO content_tag (content_item_id, created_at, tag_id, updated_at) VALUES ('fa47401e-cdba-4a7f-a449-5b53e19c0d43','2025-02-05T02:06:23.017095+00:00'::timestamptz,'7fb20264-9acc-4fbb-9561-c72a2c0f8cd9','2025-02-05T02:06:23.017095+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"=>"7fb20264-9acc-4fbb-9561-c72a2c0f8cd9","church_slug"=>"apollos_demo","content_item_id"=>"fa47401e-cdba-4a7f-a449-5b53e19c0d43"

            
              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"=>"ff4e4931-a5e0-4dfb-9847-c2552001295c","data"=>NULL,"name"=>"Apollos Test Campus","type"=>NULL,"origin_id"=>"campus-1","apollos_id"=>"Tag:ff4e4931-a5e0-4dfb-9847-c2552001295c","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"=>"ff4e4931-a5e0-4dfb-9847-c2552001295c","data"=>NULL,"name"=>"Apollos Test Campus","type"=>NULL,"origin_id"=>"campus-1","apollos_id"=>"Tag:ff4e4931-a5e0-4dfb-9847-c2552001295c","church_slug"=>"apollos_demo","origin_type"=>"touchpoint","apollos_type"=>"Tag"

            
              campus
              "image_id"=>"bdd92b5d-eaae-4a50-9ffe-23d74a8eb979"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '1d701c43-697c-4126-9c70-e5889338c741' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"1d701c43-697c-4126-9c70-e5889338c741","city"=>"KETCHIKAN","name"=>"Central Congregation","state"=>"AK","active"=>"t","digital"=>NULL,"street1"=>" Carlanna Dam Road","street2"=>NULL,"image_id"=>NULL,"latitude"=>"55.3685879","image_url"=>NULL,"longitude"=>"-131.6910983","origin_id"=>"1","apollos_id"=>"Campus:1d701c43-697c-4126-9c70-e5889338c741","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"99901","apollos_type"=>"Campus"

            
              campus
              "image_id"=>"bdd92b5d-eaae-4a50-9ffe-23d74a8eb979"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '0bfc4836-8a01-4937-a995-f3d356296680' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"0bfc4836-8a01-4937-a995-f3d356296680","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:0bfc4836-8a01-4937-a995-f3d356296680","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"

            
              campus
              "image_id"=>"bdd92b5d-eaae-4a50-9ffe-23d74a8eb979"
              
                UPDATE campus
                SET image_id = media.id
                FROM media
                WHERE campus.id = '9ebc53be-49c3-4f04-abc5-13cfc8c4023b' AND media.origin_id = 'campusimage-71'
                
              U
              "id"=>"9ebc53be-49c3-4f04-abc5-13cfc8c4023b","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:9ebc53be-49c3-4f04-abc5-13cfc8c4023b","church_slug"=>"apollos_demo","origin_type"=>"ministry_platform","postal_code"=>"","apollos_type"=>"Campus"

            
              people_tag
              "person_id"=>"ec175145-d119-4015-826b-5ae3cf76f0fd"
              
                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 = 'ec175145-d119-4015-826b-5ae3cf76f0fd' WHERE person_id = 'ecc20f31-f9d3-40e8-90a4-786da3c9fbba' and NOT EXISTS (SELECT 1 FROM people_tag WHERE person_id = 'ec175145-d119-4015-826b-5ae3cf76f0fd' and tag_id = people_tag.tag_id);
                    -- Now we can delete the old person
                    DELETE FROM people WHERE id = 'ecc20f31-f9d3-40e8-90a4-786da3c9fbba' AND apollos_user is false;
                    -- And update our person to have the correct origin_id
                    UPDATE people SET origin_id = '150' WHERE id = 'ec175145-d119-4015-826b-5ae3cf76f0fd';
                COMMIT;
                
              U
              "type"=>"system","tag_id"=>"3df55b4f-9e35-4bca-b116-7746728e7e2c","person_id"=>"ecc20f31-f9d3-40e8-90a4-786da3c9fbba","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 = 'ec175145-d119-4015-826b-5ae3cf76f0fd' WHERE person_id = 'ecc20f31-f9d3-40e8-90a4-786da3c9fbba' and NOT EXISTS (SELECT 1 FROM people_tag WHERE person_id = 'ec175145-d119-4015-826b-5ae3cf76f0fd' and tag_id = people_tag.tag_id);
                    -- Now we can delete the old person
                    DELETE FROM people WHERE id = 'ecc20f31-f9d3-40e8-90a4-786da3c9fbba' AND apollos_user is false;
                    -- And update our person to have the correct origin_id
                    UPDATE people SET origin_id = '150' WHERE id = 'ec175145-d119-4015-826b-5ae3cf76f0fd';
                COMMIT;
                
              D
              "id"=>"ecc20f31-f9d3-40e8-90a4-786da3c9fbba","email"=>NULL,"phone"=>NULL,"gender"=>"MALE","campus_id"=>NULL,"last_name"=>"Wilson","origin_id"=>"150","apollos_id"=>"Person:ecc20f31-f9d3-40e8-90a4-786da3c9fbba","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 = 'ec175145-d119-4015-826b-5ae3cf76f0fd' WHERE person_id = 'ecc20f31-f9d3-40e8-90a4-786da3c9fbba' and NOT EXISTS (SELECT 1 FROM people_tag WHERE person_id = 'ec175145-d119-4015-826b-5ae3cf76f0fd' and tag_id = people_tag.tag_id);
                    -- Now we can delete the old person
                    DELETE FROM people WHERE id = 'ecc20f31-f9d3-40e8-90a4-786da3c9fbba' AND apollos_user is false;
                    -- And update our person to have the correct origin_id
                    UPDATE people SET origin_id = '150' WHERE id = 'ec175145-d119-4015-826b-5ae3cf76f0fd';
                COMMIT;
                
              U
              "id"=>"ec175145-d119-4015-826b-5ae3cf76f0fd","email"=>NULL,"phone"=>NULL,"gender"=>"MALE","campus_id"=>NULL,"last_name"=>NULL,"origin_id"=>"163","apollos_id"=>"Person:ec175145-d119-4015-826b-5ae3cf76f0fd","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:03:28.332909+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"=>"ecc20f31-f9d3-40e8-90a4-786da3c9fbba","email"=>NULL,"phone"=>NULL,"gender"=>"MALE","campus_id"=>NULL,"last_name"=>NULL,"origin_id"=>"150","apollos_id"=>"Person:ecc20f31-f9d3-40e8-90a4-786da3c9fbba","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:03:28.332909+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"=>"ec175145-d119-4015-826b-5ae3cf76f0fd","email"=>NULL,"phone"=>NULL,"gender"=>"MALE","campus_id"=>NULL,"last_name"=>NULL,"origin_id"=>"163","apollos_id"=>"Person:ec175145-d119-4015-826b-5ae3cf76f0fd","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"=>"1d701c43-697c-4126-9c70-e5889338c741"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2025-02-05T02:03:28.332909+00:00'::timestamptz,'2025-02-05T02:03:28.332909+00:00'::timestamptz,'1d701c43-697c-4126-9c70-e5889338c741','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"=>"bdd92b5d-eaae-4a50-9ffe-23d74a8eb979","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"eaa50d44-e99b-4777-901b-0a19a5e4f58c","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:bdd92b5d-eaae-4a50-9ffe-23d74a8eb979","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"0bfc4836-8a01-4937-a995-f3d356296680"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2025-02-05T02:03:28.332909+00:00'::timestamptz,'2025-02-05T02:03:28.332909+00:00'::timestamptz,'0bfc4836-8a01-4937-a995-f3d356296680','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"=>"bdd92b5d-eaae-4a50-9ffe-23d74a8eb979","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"1d701c43-697c-4126-9c70-e5889338c741","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:bdd92b5d-eaae-4a50-9ffe-23d74a8eb979","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"9ebc53be-49c3-4f04-abc5-13cfc8c4023b"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2025-02-05T02:03:28.332909+00:00'::timestamptz,'2025-02-05T02:03:28.332909+00:00'::timestamptz,'9ebc53be-49c3-4f04-abc5-13cfc8c4023b','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"=>"bdd92b5d-eaae-4a50-9ffe-23d74a8eb979","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"0bfc4836-8a01-4937-a995-f3d356296680","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:bdd92b5d-eaae-4a50-9ffe-23d74a8eb979","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"

            
              media
              "node_id"=>"eaa50d44-e99b-4777-901b-0a19a5e4f58c"
              INSERT INTO media (apollos_type, created_at, updated_at, node_id, node_type, type, url, origin_id, origin_type) VALUES ('IMAGE','2025-02-05T02:03:28.332909+00:00'::timestamptz,'2025-02-05T02:03:28.332909+00:00'::timestamptz,'eaa50d44-e99b-4777-901b-0a19a5e4f58c','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"=>"bdd92b5d-eaae-4a50-9ffe-23d74a8eb979","url"=>"https://rock.apollos.app/GetImage.ashx?guid=4e181881-b156-48b0-be40-54af2b14b3fb","type"=>"IMAGE","node_id"=>"9ebc53be-49c3-4f04-abc5-13cfc8c4023b","metadata"=>"{\"width\": 183, \"height\": 183}","node_type"=>"Campus","origin_id"=>"campusimage-71","apollos_id"=>"IMAGE:bdd92b5d-eaae-4a50-9ffe-23d74a8eb979","church_slug"=>"apollos_demo","origin_type"=>"rock","apollos_type"=>"IMAGE"
	32c32
	< 0bfc4836-8a01-4937-a995-f3d356296680 Friends & Internet Campus \N \N \N \N Campus 2 ministry_platform \N \N t \N apollos_demo campus
	---
	> 0bfc4836-8a01-4937-a995-f3d356296680 Friends & Internet Campus \N \N \N \N Campus 2 ministry_platform \N \N t bdd92b5d-eaae-4a50-9ffe-23d74a8eb979 apollos_demo campus
	35c35
	< 1d701c43-697c-4126-9c70-e5889338c741 Central Congregation Carlanna Dam Road \N KETCHIKAN AK 99901 55.3685879 -131.6910983 \N \N Campus 1 ministry_platform \N \N t \N apollos_demo campus
	---
	> 1d701c43-697c-4126-9c70-e5889338c741 Central Congregation Carlanna Dam Road \N KETCHIKAN AK 99901 55.3685879 -131.6910983 \N \N Campus 1 ministry_platform \N \N t bdd92b5d-eaae-4a50-9ffe-23d74a8eb979 apollos_demo campus
	58c58
	< 9ebc53be-49c3-4f04-abc5-13cfc8c4023b Churchwide Activities \N \N \N \N Campus 4 ministry_platform \N \N t \N apollos_demo campus
	---
	> 9ebc53be-49c3-4f04-abc5-13cfc8c4023b Churchwide Activities \N \N \N \N Campus 4 ministry_platform \N \N t bdd92b5d-eaae-4a50-9ffe-23d74a8eb979 apollos_demo campus
	156a157,158
	> c721d156-6544-468f-8bb6-8477f29a8cc0 58d8b771-0d61-48b7-80fe-5f8f495d44d2 a3bc50ea-fef4-44c6-847b-dc7ab1440bec \N apollos_demo CommunityMember \N \N PENDING rock 892 community_members
	> db5c632f-3d8e-458a-9474-1e71fd49e1a1 58d8b771-0d61-48b7-80fe-5f8f495d44d2 126ca31e-5679-4906-8749-ff65e92f966d \N apollos_demo CommunityMember \N \N PENDING rock 866 community_members
	159a162
	> f10173fd-ce5a-4e3e-9010-c1d7defdc78d 79bfe229-cc27-4fa6-abb1-a52c82d3f875 517a104b-f663-43de-ae42-3252c8382ba1 t apollos_demo CommunityMember \N \N PENDING rock 783 community_members
	869654a869658
	> ec175145-d119-4015-826b-5ae3cf76f0fd \N \N \N \N \N MALE \N f Person 150 rock \N \N apollos_demo \N people
	872044d872047
	< ecc20f31-f9d3-40e8-90a4-786da3c9fbba \N \N \N \N \N MALE \N f Person 150 rock \N \N apollos_demo \N people
	942064a942068
	> 3df55b4f-9e35-4bca-b116-7746728e7e2c 1a538fa8-361c-439e-bc14-c6b967e8b787 \N \N apollos_demo system people_tag
	942111a942116
	> 3df55b4f-9e35-4bca-b116-7746728e7e2c 583b9b6a-6835-4f76-b764-ba83116d912f \N \N apollos_demo system people_tag
	942112a942118
	> 3df55b4f-9e35-4bca-b116-7746728e7e2c 58d8b771-0d61-48b7-80fe-5f8f495d44d2 \N \N apollos_demo system people_tag
	942140a942147
	> 3df55b4f-9e35-4bca-b116-7746728e7e2c 79bfe229-cc27-4fa6-abb1-a52c82d3f875 \N \N apollos_demo system people_tag
	942226a942234
	> 3df55b4f-9e35-4bca-b116-7746728e7e2c cbc40fb9-3161-4a1b-afb5-d7e82864e8d1 \N \N apollos_demo system people_tag
	942229a942238
	> 3df55b4f-9e35-4bca-b116-7746728e7e2c cf07ef22-32df-4ac0-b8a1-8fc7657c027e \N \N apollos_demo system people_tag
	942259a942269
	> 3df55b4f-9e35-4bca-b116-7746728e7e2c ec175145-d119-4015-826b-5ae3cf76f0fd \N \N apollos_demo system people_tag
	942261d942270
	< 3df55b4f-9e35-4bca-b116-7746728e7e2c ecc20f31-f9d3-40e8-90a4-786da3c9fbba \N \N apollos_demo system people_tag
	942312a942322
	> 6039df31-bd9f-4e2a-b914-0d32d2874443 1386fe27-7855-48e1-91b3-e4e7a9a1d64c \N \N apollos_demo system people_tag
	942327a942338
	> 6039df31-bd9f-4e2a-b914-0d32d2874443 58d8b771-0d61-48b7-80fe-5f8f495d44d2 \N \N apollos_demo system people_tag
	942329a942341
	> 6039df31-bd9f-4e2a-b914-0d32d2874443 6170aa8c-b52f-4441-80ee-2594de0b5b64 \N \N apollos_demo system people_tag
	942332a942345
	> 6039df31-bd9f-4e2a-b914-0d32d2874443 79bfe229-cc27-4fa6-abb1-a52c82d3f875 \N \N apollos_demo system people_tag
	942359a942373,942374
	> 6039df31-bd9f-4e2a-b914-0d32d2874443 cbc40fb9-3161-4a1b-afb5-d7e82864e8d1 \N \N apollos_demo system people_tag
	> 6039df31-bd9f-4e2a-b914-0d32d2874443 cdd81dc4-e83e-41f3-bb06-e11e16f1607e \N \N apollos_demo system people_tag