Skip to content

Instantly share code, notes, and snippets.

@cutwater

cutwater/queries.sql Secret

Last active September 24, 2020 10:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cutwater/70f6adbe68d88cec0df14141d508f5cf to your computer and use it in GitHub Desktop.
Save cutwater/70f6adbe68d88cec0df14141d508f5cf to your computer and use it in GitHub Desktop.
Download ZIP
[pulp_ansible] Collection list SQL queries log
Raw
queries.sql
SELECT COUNT(*) AS "__count"
FROM "ansible_collectionversion"
WHERE "ansible_collectionversion"."certification" = 'certified';
SELECT "core_content"."pulp_id",
"core_content"."pulp_created",
"core_content"."pulp_last_updated",
"core_content"."pulp_type",
"core_content"."upstream_id",
"ansible_collectionversion"."content_ptr_id",
"ansible_collectionversion"."authors",
"ansible_collectionversion"."contents",
"ansible_collectionversion"."dependencies",
"ansible_collectionversion"."description",
"ansible_collectionversion"."docs_blob",
"ansible_collectionversion"."documentation",
"ansible_collectionversion"."homepage",
"ansible_collectionversion"."issues",
"ansible_collectionversion"."license",
"ansible_collectionversion"."name",
"ansible_collectionversion"."namespace",
"ansible_collectionversion"."repository",
"ansible_collectionversion"."version",
"ansible_collectionversion"."is_highest",
"ansible_collectionversion"."certification",
"ansible_collectionversion"."collection_id",
"ansible_collectionversion"."search_vector"
FROM "ansible_collectionversion"
INNER JOIN "core_content" ON ("ansible_collectionversion"."content_ptr_id" = "core_content"."pulp_id")
WHERE "ansible_collectionversion"."certification" = 'certified';
SELECT ("core_contentartifact"."content_id") AS "_prefetch_related_val_content_id",
"core_artifact"."pulp_id",
"core_artifact"."pulp_created",
"core_artifact"."pulp_last_updated",
"core_artifact"."file",
"core_artifact"."size",
"core_artifact"."md5",
"core_artifact"."sha1",
"core_artifact"."sha224",
"core_artifact"."sha256",
"core_artifact"."sha384",
"core_artifact"."sha512"
FROM "core_artifact"
INNER JOIN "core_contentartifact" ON ("core_artifact"."pulp_id" = "core_contentartifact"."artifact_id")
WHERE "core_contentartifact"."content_id" IN
('1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid, '8f29826e-72c5-4fde-8c12-4a04e6071943'::uuid,
'3c22351d-0496-4c51-9d14-fb40baae54d8'::uuid, '18500812-0c77-46a8-8d6e-4912082f605f'::uuid,
'5cce3885-0f15-43b4-b568-08c6020f5a30'::uuid, '49b74715-741d-4f07-bd16-a85b8c9984a9'::uuid,
'02c59105-0ac6-4ea1-a0be-c3d6e2c2bd66'::uuid, '3eb5e666-5963-4285-b885-b8e78aacd45d'::uuid,
'112f686a-cfef-4173-84d1-6d39fa8df181'::uuid, '645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid,
'30f36e96-9704-458e-b7c4-15bc86427061'::uuid, '1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid,
'454dd38e-be64-4d72-a979-8588f2244198'::uuid, '3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid,
'fda889de-94e1-49eb-add4-64dd8ed1ff19'::uuid, '54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid,
'fa76de37-2b93-4883-96ed-cca28d742800'::uuid, '5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid,
'a1e978de-c8cc-4da8-a256-76f46ecc028f'::uuid, '03fe5815-6068-4dce-a328-46d800ad31fb'::uuid,
'72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid, '15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid,
'c5a909a2-c0f3-407c-883e-f908b2ddd529'::uuid, '306944b0-4790-4072-bab3-1bf7814adb50'::uuid,
'e9cd4aa9-a43e-4628-ade6-254139ea0721'::uuid, '1dc8543f-681a-4269-979d-da6f9820522c'::uuid,
'766536ab-8395-4f82-bc98-505612c5daf4'::uuid, '7c54e2f7-e356-4d7a-bd1b-ef86ae9fd1d7'::uuid,
'fd1ad793-4561-4205-a263-b0038ea57b10'::uuid);
SELECT COUNT(*)
FROM (SELECT DISTINCT "core_content"."pulp_id" AS Col1,
"core_content"."pulp_created" AS Col2,
"core_content"."pulp_last_updated" AS Col3,
"core_content"."pulp_type" AS Col4,
"core_content"."upstream_id" AS Col5,
"ansible_collectionversion"."content_ptr_id" AS Col6,
"ansible_collectionversion"."authors" AS Col7,
"ansible_collectionversion"."contents" AS Col8,
"ansible_collectionversion"."dependencies" AS Col9,
"ansible_collectionversion"."description" AS Col10,
"ansible_collectionversion"."docs_blob" AS Col11,
"ansible_collectionversion"."documentation" AS Col12,
"ansible_collectionversion"."homepage" AS Col13,
"ansible_collectionversion"."issues" AS Col14,
"ansible_collectionversion"."license" AS Col15,
"ansible_collectionversion"."name" AS Col16,
"ansible_collectionversion"."namespace" AS Col17,
"ansible_collectionversion"."repository" AS Col18,
"ansible_collectionversion"."version" AS Col19,
"ansible_collectionversion"."is_highest" AS Col20,
"ansible_collectionversion"."certification" AS Col21,
"ansible_collectionversion"."collection_id" AS Col22,
"ansible_collectionversion"."search_vector" AS Col23
FROM "ansible_collectionversion"
INNER JOIN "core_content" ON ("ansible_collectionversion"."content_ptr_id" = "core_content"."pulp_id")
INNER JOIN "ansible_collection"
ON ("ansible_collectionversion"."collection_id" = "ansible_collection"."pulp_id")
WHERE ("ansible_collectionversion"."certification" = 'certified' AND
"ansible_collectionversion"."content_ptr_id" IN
('1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid, '8f29826e-72c5-4fde-8c12-4a04e6071943'::uuid,
'1dc8543f-681a-4269-979d-da6f9820522c'::uuid, '766536ab-8395-4f82-bc98-505612c5daf4'::uuid,
'7c54e2f7-e356-4d7a-bd1b-ef86ae9fd1d7'::uuid, 'fd1ad793-4561-4205-a263-b0038ea57b10'::uuid,
'645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid, '1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid,
'454dd38e-be64-4d72-a979-8588f2244198'::uuid, '3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid,
'fda889de-94e1-49eb-add4-64dd8ed1ff19'::uuid, '54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid,
'fa76de37-2b93-4883-96ed-cca28d742800'::uuid, '5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid,
'a1e978de-c8cc-4da8-a256-76f46ecc028f'::uuid, '03fe5815-6068-4dce-a328-46d800ad31fb'::uuid,
'72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid, '15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid) AND
"ansible_collectionversion"."certification" = 'certified' AND
"ansible_collection"."deprecated" = false)) subquery;
SELECT DISTINCT "core_content"."pulp_id",
"core_content"."pulp_created",
"core_content"."pulp_last_updated",
"core_content"."pulp_type",
"core_content"."upstream_id",
"ansible_collectionversion"."content_ptr_id",
"ansible_collectionversion"."authors",
"ansible_collectionversion"."contents",
"ansible_collectionversion"."dependencies",
"ansible_collectionversion"."description",
"ansible_collectionversion"."docs_blob",
"ansible_collectionversion"."documentation",
"ansible_collectionversion"."homepage",
"ansible_collectionversion"."issues",
"ansible_collectionversion"."license",
"ansible_collectionversion"."name",
"ansible_collectionversion"."namespace",
"ansible_collectionversion"."repository",
"ansible_collectionversion"."version",
"ansible_collectionversion"."is_highest",
"ansible_collectionversion"."certification",
"ansible_collectionversion"."collection_id",
"ansible_collectionversion"."search_vector"
FROM "ansible_collectionversion"
INNER JOIN "core_content" ON ("ansible_collectionversion"."content_ptr_id" = "core_content"."pulp_id")
INNER JOIN "ansible_collection"
ON ("ansible_collectionversion"."collection_id" = "ansible_collection"."pulp_id")
WHERE ("ansible_collectionversion"."certification" = 'certified' AND "ansible_collectionversion"."content_ptr_id" IN
('1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid,
'8f29826e-72c5-4fde-8c12-4a04e6071943'::uuid,
'1dc8543f-681a-4269-979d-da6f9820522c'::uuid,
'766536ab-8395-4f82-bc98-505612c5daf4'::uuid,
'7c54e2f7-e356-4d7a-bd1b-ef86ae9fd1d7'::uuid,
'fd1ad793-4561-4205-a263-b0038ea57b10'::uuid,
'645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid,
'1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid,
'454dd38e-be64-4d72-a979-8588f2244198'::uuid,
'3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid,
'fda889de-94e1-49eb-add4-64dd8ed1ff19'::uuid,
'54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid,
'fa76de37-2b93-4883-96ed-cca28d742800'::uuid,
'5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid,
'a1e978de-c8cc-4da8-a256-76f46ecc028f'::uuid,
'03fe5815-6068-4dce-a328-46d800ad31fb'::uuid,
'72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid,
'15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid) AND
"ansible_collectionversion"."certification" = 'certified' AND "ansible_collection"."deprecated" = false)
LIMIT 12;
SELECT ("core_contentartifact"."content_id") AS "_prefetch_related_val_content_id",
"core_artifact"."pulp_id",
"core_artifact"."pulp_created",
"core_artifact"."pulp_last_updated",
"core_artifact"."file",
"core_artifact"."size",
"core_artifact"."md5",
"core_artifact"."sha1",
"core_artifact"."sha224",
"core_artifact"."sha256",
"core_artifact"."sha384",
"core_artifact"."sha512"
FROM "core_artifact"
INNER JOIN "core_contentartifact" ON ("core_artifact"."pulp_id" = "core_contentartifact"."artifact_id")
WHERE "core_contentartifact"."content_id" IN
('03fe5815-6068-4dce-a328-46d800ad31fb'::uuid, '15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid,
'1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid, '1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid,
'1dc8543f-681a-4269-979d-da6f9820522c'::uuid, '3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid,
'454dd38e-be64-4d72-a979-8588f2244198'::uuid, '54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid,
'5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid, '645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid,
'72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid, '766536ab-8395-4f82-bc98-505612c5daf4'::uuid);
SELECT "ansible_tag"."pulp_id",
"ansible_tag"."pulp_created",
"ansible_tag"."pulp_last_updated",
"ansible_tag"."name"
FROM "ansible_tag"
INNER JOIN "ansible_collectionversion_tags"
ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id")
WHERE "ansible_collectionversion_tags"."collectionversion_id" = '03fe5815-6068-4dce-a328-46d800ad31fb'::uuid;
SELECT "ansible_collection"."pulp_id",
"ansible_collection"."pulp_created",
"ansible_collection"."pulp_last_updated",
"ansible_collection"."namespace",
"ansible_collection"."name",
"ansible_collection"."deprecated"
FROM "ansible_collection"
WHERE "ansible_collection"."pulp_id" = '7c36a2ca-87e3-45c3-b9ca-ecb396c504f2'::uuid;
-- Duplicate queries stripped --
-- ...
Raw
queries_raw.sql
SELECT COUNT(*) AS "__count" FROM "ansible_collectionversion" WHERE "ansible_collectionversion"."certification" = 'certified';
SELECT "core_content"."pulp_id", "core_content"."pulp_created", "core_content"."pulp_last_updated", "core_content"."pulp_type", "core_content"."upstream_id", "ansible_collectionversion"."content_ptr_id", "ansible_collectionversion"."authors", "ansible_collectionversion"."contents", "ansible_collectionversion"."dependencies", "ansible_collectionversion"."description", "ansible_collectionversion"."docs_blob", "ansible_collectionversion"."documentation", "ansible_collectionversion"."homepage", "ansible_collectionversion"."issues", "ansible_collectionversion"."license", "ansible_collectionversion"."name", "ansible_collectionversion"."namespace", "ansible_collectionversion"."repository", "ansible_collectionversion"."version", "ansible_collectionversion"."is_highest", "ansible_collectionversion"."certification", "ansible_collectionversion"."collection_id", "ansible_collectionversion"."search_vector" FROM "ansible_collectionversion" INNER JOIN "core_content" ON ("ansible_collectionversion"."content_ptr_id" = "core_content"."pulp_id") WHERE "ansible_collectionversion"."certification" = 'certified';
SELECT ("core_contentartifact"."content_id") AS "_prefetch_related_val_content_id", "core_artifact"."pulp_id", "core_artifact"."pulp_created", "core_artifact"."pulp_last_updated", "core_artifact"."file", "core_artifact"."size", "core_artifact"."md5", "core_artifact"."sha1", "core_artifact"."sha224", "core_artifact"."sha256", "core_artifact"."sha384", "core_artifact"."sha512" FROM "core_artifact" INNER JOIN "core_contentartifact" ON ("core_artifact"."pulp_id" = "core_contentartifact"."artifact_id") WHERE "core_contentartifact"."content_id" IN ('1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid, '8f29826e-72c5-4fde-8c12-4a04e6071943'::uuid, '3c22351d-0496-4c51-9d14-fb40baae54d8'::uuid, '18500812-0c77-46a8-8d6e-4912082f605f'::uuid, '5cce3885-0f15-43b4-b568-08c6020f5a30'::uuid, '49b74715-741d-4f07-bd16-a85b8c9984a9'::uuid, '02c59105-0ac6-4ea1-a0be-c3d6e2c2bd66'::uuid, '3eb5e666-5963-4285-b885-b8e78aacd45d'::uuid, '112f686a-cfef-4173-84d1-6d39fa8df181'::uuid, '645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid, '30f36e96-9704-458e-b7c4-15bc86427061'::uuid, '1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid, '454dd38e-be64-4d72-a979-8588f2244198'::uuid, '3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid, 'fda889de-94e1-49eb-add4-64dd8ed1ff19'::uuid, '54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid, 'fa76de37-2b93-4883-96ed-cca28d742800'::uuid, '5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid, 'a1e978de-c8cc-4da8-a256-76f46ecc028f'::uuid, '03fe5815-6068-4dce-a328-46d800ad31fb'::uuid, '72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid, '15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid, 'c5a909a2-c0f3-407c-883e-f908b2ddd529'::uuid, '306944b0-4790-4072-bab3-1bf7814adb50'::uuid, 'e9cd4aa9-a43e-4628-ade6-254139ea0721'::uuid, '1dc8543f-681a-4269-979d-da6f9820522c'::uuid, '766536ab-8395-4f82-bc98-505612c5daf4'::uuid, '7c54e2f7-e356-4d7a-bd1b-ef86ae9fd1d7'::uuid, 'fd1ad793-4561-4205-a263-b0038ea57b10'::uuid);
SELECT COUNT(*) FROM (SELECT DISTINCT "core_content"."pulp_id" AS Col1, "core_content"."pulp_created" AS Col2, "core_content"."pulp_last_updated" AS Col3, "core_content"."pulp_type" AS Col4, "core_content"."upstream_id" AS Col5, "ansible_collectionversion"."content_ptr_id" AS Col6, "ansible_collectionversion"."authors" AS Col7, "ansible_collectionversion"."contents" AS Col8, "ansible_collectionversion"."dependencies" AS Col9, "ansible_collectionversion"."description" AS Col10, "ansible_collectionversion"."docs_blob" AS Col11, "ansible_collectionversion"."documentation" AS Col12, "ansible_collectionversion"."homepage" AS Col13, "ansible_collectionversion"."issues" AS Col14, "ansible_collectionversion"."license" AS Col15, "ansible_collectionversion"."name" AS Col16, "ansible_collectionversion"."namespace" AS Col17, "ansible_collectionversion"."repository" AS Col18, "ansible_collectionversion"."version" AS Col19, "ansible_collectionversion"."is_highest" AS Col20, "ansible_collectionversion"."certification" AS Col21, "ansible_collectionversion"."collection_id" AS Col22, "ansible_collectionversion"."search_vector" AS Col23 FROM "ansible_collectionversion" INNER JOIN "core_content" ON ("ansible_collectionversion"."content_ptr_id" = "core_content"."pulp_id") INNER JOIN "ansible_collection" ON ("ansible_collectionversion"."collection_id" = "ansible_collection"."pulp_id") WHERE ("ansible_collectionversion"."certification" = 'certified' AND "ansible_collectionversion"."content_ptr_id" IN ('1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid, '8f29826e-72c5-4fde-8c12-4a04e6071943'::uuid, '1dc8543f-681a-4269-979d-da6f9820522c'::uuid, '766536ab-8395-4f82-bc98-505612c5daf4'::uuid, '7c54e2f7-e356-4d7a-bd1b-ef86ae9fd1d7'::uuid, 'fd1ad793-4561-4205-a263-b0038ea57b10'::uuid, '645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid, '1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid, '454dd38e-be64-4d72-a979-8588f2244198'::uuid, '3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid, 'fda889de-94e1-49eb-add4-64dd8ed1ff19'::uuid, '54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid, 'fa76de37-2b93-4883-96ed-cca28d742800'::uuid, '5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid, 'a1e978de-c8cc-4da8-a256-76f46ecc028f'::uuid, '03fe5815-6068-4dce-a328-46d800ad31fb'::uuid, '72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid, '15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid) AND "ansible_collectionversion"."certification" = 'certified' AND "ansible_collection"."deprecated" = false)) subquery;
SELECT DISTINCT "core_content"."pulp_id", "core_content"."pulp_created", "core_content"."pulp_last_updated", "core_content"."pulp_type", "core_content"."upstream_id", "ansible_collectionversion"."content_ptr_id", "ansible_collectionversion"."authors", "ansible_collectionversion"."contents", "ansible_collectionversion"."dependencies", "ansible_collectionversion"."description", "ansible_collectionversion"."docs_blob", "ansible_collectionversion"."documentation", "ansible_collectionversion"."homepage", "ansible_collectionversion"."issues", "ansible_collectionversion"."license", "ansible_collectionversion"."name", "ansible_collectionversion"."namespace", "ansible_collectionversion"."repository", "ansible_collectionversion"."version", "ansible_collectionversion"."is_highest", "ansible_collectionversion"."certification", "ansible_collectionversion"."collection_id", "ansible_collectionversion"."search_vector" FROM "ansible_collectionversion" INNER JOIN "core_content" ON ("ansible_collectionversion"."content_ptr_id" = "core_content"."pulp_id") INNER JOIN "ansible_collection" ON ("ansible_collectionversion"."collection_id" = "ansible_collection"."pulp_id") WHERE ("ansible_collectionversion"."certification" = 'certified' AND "ansible_collectionversion"."content_ptr_id" IN ('1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid, '8f29826e-72c5-4fde-8c12-4a04e6071943'::uuid, '1dc8543f-681a-4269-979d-da6f9820522c'::uuid, '766536ab-8395-4f82-bc98-505612c5daf4'::uuid, '7c54e2f7-e356-4d7a-bd1b-ef86ae9fd1d7'::uuid, 'fd1ad793-4561-4205-a263-b0038ea57b10'::uuid, '645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid, '1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid, '454dd38e-be64-4d72-a979-8588f2244198'::uuid, '3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid, 'fda889de-94e1-49eb-add4-64dd8ed1ff19'::uuid, '54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid, 'fa76de37-2b93-4883-96ed-cca28d742800'::uuid, '5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid, 'a1e978de-c8cc-4da8-a256-76f46ecc028f'::uuid, '03fe5815-6068-4dce-a328-46d800ad31fb'::uuid, '72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid, '15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid) AND "ansible_collectionversion"."certification" = 'certified' AND "ansible_collection"."deprecated" = false) LIMIT 12;
SELECT ("core_contentartifact"."content_id") AS "_prefetch_related_val_content_id", "core_artifact"."pulp_id", "core_artifact"."pulp_created", "core_artifact"."pulp_last_updated", "core_artifact"."file", "core_artifact"."size", "core_artifact"."md5", "core_artifact"."sha1", "core_artifact"."sha224", "core_artifact"."sha256", "core_artifact"."sha384", "core_artifact"."sha512" FROM "core_artifact" INNER JOIN "core_contentartifact" ON ("core_artifact"."pulp_id" = "core_contentartifact"."artifact_id") WHERE "core_contentartifact"."content_id" IN ('03fe5815-6068-4dce-a328-46d800ad31fb'::uuid, '15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid, '1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid, '1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid, '1dc8543f-681a-4269-979d-da6f9820522c'::uuid, '3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid, '454dd38e-be64-4d72-a979-8588f2244198'::uuid, '54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid, '5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid, '645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid, '72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid, '766536ab-8395-4f82-bc98-505612c5daf4'::uuid);
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '03fe5815-6068-4dce-a328-46d800ad31fb'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = '7c36a2ca-87e3-45c3-b9ca-ecb396c504f2'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '15e56db2-a074-4651-98b8-a9f4f3ae09bb'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = '2bdcb76f-a708-438a-915f-8282925a3d8a'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '1857df28-e2f8-4f3b-a7b9-25dce7b80386'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = '3f78fc44-e85b-4c64-a872-b13dfa84c4d7'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '1c001c13-65bd-4787-90a7-dfbe5c0fa65e'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = 'e358f0fb-b567-495b-ae28-34393f9434df'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '1dc8543f-681a-4269-979d-da6f9820522c'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = '3ac9c951-dffe-4158-b7ed-ec6e1475258d'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '3663b4d0-522c-4d3b-bb5c-1c0bdb10eee1'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = '628cb415-143f-4299-9ece-43ee85a48875'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '454dd38e-be64-4d72-a979-8588f2244198'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = '2a058d64-eecb-443c-afe5-578f79b6d7ba'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '54639874-fc8d-4eef-9213-1ba538ae4a36'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = 'bf2e7860-f61c-4b52-8778-072b34c10737'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '5df72f79-c4cd-4dde-ab50-167c8fbbc056'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = '2f4d94b0-c9d4-4285-916b-84654c50b3bd'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '645c919e-f3dc-409f-93f9-a1824025d6ec'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = 'b179f0a0-b763-4804-b66a-b13d3b016c15'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '72666d9a-d703-4f5f-84e7-636d8e6523f3'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = 'fbd1a8a1-9138-4952-9f43-568863fe8151'::uuid;
SELECT "ansible_tag"."pulp_id", "ansible_tag"."pulp_created", "ansible_tag"."pulp_last_updated", "ansible_tag"."name" FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") WHERE "ansible_collectionversion_tags"."collectionversion_id" = '766536ab-8395-4f82-bc98-505612c5daf4'::uuid;
SELECT "ansible_collection"."pulp_id", "ansible_collection"."pulp_created", "ansible_collection"."pulp_last_updated", "ansible_collection"."namespace", "ansible_collection"."name", "ansible_collection"."deprecated" FROM "ansible_collection" WHERE "ansible_collection"."pulp_id" = '83386307-7bbd-4019-b2df-f6ef31eb986c'::uuid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment