Untitled

From Soiled Camel, 1 Year ago, written in Plain Text.

Embed

Download Paste or View Raw
Hits: 78

SELECT

conversation.conversationId,

TIMEDIFF(conversationEnd, conversationStart)

FROM conversation

INNER JOIN cnpj

ON conversation.conversationId = cnpj.conversationId

WHERE

DATE(conversationStart) BETWEEN '2022-12-04' AND '2022-12-10'

AND flowName = 'PME_V2'

AND TIMEDIFF(conversationEnd, conversationStart) >= '00:01:30'

AND nome_operador <> ''

AND cnpj.queueName IN (

'PME_SAC_1',

'PME_SAC_2',

'PME_SAC_3',

'PME_SAC_4',

'PME_OUTROS_ASSUNTOS',

'PME_PRODUTOS',

'PME_LOGON_1',

'PME_LOGON_2',

'PME_FINANCEIRO'

) AND conversation.conversationId NOT IN (

'00e271dd-5c6e-4ab7-a96a-9942b535973d',

'0a54eacf-da00-43ca-b595-3ef49a4cae86',

'0ae0b132-3e8e-487a-8a77-1d6061ff5119',

'0c9d42a9-2c25-496a-af00-5bd2dc855687',

'0c91939e-3fd3-41a8-b699-59a0fc40be1f',

'0db8af97-2bc5-4105-be7e-2f634419f7bf',

'0e5d313a-1f40-4e36-b9f8-31f44c1e7ba0',

'0e727c62-02bd-4a35-ac0d-c4d9581a7122',

'0e497410-6821-4c34-8604-b5af02232910',

'0fae2c0c-37d8-467c-9af1-d5db04e86e69',

'1a31ee51-4b5e-4597-b81b-a59d1bef3061',

'1b25dfc6-8a71-4532-a2df-d7a4f4cb93ac',

'1b17277e-1c49-42ac-a759-ad293614b3d0',

'1babdb35-f234-4e67-818e-e278c2ee594d',

'1bac5f23-195c-41c2-b3cc-63f88bdb0346',

'1c03aa45-dd3f-4ef2-8b1d-0006a2d14384',

'1c05a267-1cee-4be3-b602-f79252390a4f',

'1c5b70be-dbf6-4462-9614-06a8d9b701dc',

'1c9cd7f5-5cc7-4fed-b424-48d9772c153a',

'1d87f9b3-60ce-4970-b6f1-02c1f9f713ff',

'1d39036c-e845-44f8-a2a6-2950b0e1e09e',

'1e4612da-4e66-4b3e-bea0-6d724c77edb5',

'1f0b5f20-e0d8-4a3c-9e12-fff9acb305e6',

'1f72e54f-aaa9-4664-8edc-2600d606761a',

'1f752f47-e18c-4490-afe1-c64de916b47a',

'1fce8c9d-82f5-4786-a758-4c71ca523a20',

'2a4c2e26-3aa4-41f5-bdd7-7177b740f102',

'2a6cdac8-e0e1-4518-b1eb-e80acdf5d338',

'2d2574c5-7968-487e-bd05-e37996262d68',

'2dcc7d25-204c-483d-93e8-f8248fedfede',

'2e6d8309-0edf-453d-93ca-5553ca299af9',

'2ee71d4f-25ba-4ca8-8294-892dfede5fe7',

'2ef1eec0-6613-481e-a679-db5560f37411',

'03a2c7ff-f782-4985-9bb5-147f786c12ea',

'03ba89c6-97c5-4213-b144-26b08deb8f3b',

'3a47f7b6-a7d4-43b0-8c30-82d8f81557cd',

'3aaeb0d8-49c0-4ad7-8f67-876bd56f14a3',

'3ad9eb29-1616-4786-a4ea-466b2c391559',

'3b552890-56a1-4eb3-b376-ca38a1a54838',

'3bc8441a-f863-4378-b24a-b733f0fd074c',

'3c4dfb8a-d1f5-44f2-aab0-90b221854596',

'3cc0b649-fec4-412d-9fb6-5a6a4b6f5dd8',

'3d0bbadc-b5f3-4142-850c-066c48071893',

'3d1a4d04-5c82-41d7-92e4-0b8e1ae40d8f',

'3d8cf481-53de-47e1-a61f-7767007721f3',

'3d921f53-170a-4fe7-8a06-2bc3e6580ba4',

'3da8d561-952f-4d92-8ccb-eb9a57e27ee5',

'3dbcd0f4-20c3-42bd-b8b2-35e664dab94f',

'3e40aba4-4b2d-4ea9-8126-94115f85e8e3',

'3e49690d-8a86-4894-9fff-ec3a5ea91578',

'3f1984e0-ee15-41c5-93e4-01310789232a',

'4ae0bf32-091e-428f-be79-e9708e0dcb26',

'4d7e0461-58ec-4954-bc41-867194d64dce',

'4d31da91-af2e-4bac-9d9d-d8f527c75454',

'4e2f116f-fefb-4d9a-83ef-daf0998049b2',

'05f4a463-caba-450e-aa0c-4a08c3fa4b9f',

'5a7e7cfa-174c-42be-8685-cea1b75d3fb1',

'5b18115a-4f88-409d-bfc2-dfb10d9c3ac8',

'5bdc936c-0a7d-41b9-b084-26b7d74d42e1',

'5c7d263e-07f8-44a8-8fc0-7537b215448d',

'5d0423a7-70ff-4801-bf31-5bf8f87c7c93',

'5d20119a-7169-4e0e-839c-bc66f2e9836a',

'5f3c8405-bcdb-43b8-994b-595bc55196dc',

'06cfeb05-8595-4f7d-b1db-bdc0e0c6c59a',

'06f2ebd5-4285-4a03-bc81-91c0fc3dc35f',

'6a2e0b7b-29c9-4c8e-aba3-2929426823bc',

'6b0bb881-719a-442c-b330-9e60d1690123',

'6ceba077-f2e7-4c6b-9de5-67bb703bcf68',

'6cf25746-8ac9-4753-a2b8-0bbe7616ff01',

'6d594e14-3a58-46f0-a58f-2c2896ac657e',

'6d547026-5718-4b46-8606-130025e62001',

'6e2f977c-ed8e-481b-b76c-9d12acab39b3',

'6f5610df-3ca8-4435-82ed-b70a95d36a7a',

'6fb8cda8-26e5-4285-97f8-25046f3094b2',

'6fe4c9a0-1d45-442e-bc3f-7329e53fd1e5',

'7a77f384-5cc7-4368-885e-cf4cbf44b8cb',

'7b52995c-7833-4084-939e-6b3fe469e7af',

'7bf5df48-d8bf-4b78-900e-ed4a59144b06',

'7c9e677b-388c-4896-a0e6-81dc0078153a',

'7cc7071d-f05a-4aa9-ad36-5e7cb106356c',

'7d519385-6a65-4c51-b2ac-14d120046305',

'7e5e949a-7b26-40cc-a9e6-258a45ff6539',

'7e62e8df-b140-4fa6-83df-76ab74a98ad2',

'7f2f0ffe-e3a9-4abe-962b-f8ffc350c440',

'8c2b5db5-6aeb-44ad-998d-6839dd4fc9bd',

'8d3feee0-afa8-40cd-8646-8db874c67578',

'8f4f3e0c-482b-4e12-8339-23121c720a11',

'8f471955-dd13-4147-97bf-95db1e2faff1',

'09f40927-4c92-426e-a902-22c3712b06b5',

'9acaf642-5b4d-4057-81a8-26d592740f17',

'9d5db0ef-2ebd-4081-9b35-a5e5a49a60b7',

'9d07f9e8-e05f-43f3-bcd2-041c9b44a546',

'9f0609d0-d587-455a-8f40-502d8cae6575',

'10a65844-0594-488a-8a32-b714e1522e45',

'10cf1ccf-b30f-4f5b-bad1-1e0c24c7be18',

'12c49976-2c4d-4440-908b-03af5879c924',

'14ddbca4-1ab9-4d0a-9e02-591ed9edd5f0',

'19bd784a-76ab-487c-801e-abb19687acf1',

'022e6f5b-df82-47df-bfab-1b3353391f36',

'22f084e2-638e-4ae6-8bf9-d5e3d2a2fc74',

'24a0e885-548c-4cab-800a-09fd624d1037',

'25c4bead-009a-4afd-88fb-0233886bd450',

'25e4e99a-3e05-4ea8-91f8-268f6f64df52',

'27b53cab-6ba0-4b26-8c63-73f23802dee8',

'28ccdd56-68f5-48d1-bfec-5ec1e51a598b',

'28d20bcb-650e-4938-b212-d83cf9118ee4',

'31dfc364-201b-405a-98c4-633c28ccc6ba',

'36bbaade-9c82-4b57-aafe-86cf120d0406',

'037cf2ae-7c8f-4a6c-9ccd-addf2c16710b',

'39c76291-4956-4148-b2c1-0b18e8ad44e3',

'50dde03a-bc67-4355-96b6-699a93fa6572',

'50e6f0b1-3ec1-4bbc-bf03-ce043deda69d',

'51afb58f-3251-4ab7-a024-dbcbd5eec84a',

'51bb6a9e-0e17-4860-99ed-3fda161b16ef',

'54cc0da3-d78c-49ab-aa0a-f3890d100d9c',

'55d9e83a-2877-4f50-af7b-8369f57102be',

'56efcb27-bc03-4f5f-a971-47913b4c14bf',

'58c0622f-16bc-4815-b5e2-f24037a74a0a',

'63a31871-0ae3-4298-b753-2c60e27e1c8d',

'64e558dd-22ff-4d2a-860c-f23a4025d4da',

'69ef97cb-9703-4fc8-81f5-ebea0ff0cca0',

'71c98e72-7b15-4183-bc45-5f7d78e253f5',

'72b4e8e3-d13d-4d5f-a8c4-5be0e84c1e6e',

'74cf7597-20eb-43b6-a7ee-b440f6d54901',

'75ededc6-1a27-481a-a1c8-52ff433e6f01',

'76a46c33-88e2-4c90-8ab0-d96a0ac49e61',

'80c474a0-3f1b-4690-9b8d-6296cdac841a',

'80e2e47e-42a9-49d4-aeb1-455239fb4601',

'80f998d0-daff-41c1-8cba-46ac1318dfc6',

'81cd7a3e-a8c6-4230-b4dd-f7e8f5c3f93d',

'82d05ec1-6260-4255-a017-d0f7f41c9655',

'83dab7bb-11a6-4e50-ba41-42994be44da9',

'85dabf1d-4d1c-4288-b95a-54b8966511a0',

'087ee3de-2516-433d-9f9e-e377690f78ad',

'89cff558-b88b-4fa6-b2e4-ea8a83af5f20',

'90a0604e-1193-4806-bb6c-aef478b353eb',

'91fe63dc-24f1-4626-b66c-555661c8233b',

'092b05db-a8c1-4005-abe7-132de269dbe8',

'95afd7ca-ea00-4da3-8709-444dfd43b641',

'96dc2510-0957-4957-913f-5e3634386926',

'98d409ba-a8c8-4bfb-888e-7a919b058d79',

'98dedceb-cd1b-48c4-925c-4219736b0746',

'99b31ad0-bee8-4639-89c5-99570db33103',

'99c29587-46da-4693-bc9c-9dda020fbe9f',

'124d2f4c-d5d8-43f3-8116-0a720878fc73',

'133dd557-2903-41da-9915-3f1d4e9540be',

'145cf38f-938d-4af9-8bf3-e18df0ed3c69',

'154aa91f-be5f-410e-916b-49b63a4ab5ca',

'179c663c-bebe-4eea-83b4-ccaf6cc64997',

'202d3d95-2093-4835-b2b7-c4bce83c453f',

'227d9ad8-88c2-419c-a0c6-c6208ed79ff6',

'250b0e43-1eb1-4c0c-a2c3-4e364d274553',

'270a48b5-8c7d-42bd-acc7-98f8e9dc3d06',

'286fe0ef-1d7a-42f6-957f-b499066168d8',

'373a313d-0022-4cc7-bae4-57d8d82e98a2',

'389c9605-1054-4848-be5e-e9738e58b734',

'392defee-2825-439d-b162-34a8e531b68b',

'393ed674-fc64-4be5-8a59-5e3890d46fc3',

'453ad71c-9ca8-41c5-a9c9-e731b35a6037',

'508bfe9e-c882-4e11-9c87-48149900dd34',

'513df539-6ed5-4473-9296-4bf8f010ce8b',

'537ffb79-2286-44ee-a9b1-40cf7244af1e',

'576df4cb-3723-4cbe-a379-d92d02170ae2',

'589b5fe4-8918-48f1-a1f6-ffe3b2f4010e',

'713b644e-e6f4-4dcd-a9c8-cfdc7df316a9',

'722d7414-b426-471f-8a6a-4d2135656fb7',

'729faafe-ce5d-463f-af9a-c584863d6018',

'787b636c-9d24-498a-8dcf-7e57829de719',

'838a2dea-e2cf-48ea-b151-92219a072297',

'847ac3f1-5eb4-4108-88c5-c989283ebc16',

'893a2a96-2e42-4a91-aa95-485c6d86effd',

'1712a9e7-6b82-42c9-9361-03f337afcab7',

'1720c2d2-90fc-4faf-87dc-2ad0fa7dc9e0',

'1886af20-a9b8-496c-bfea-fa9c3a1e49d2',

'1891a2ce-8fdf-4253-8e49-aab8df17c3ea',

'2561bc2b-26a6-43e1-869d-9db234c910f3',

'2603a8e1-3cb5-4cc7-a17b-adae283ce012',

'3584ac6e-1cdc-4d18-9ce3-75c4f2e7d046',

'05691ab3-5d64-4183-855f-d0584b171536',

'6330e577-a174-42e2-af8f-29d90dc69556',

'6445b476-4fb0-4011-b9a1-1d4a3c3832b7',

'6468f0b4-5ec2-4212-852f-a33f52a0a0a0',

'6556e999-ff4a-487f-bc49-7b9202089eb1',

'6879d111-4c4e-4003-b4b9-d3730ac76dc1',

'6963c010-a407-4473-8fa0-276918f46c9a',

'7099a809-62e6-4afd-8a21-eb9ece7705f3',

'7434aae0-0655-42ce-8d89-bd7e1227d2d4',

'07780a49-f069-4b4b-b491-d5b54e9a4cde',

'8008a571-e9ab-4437-9c73-5f387703833b',

'8010f5ec-c1d9-4f8a-84f0-f947963ea1dc',

'8479cf49-966e-45e6-bfcc-509037e4b58d',

'08756b47-2882-43b2-931c-d520755ca811',

'8815d0e7-9165-4bf5-b4ac-3664bf00e90c',

'9107dfb8-a0fb-4467-94dd-35ddc3cc5071',

'9196a44b-2513-4c9b-9895-31bdd1cee6ef',

'25475ef7-18ce-43a8-b139-f17228224ecf',

'032049b3-b2a0-412f-b9c0-79f964839bbf',

'43246b1a-586f-4d35-b06c-eb78e967f458',

'60586bc0-78eb-4607-ba32-9b21b3c2f49e',

'68448c9d-1e31-467f-b5b7-ec181224fb82',

'80798ef8-750a-442a-9ba0-1554193d4e42',

'86634d6b-bd66-43ba-9ae1-54c273ab6289',

'99289b09-53ae-44d4-b5e3-59888b9415b0',

'108729e7-0898-4242-a44f-6685e933ff96',

'129641ba-154f-423f-96d5-486e27d15498',

'146008a5-8c3c-4225-a5c3-ded9eefd48fe',

'566679a6-412f-43ab-b83b-aba7490345ed',

'768119d9-8894-4dc0-8814-0b70d5c2979a',

'932820eb-2949-4123-bc11-09ba5fd96ed3',

'1691856c-1461-43e6-9c9d-ebe353a1c1fb',

'3265601b-6b9f-40c8-bca0-fed15dec68db',

'6384117f-b507-45b8-91be-c2db7f3aa87b',

'7841990b-d51b-4a4b-a05a-aa926565f306',

'09590991-2fe8-495c-a897-0053272afa65',

'29814845-6925-4d3d-aef6-109eb7e6f6a3',

'30185837-946f-469e-bc00-1bd956d3342a',

'49584184-0ed3-48ff-9c55-29c1b47718e4',

'65140659-17f2-4e41-8c8d-7960596dab8e',

'70477185-0476-4001-9b5d-2f9a27a20b1d',

'76374477-c223-4106-af07-31777b44543b',

'82961498-fcb6-4c9b-85d1-66a76efd6b46',

'a4e79490-b7a5-43b9-b824-949849f8e6f9',

'a4ec1dfe-ac18-4eb7-a839-7b22e8036101',

'a4f96af6-07a5-4105-9a4b-54ead880b72e',

'a6a51ff7-72bf-47aa-a05b-0784fc7abd35',

'a7bc7163-cff1-46f1-8e2e-109be4af412f',

'a7cf3952-3bb7-4ce5-8c11-2abe2f7bfad1',

'a8bc3f7a-aff8-4d4c-8007-2a2212ea6dcb',

'a8bfc33e-3cb6-48b2-b9d2-10ab87cdb6f4',

'a45f814e-ce5f-4828-8d0d-b5b2eb9ed1ea',

'a57a642e-81bf-4097-86b3-3bfb26340d83',

'a81cf90c-8e89-4f2b-b298-2f52703bd98f',

'a337d8fc-96a5-4610-8563-549a0f2d779c',

'a439d0c0-69ee-47f2-bf08-19fb97b01148',

'a499b41e-f60f-4694-b547-7d057e0feb9d',

'a722c43f-f8a9-4d4a-84f5-11dbe947dc81',

'a952b6b5-a6db-4c39-9603-55e78dc028b8',

'aa4115b4-43fd-4086-ad7b-d3ae5ee631cd',

'aa918160-3783-4f5b-b896-36881761f240',

'ab7b4d08-b867-4b4c-bc77-b6582d4366ba',

'ab87b884-87b3-4bcb-bedb-c263a3218584',

'ac66db8d-3b01-4f79-b722-9b97503c0b49',

'ac86ec57-7c44-433c-9009-ec247ec2df0d',

'ac0247db-697c-4ca9-81d0-695d0dbb801a',

'ad4ac740-7baf-4959-8f45-a35bfcf263ec',

'ad6fbf30-3222-44d3-bfe5-5a00dd176137',

'ae8fbdcd-3161-4b41-9e1e-a48c0d5739b6',

'aef649c8-6530-40a6-abe1-3c07260e3d39',

'afcb3522-1cfb-4ae9-8d4d-d705b823e73b',

'b4ef730a-a6c0-4aa7-b9dc-781e1f33ba65',

'b7ef85c1-d0c6-4c1b-a4b0-397f0dcd9f74',

'b9a52e70-7564-41f2-8c04-a2fcf4f0e8d7',

'b9b5b8c2-e9fc-4586-ab8f-5dbfebf58ab4',

'b9f583db-14b1-458b-a722-bab0d95d0075',

'b21fa889-88da-4fb4-bece-861ece8a8c99',

'b36d9f91-b4c6-4bd1-b6ba-d831874dd4ec',

'b48ba926-79cb-4b96-81bc-3c88a8ddd3b7',

'b076bd0b-bfcf-4a01-889c-2884711748aa',

'b77a2023-1672-4f03-8f54-f775337e5d97',

'b910d46a-4c9f-419c-947d-fcc6509f0eb1',

'b1594e82-60ad-42c7-97d1-5755dcfd06d0',

'b4528239-0c6f-40cb-b184-3837c59f9546',

'ba44f71e-70c1-41e1-a68f-9fbcb3bfd98c',

'ba536fbf-ab41-4dd3-9fc0-03ce1e0deda5',

'baa3556d-96a2-471b-9908-1072aeee50ba',

'bae65984-60b5-4b77-97bc-f99787edcc80',

'bb53d057-b45e-450a-b39f-b2dcc2c415e9',

'bc5763bf-071f-4a93-a099-4d28a099eb69',

'bc202175-6cc7-4f87-bc6d-0e4bebad5dc0',

'bca146a4-b75a-4fdc-b75f-aeaa506af005',

'bd28782b-9c82-4460-914c-a4f69af46eae',

'bd920402-a21f-43c5-baec-df0b23580d6e',

'be4e7102-c560-413f-bde7-698db4c9a435',

'bebe2fb3-3dc6-44a5-bd4e-f15b9aff412a',

'bedb3a75-e522-4b3b-bf55-5e728cc91d33',

'bee3eeb3-7f6a-4ffe-bc10-8f927e9ddef8',

'c5d8216c-deac-4b3a-b30f-eeac668831b4',

'c06fcf25-df4b-460b-a3af-fd5e7fdea2b8',

'c6ccf370-6728-483e-9dd4-440f9b3a50f3',

'c43b4f40-a7ff-42f4-bfd0-c68f31c04ae4',

'c045eb7e-ec43-4fa4-8372-89d8eadb894a',

'c49b53b4-5210-4cd7-98f1-891c245e8436',

'c63ff59c-515d-4100-8c6d-803fe34ba633',

'c69d4474-2a51-412d-9d5b-7b31a2d266df',

'c74ec393-8f52-4fef-88af-ba4442127b6c',

'c393e72c-fdbb-447f-a9e8-fd8958e3e5a9',

'c6358a6c-ac22-4587-bc37-09bc9b11fccf',

'c06656f4-3d83-485a-8211-c2d2f003a1d6',

'c93270b9-830a-43ea-9266-6c48d78246f9',

'ca401475-46d2-4438-a53e-5e1a260a8538',

'ca914943-f1b9-490f-a87e-a4f88c680176',

'cac0a1ad-7eb8-424e-94f2-184f190bc34f',

'cac3aef8-8138-4714-897e-ee8ea5070409',

'cb1d0064-f38a-4cf2-b3c9-212f5f850e55',

'cb8c6531-7087-42ab-ad65-088fe826ec1d',

'cc4dc180-bbbd-4093-ba37-59b8ab0a22b7',

'cc577aad-dddb-4611-a02c-0b1613166b8a',

'ccfd6247-ff60-4289-92e5-962de57f4989',

'ccff3de4-5eb1-4714-8ed2-cb2caf9796fc',

'ce7daf78-f77b-4f4b-a585-ee84a22cc3b2',

'ce9c1993-ce99-489c-8d00-d9f54ed89a7a',

'ce64e716-6218-40b6-a8bd-9084158b614b',

'cfbb7553-11c5-438e-b681-eb39c244aa5c',

'cfe454da-9a21-4a00-b675-63fef4980707',

'd1e76a6b-46e9-42bd-8957-c271868d9710',

'd5a6f37a-fcdd-44c9-997d-8bdac3b81ecc',

'd6f901ad-58e9-423c-9821-ddc644aed08b',

'd8f8e4a9-af81-4605-876c-5eeb6a47d768',

'd55aa49a-76e0-424f-b8f4-b14f5eac810d',

'd78d16be-8e9b-4f01-8337-19dc38c18c47',

'd434e441-e8b4-4616-aec6-8a5e4e5e02ce',

'd836ab50-2a1f-44ca-ba42-49630339e968',

'd0386379-9b6f-454e-830b-4d3405a5b4d4',

'd1369717-16b5-4edc-a7c4-c9c8943cd13b',

'da2f4771-e6e5-4790-a2c1-f99e26b500ab',

'da545a6d-01ae-420d-a7e3-c25d1d61eb75',

'db3c35e4-fc48-4d68-a3dd-2a3a004b8ec4',

'db6da9be-47f8-451d-8401-ad3d4e1481d6',

'db056cf7-7734-4d79-b075-fcc95c5e7ef5',

'dbab7b6e-b561-47e4-b806-1ed75839c7a5',

'dbed6220-e7a8-48cd-baef-33041df23d02',

'dc176d65-fdce-4a79-a864-d7d9383286b4',

'dd8c1859-8b62-442c-a229-34ecc156eb5f',

'de7b16b5-e60f-413f-8a4e-cd7b118be170',

'de13dc34-a0f1-405d-856f-e573d3bffe4f',

'de64dbd6-77de-4f4a-8b99-ca0549c6fe3c',

'de754705-7db1-4e76-8125-da482950c857',

'df108376-3141-4317-9e08-10b5b8c078c6',

'dfab3628-6180-40db-9c82-1e8d69a29f26',

'e0dffcb1-c591-43d6-bead-7469ffb0c2fd',

'e1fa23e2-8c97-4737-aa16-c346b4048c14',

'e2dcb358-2c1d-4f35-8367-e420d247b82e',

'e4af1074-6af5-4a0c-9075-4f77f00854f8',

'e4b71de2-7243-4b6e-b493-48eef6362823',

'e4ceb3c3-d4cd-437a-a341-ddc0bf688322',

'e4d4f7c7-0b0f-4893-b487-5001a8d6b7bc',

'e8bfeae4-7f9c-4720-bc1c-41aad9e16e75',

'e9c7e77b-4d12-4bc0-8ff8-f19ad4a46e37',

'e77e39af-7517-4c87-84fd-53af8119d621',

'e43980ef-a192-4d64-8498-5dea5935bee9',

'e876266c-5b11-4fb9-aa52-8c6096a9ac5f',

'e993872d-f620-4fcd-ad14-8497f58cae53',

'e9751133-b989-42a9-b590-f2f909103432',

'ea53b942-1ecf-4a98-8e30-4fdd01b445e7',

'eafd66f3-8d91-4ad3-ac22-393185062d1c',

'eb561f68-463e-4c4b-b3cd-2fac6be06235',

'eb668972-6542-435e-929a-b9d5ce82ced9',

'eba300ca-3877-4df8-87d5-a4bec05b0538',

'ed44e703-e06e-4c60-9a6f-bede4e77ec57',

'ede625e6-473e-427f-a3cc-f702c3e5350b',

'ee306053-39da-46c5-90ee-0da985c8308e',

'eea0512b-fc0f-4ec0-abb5-a4b11bcce15e',

'ef7d8334-5d10-472e-9d9d-bf3689a74954',

'f0b9683d-97d5-49f4-9ab6-7bfa4cd286ff',

'f1b4f357-7985-48fc-a01d-6385005a5c28',

'f3fc912e-373c-4cdf-bf5d-82e8866a4a77',

'f4aaa33a-5612-4280-8098-5592042a4095',

'f4eb7d96-3203-40d8-9c51-ebf9fedd0866',

'f4f60edc-2399-436a-b536-750fd93b9fb0',

'f5ad2fa6-8977-4451-b623-18348d71e286',

'f5be2c72-520f-40cd-a1cd-519056956d30',

'f6a11f16-95e0-485d-bd16-ca9274c05f3b',

'f8d32ab8-ae4c-4060-9871-58fc15a524c3',

'f8d9676a-cb19-4079-8f50-40ca50e28997',

'f16fafa0-7aae-4961-a08f-2231465255a1',

'f18be162-9935-4c88-9484-a45605e1084d',

'f45d3f03-3f3a-480d-96e7-7c222b9bb9ff',

'f46c103e-7308-4548-8762-cbaacd5945b7',

'f65d9c82-994b-440c-b2b3-7dbb16b74bf4',

'f74e0b16-9c96-471a-9827-65498f1f0142',

'f79bcc82-59e5-4a40-a045-b5c515fd72f8',

'f9243a70-7118-4a03-8eb7-f80e333c7ce8',

'f5500831-2f7f-477a-9e39-be056798ebd9',

'fa2cd1ad-39b6-450c-bb33-5cadcf3bc69d',

'fade82c4-b1d0-4e37-aec7-652392545b3c',

'fb31151b-6006-44ab-9f5d-ce57053c73c3',

'fbcbe999-fa3b-4515-a565-51066ec140ad',

'fcdacce1-2b77-497d-8ae2-231cd8f57355',

'ff4905a3-f5a9-488a-bcc1-468e70ed2dee',

'ffbef39b-d6d1-4b33-8742-54d5cf112dd2'

)

group by conversationId

ORDER BY TIMEDIFF(conversationEnd, conversationStart) ASC

LIMIT 600

OFFSET 0;

Author

Title

Language

Your paste - Paste your paste here

SELECT 
            conversation.conversationId,
            TIMEDIFF(conversationEnd, conversationStart)
        FROM conversation
        INNER JOIN cnpj
        ON conversation.conversationId = cnpj.conversationId
        WHERE 
            DATE(conversationStart) BETWEEN '2022-12-04' AND '2022-12-10'
            AND flowName = 'PME_V2'
            AND TIMEDIFF(conversationEnd, conversationStart) &gt;= '00:01:30'
            AND nome_operador &lt;&gt; ''
            AND cnpj.queueName IN (
                'PME_SAC_1',
                'PME_SAC_2',
                'PME_SAC_3',
                'PME_SAC_4',
                'PME_OUTROS_ASSUNTOS',
                'PME_PRODUTOS',
                'PME_LOGON_1',
                'PME_LOGON_2',
                'PME_FINANCEIRO'
            ) AND conversation.conversationId NOT IN (
                '00e271dd-5c6e-4ab7-a96a-9942b535973d',
                '0a54eacf-da00-43ca-b595-3ef49a4cae86',
                '0ae0b132-3e8e-487a-8a77-1d6061ff5119',
                '0c9d42a9-2c25-496a-af00-5bd2dc855687',
                '0c91939e-3fd3-41a8-b699-59a0fc40be1f',
                '0db8af97-2bc5-4105-be7e-2f634419f7bf',
                '0e5d313a-1f40-4e36-b9f8-31f44c1e7ba0',
                '0e727c62-02bd-4a35-ac0d-c4d9581a7122',
                '0e497410-6821-4c34-8604-b5af02232910',
                '0fae2c0c-37d8-467c-9af1-d5db04e86e69',
                '1a31ee51-4b5e-4597-b81b-a59d1bef3061',
                '1b25dfc6-8a71-4532-a2df-d7a4f4cb93ac',
                '1b17277e-1c49-42ac-a759-ad293614b3d0',
                '1babdb35-f234-4e67-818e-e278c2ee594d',
                '1bac5f23-195c-41c2-b3cc-63f88bdb0346',
                '1c03aa45-dd3f-4ef2-8b1d-0006a2d14384',
                '1c05a267-1cee-4be3-b602-f79252390a4f',
                '1c5b70be-dbf6-4462-9614-06a8d9b701dc',
                '1c9cd7f5-5cc7-4fed-b424-48d9772c153a',
                '1d87f9b3-60ce-4970-b6f1-02c1f9f713ff',
                '1d39036c-e845-44f8-a2a6-2950b0e1e09e',
                '1e4612da-4e66-4b3e-bea0-6d724c77edb5',
                '1f0b5f20-e0d8-4a3c-9e12-fff9acb305e6',
                '1f72e54f-aaa9-4664-8edc-2600d606761a',
                '1f752f47-e18c-4490-afe1-c64de916b47a',
                '1fce8c9d-82f5-4786-a758-4c71ca523a20',
                '2a4c2e26-3aa4-41f5-bdd7-7177b740f102',
                '2a6cdac8-e0e1-4518-b1eb-e80acdf5d338',
                '2d2574c5-7968-487e-bd05-e37996262d68',
                '2dcc7d25-204c-483d-93e8-f8248fedfede',
                '2e6d8309-0edf-453d-93ca-5553ca299af9',
                '2ee71d4f-25ba-4ca8-8294-892dfede5fe7',
                '2ef1eec0-6613-481e-a679-db5560f37411',
                '03a2c7ff-f782-4985-9bb5-147f786c12ea',
                '03ba89c6-97c5-4213-b144-26b08deb8f3b',
                '3a47f7b6-a7d4-43b0-8c30-82d8f81557cd',
                '3aaeb0d8-49c0-4ad7-8f67-876bd56f14a3',
                '3ad9eb29-1616-4786-a4ea-466b2c391559',
                '3b552890-56a1-4eb3-b376-ca38a1a54838',
                '3bc8441a-f863-4378-b24a-b733f0fd074c',
                '3c4dfb8a-d1f5-44f2-aab0-90b221854596',
                '3cc0b649-fec4-412d-9fb6-5a6a4b6f5dd8',
                '3d0bbadc-b5f3-4142-850c-066c48071893',
                '3d1a4d04-5c82-41d7-92e4-0b8e1ae40d8f',
                '3d8cf481-53de-47e1-a61f-7767007721f3',
                '3d921f53-170a-4fe7-8a06-2bc3e6580ba4',
                '3da8d561-952f-4d92-8ccb-eb9a57e27ee5',
                '3dbcd0f4-20c3-42bd-b8b2-35e664dab94f',
                '3e40aba4-4b2d-4ea9-8126-94115f85e8e3',
                '3e49690d-8a86-4894-9fff-ec3a5ea91578',
                '3f1984e0-ee15-41c5-93e4-01310789232a',
                '4ae0bf32-091e-428f-be79-e9708e0dcb26',
                '4d7e0461-58ec-4954-bc41-867194d64dce',
                '4d31da91-af2e-4bac-9d9d-d8f527c75454',
                '4e2f116f-fefb-4d9a-83ef-daf0998049b2',
                '05f4a463-caba-450e-aa0c-4a08c3fa4b9f',
                '5a7e7cfa-174c-42be-8685-cea1b75d3fb1',
                '5b18115a-4f88-409d-bfc2-dfb10d9c3ac8',
                '5bdc936c-0a7d-41b9-b084-26b7d74d42e1',
                '5c7d263e-07f8-44a8-8fc0-7537b215448d',
                '5d0423a7-70ff-4801-bf31-5bf8f87c7c93',
                '5d20119a-7169-4e0e-839c-bc66f2e9836a',
                '5f3c8405-bcdb-43b8-994b-595bc55196dc',
                '06cfeb05-8595-4f7d-b1db-bdc0e0c6c59a',
                '06f2ebd5-4285-4a03-bc81-91c0fc3dc35f',
                '6a2e0b7b-29c9-4c8e-aba3-2929426823bc',
                '6b0bb881-719a-442c-b330-9e60d1690123',
                '6ceba077-f2e7-4c6b-9de5-67bb703bcf68',
                '6cf25746-8ac9-4753-a2b8-0bbe7616ff01',
                '6d594e14-3a58-46f0-a58f-2c2896ac657e',
                '6d547026-5718-4b46-8606-130025e62001',
                '6e2f977c-ed8e-481b-b76c-9d12acab39b3',
                '6f5610df-3ca8-4435-82ed-b70a95d36a7a',
                '6fb8cda8-26e5-4285-97f8-25046f3094b2',
                '6fe4c9a0-1d45-442e-bc3f-7329e53fd1e5',
                '7a77f384-5cc7-4368-885e-cf4cbf44b8cb',
                '7b52995c-7833-4084-939e-6b3fe469e7af',
                '7bf5df48-d8bf-4b78-900e-ed4a59144b06',
                '7c9e677b-388c-4896-a0e6-81dc0078153a',
                '7cc7071d-f05a-4aa9-ad36-5e7cb106356c',
                '7d519385-6a65-4c51-b2ac-14d120046305',
                '7e5e949a-7b26-40cc-a9e6-258a45ff6539',
                '7e62e8df-b140-4fa6-83df-76ab74a98ad2',
                '7f2f0ffe-e3a9-4abe-962b-f8ffc350c440',
                '8c2b5db5-6aeb-44ad-998d-6839dd4fc9bd',
                '8d3feee0-afa8-40cd-8646-8db874c67578',
                '8f4f3e0c-482b-4e12-8339-23121c720a11',
                '8f471955-dd13-4147-97bf-95db1e2faff1',
                '09f40927-4c92-426e-a902-22c3712b06b5',
                '9acaf642-5b4d-4057-81a8-26d592740f17',
                '9d5db0ef-2ebd-4081-9b35-a5e5a49a60b7',
                '9d07f9e8-e05f-43f3-bcd2-041c9b44a546',
                '9f0609d0-d587-455a-8f40-502d8cae6575',
                '10a65844-0594-488a-8a32-b714e1522e45',
                '10cf1ccf-b30f-4f5b-bad1-1e0c24c7be18',
                '12c49976-2c4d-4440-908b-03af5879c924',
                '14ddbca4-1ab9-4d0a-9e02-591ed9edd5f0',
                '19bd784a-76ab-487c-801e-abb19687acf1',
                '022e6f5b-df82-47df-bfab-1b3353391f36',
                '22f084e2-638e-4ae6-8bf9-d5e3d2a2fc74',
                '24a0e885-548c-4cab-800a-09fd624d1037',
                '25c4bead-009a-4afd-88fb-0233886bd450',
                '25e4e99a-3e05-4ea8-91f8-268f6f64df52',
                '27b53cab-6ba0-4b26-8c63-73f23802dee8',
                '28ccdd56-68f5-48d1-bfec-5ec1e51a598b',
                '28d20bcb-650e-4938-b212-d83cf9118ee4',
                '31dfc364-201b-405a-98c4-633c28ccc6ba',
                '36bbaade-9c82-4b57-aafe-86cf120d0406',
                '037cf2ae-7c8f-4a6c-9ccd-addf2c16710b',
                '39c76291-4956-4148-b2c1-0b18e8ad44e3',
                '50dde03a-bc67-4355-96b6-699a93fa6572',
                '50e6f0b1-3ec1-4bbc-bf03-ce043deda69d',
                '51afb58f-3251-4ab7-a024-dbcbd5eec84a',
                '51bb6a9e-0e17-4860-99ed-3fda161b16ef',
                '54cc0da3-d78c-49ab-aa0a-f3890d100d9c',
                '55d9e83a-2877-4f50-af7b-8369f57102be',
                '56efcb27-bc03-4f5f-a971-47913b4c14bf',
                '58c0622f-16bc-4815-b5e2-f24037a74a0a',
                '63a31871-0ae3-4298-b753-2c60e27e1c8d',
                '64e558dd-22ff-4d2a-860c-f23a4025d4da',
                '69ef97cb-9703-4fc8-81f5-ebea0ff0cca0',
                '71c98e72-7b15-4183-bc45-5f7d78e253f5',
                '72b4e8e3-d13d-4d5f-a8c4-5be0e84c1e6e',
                '74cf7597-20eb-43b6-a7ee-b440f6d54901',
                '75ededc6-1a27-481a-a1c8-52ff433e6f01',
                '76a46c33-88e2-4c90-8ab0-d96a0ac49e61',
                '80c474a0-3f1b-4690-9b8d-6296cdac841a',
                '80e2e47e-42a9-49d4-aeb1-455239fb4601',
                '80f998d0-daff-41c1-8cba-46ac1318dfc6',
                '81cd7a3e-a8c6-4230-b4dd-f7e8f5c3f93d',
                '82d05ec1-6260-4255-a017-d0f7f41c9655',
                '83dab7bb-11a6-4e50-ba41-42994be44da9',
                '85dabf1d-4d1c-4288-b95a-54b8966511a0',
                '087ee3de-2516-433d-9f9e-e377690f78ad',
                '89cff558-b88b-4fa6-b2e4-ea8a83af5f20',
                '90a0604e-1193-4806-bb6c-aef478b353eb',
                '91fe63dc-24f1-4626-b66c-555661c8233b',
                '092b05db-a8c1-4005-abe7-132de269dbe8',
                '95afd7ca-ea00-4da3-8709-444dfd43b641',
                '96dc2510-0957-4957-913f-5e3634386926',
                '98d409ba-a8c8-4bfb-888e-7a919b058d79',
                '98dedceb-cd1b-48c4-925c-4219736b0746',
                '99b31ad0-bee8-4639-89c5-99570db33103',
                '99c29587-46da-4693-bc9c-9dda020fbe9f',
                '124d2f4c-d5d8-43f3-8116-0a720878fc73',
                '133dd557-2903-41da-9915-3f1d4e9540be',
                '145cf38f-938d-4af9-8bf3-e18df0ed3c69',
                '154aa91f-be5f-410e-916b-49b63a4ab5ca',
                '179c663c-bebe-4eea-83b4-ccaf6cc64997',
                '202d3d95-2093-4835-b2b7-c4bce83c453f',
                '227d9ad8-88c2-419c-a0c6-c6208ed79ff6',
                '250b0e43-1eb1-4c0c-a2c3-4e364d274553',
                '270a48b5-8c7d-42bd-acc7-98f8e9dc3d06',
                '286fe0ef-1d7a-42f6-957f-b499066168d8',
                '373a313d-0022-4cc7-bae4-57d8d82e98a2',
                '389c9605-1054-4848-be5e-e9738e58b734',
                '392defee-2825-439d-b162-34a8e531b68b',
                '393ed674-fc64-4be5-8a59-5e3890d46fc3',
                '453ad71c-9ca8-41c5-a9c9-e731b35a6037',
                '508bfe9e-c882-4e11-9c87-48149900dd34',
                '513df539-6ed5-4473-9296-4bf8f010ce8b',
                '537ffb79-2286-44ee-a9b1-40cf7244af1e',
                '576df4cb-3723-4cbe-a379-d92d02170ae2',
                '589b5fe4-8918-48f1-a1f6-ffe3b2f4010e',
                '713b644e-e6f4-4dcd-a9c8-cfdc7df316a9',
                '722d7414-b426-471f-8a6a-4d2135656fb7',
                '729faafe-ce5d-463f-af9a-c584863d6018',
                '787b636c-9d24-498a-8dcf-7e57829de719',
                '838a2dea-e2cf-48ea-b151-92219a072297',
                '847ac3f1-5eb4-4108-88c5-c989283ebc16',
                '893a2a96-2e42-4a91-aa95-485c6d86effd',
                '1712a9e7-6b82-42c9-9361-03f337afcab7',
                '1720c2d2-90fc-4faf-87dc-2ad0fa7dc9e0',
                '1886af20-a9b8-496c-bfea-fa9c3a1e49d2',
                '1891a2ce-8fdf-4253-8e49-aab8df17c3ea',
                '2561bc2b-26a6-43e1-869d-9db234c910f3',
                '2603a8e1-3cb5-4cc7-a17b-adae283ce012',
                '3584ac6e-1cdc-4d18-9ce3-75c4f2e7d046',
                '05691ab3-5d64-4183-855f-d0584b171536',
                '6330e577-a174-42e2-af8f-29d90dc69556',
                '6445b476-4fb0-4011-b9a1-1d4a3c3832b7',
                '6468f0b4-5ec2-4212-852f-a33f52a0a0a0',
                '6556e999-ff4a-487f-bc49-7b9202089eb1',
                '6879d111-4c4e-4003-b4b9-d3730ac76dc1',
                '6963c010-a407-4473-8fa0-276918f46c9a',
                '7099a809-62e6-4afd-8a21-eb9ece7705f3',
                '7434aae0-0655-42ce-8d89-bd7e1227d2d4',
                '07780a49-f069-4b4b-b491-d5b54e9a4cde',
                '8008a571-e9ab-4437-9c73-5f387703833b',
                '8010f5ec-c1d9-4f8a-84f0-f947963ea1dc',
                '8479cf49-966e-45e6-bfcc-509037e4b58d',
                '08756b47-2882-43b2-931c-d520755ca811',
                '8815d0e7-9165-4bf5-b4ac-3664bf00e90c',
                '9107dfb8-a0fb-4467-94dd-35ddc3cc5071',
                '9196a44b-2513-4c9b-9895-31bdd1cee6ef',
                '25475ef7-18ce-43a8-b139-f17228224ecf',
                '032049b3-b2a0-412f-b9c0-79f964839bbf',
                '43246b1a-586f-4d35-b06c-eb78e967f458',
                '60586bc0-78eb-4607-ba32-9b21b3c2f49e',
                '68448c9d-1e31-467f-b5b7-ec181224fb82',
                '80798ef8-750a-442a-9ba0-1554193d4e42',
                '86634d6b-bd66-43ba-9ae1-54c273ab6289',
                '99289b09-53ae-44d4-b5e3-59888b9415b0',
                '108729e7-0898-4242-a44f-6685e933ff96',
                '129641ba-154f-423f-96d5-486e27d15498',
                '146008a5-8c3c-4225-a5c3-ded9eefd48fe',
                '566679a6-412f-43ab-b83b-aba7490345ed',
                '768119d9-8894-4dc0-8814-0b70d5c2979a',
                '932820eb-2949-4123-bc11-09ba5fd96ed3',
                '1691856c-1461-43e6-9c9d-ebe353a1c1fb',
                '3265601b-6b9f-40c8-bca0-fed15dec68db',
                '6384117f-b507-45b8-91be-c2db7f3aa87b',
                '7841990b-d51b-4a4b-a05a-aa926565f306',
                '09590991-2fe8-495c-a897-0053272afa65',
                '29814845-6925-4d3d-aef6-109eb7e6f6a3',
                '30185837-946f-469e-bc00-1bd956d3342a',
                '49584184-0ed3-48ff-9c55-29c1b47718e4',
                '65140659-17f2-4e41-8c8d-7960596dab8e',
                '70477185-0476-4001-9b5d-2f9a27a20b1d',
                '76374477-c223-4106-af07-31777b44543b',
                '82961498-fcb6-4c9b-85d1-66a76efd6b46',
                'a4e79490-b7a5-43b9-b824-949849f8e6f9',
                'a4ec1dfe-ac18-4eb7-a839-7b22e8036101',
                'a4f96af6-07a5-4105-9a4b-54ead880b72e',
                'a6a51ff7-72bf-47aa-a05b-0784fc7abd35',
                'a7bc7163-cff1-46f1-8e2e-109be4af412f',
                'a7cf3952-3bb7-4ce5-8c11-2abe2f7bfad1',
                'a8bc3f7a-aff8-4d4c-8007-2a2212ea6dcb',
                'a8bfc33e-3cb6-48b2-b9d2-10ab87cdb6f4',
                'a45f814e-ce5f-4828-8d0d-b5b2eb9ed1ea',
                'a57a642e-81bf-4097-86b3-3bfb26340d83',
                'a81cf90c-8e89-4f2b-b298-2f52703bd98f',
                'a337d8fc-96a5-4610-8563-549a0f2d779c',
                'a439d0c0-69ee-47f2-bf08-19fb97b01148',
                'a499b41e-f60f-4694-b547-7d057e0feb9d',
                'a722c43f-f8a9-4d4a-84f5-11dbe947dc81',
                'a952b6b5-a6db-4c39-9603-55e78dc028b8',
                'aa4115b4-43fd-4086-ad7b-d3ae5ee631cd',
                'aa918160-3783-4f5b-b896-36881761f240',
                'ab7b4d08-b867-4b4c-bc77-b6582d4366ba',
                'ab87b884-87b3-4bcb-bedb-c263a3218584',
                'ac66db8d-3b01-4f79-b722-9b97503c0b49',
                'ac86ec57-7c44-433c-9009-ec247ec2df0d',
                'ac0247db-697c-4ca9-81d0-695d0dbb801a',
                'ad4ac740-7baf-4959-8f45-a35bfcf263ec',
                'ad6fbf30-3222-44d3-bfe5-5a00dd176137',
                'ae8fbdcd-3161-4b41-9e1e-a48c0d5739b6',
                'aef649c8-6530-40a6-abe1-3c07260e3d39',
                'afcb3522-1cfb-4ae9-8d4d-d705b823e73b',
                'b4ef730a-a6c0-4aa7-b9dc-781e1f33ba65',
                'b7ef85c1-d0c6-4c1b-a4b0-397f0dcd9f74',
                'b9a52e70-7564-41f2-8c04-a2fcf4f0e8d7',
                'b9b5b8c2-e9fc-4586-ab8f-5dbfebf58ab4',
                'b9f583db-14b1-458b-a722-bab0d95d0075',
                'b21fa889-88da-4fb4-bece-861ece8a8c99',
                'b36d9f91-b4c6-4bd1-b6ba-d831874dd4ec',
                'b48ba926-79cb-4b96-81bc-3c88a8ddd3b7',
                'b076bd0b-bfcf-4a01-889c-2884711748aa',
                'b77a2023-1672-4f03-8f54-f775337e5d97',
                'b910d46a-4c9f-419c-947d-fcc6509f0eb1',
                'b1594e82-60ad-42c7-97d1-5755dcfd06d0',
                'b4528239-0c6f-40cb-b184-3837c59f9546',
                'ba44f71e-70c1-41e1-a68f-9fbcb3bfd98c',
                'ba536fbf-ab41-4dd3-9fc0-03ce1e0deda5',
                'baa3556d-96a2-471b-9908-1072aeee50ba',
                'bae65984-60b5-4b77-97bc-f99787edcc80',
                'bb53d057-b45e-450a-b39f-b2dcc2c415e9',
                'bc5763bf-071f-4a93-a099-4d28a099eb69',
                'bc202175-6cc7-4f87-bc6d-0e4bebad5dc0',
                'bca146a4-b75a-4fdc-b75f-aeaa506af005',
                'bd28782b-9c82-4460-914c-a4f69af46eae',
                'bd920402-a21f-43c5-baec-df0b23580d6e',
                'be4e7102-c560-413f-bde7-698db4c9a435',
                'bebe2fb3-3dc6-44a5-bd4e-f15b9aff412a',
                'bedb3a75-e522-4b3b-bf55-5e728cc91d33',
                'bee3eeb3-7f6a-4ffe-bc10-8f927e9ddef8',
                'c5d8216c-deac-4b3a-b30f-eeac668831b4',
                'c06fcf25-df4b-460b-a3af-fd5e7fdea2b8',
                'c6ccf370-6728-483e-9dd4-440f9b3a50f3',
                'c43b4f40-a7ff-42f4-bfd0-c68f31c04ae4',
                'c045eb7e-ec43-4fa4-8372-89d8eadb894a',
                'c49b53b4-5210-4cd7-98f1-891c245e8436',
                'c63ff59c-515d-4100-8c6d-803fe34ba633',
                'c69d4474-2a51-412d-9d5b-7b31a2d266df',
                'c74ec393-8f52-4fef-88af-ba4442127b6c',
                'c393e72c-fdbb-447f-a9e8-fd8958e3e5a9',
                'c6358a6c-ac22-4587-bc37-09bc9b11fccf',
                'c06656f4-3d83-485a-8211-c2d2f003a1d6',
                'c93270b9-830a-43ea-9266-6c48d78246f9',
                'ca401475-46d2-4438-a53e-5e1a260a8538',
                'ca914943-f1b9-490f-a87e-a4f88c680176',
                'cac0a1ad-7eb8-424e-94f2-184f190bc34f',
                'cac3aef8-8138-4714-897e-ee8ea5070409',
                'cb1d0064-f38a-4cf2-b3c9-212f5f850e55',
                'cb8c6531-7087-42ab-ad65-088fe826ec1d',
                'cc4dc180-bbbd-4093-ba37-59b8ab0a22b7',
                'cc577aad-dddb-4611-a02c-0b1613166b8a',
                'ccfd6247-ff60-4289-92e5-962de57f4989',
                'ccff3de4-5eb1-4714-8ed2-cb2caf9796fc',
                'ce7daf78-f77b-4f4b-a585-ee84a22cc3b2',
                'ce9c1993-ce99-489c-8d00-d9f54ed89a7a',
                'ce64e716-6218-40b6-a8bd-9084158b614b',
                'cfbb7553-11c5-438e-b681-eb39c244aa5c',
                'cfe454da-9a21-4a00-b675-63fef4980707',
                'd1e76a6b-46e9-42bd-8957-c271868d9710',
                'd5a6f37a-fcdd-44c9-997d-8bdac3b81ecc',
                'd6f901ad-58e9-423c-9821-ddc644aed08b',
                'd8f8e4a9-af81-4605-876c-5eeb6a47d768',
                'd55aa49a-76e0-424f-b8f4-b14f5eac810d',
                'd78d16be-8e9b-4f01-8337-19dc38c18c47',
                'd434e441-e8b4-4616-aec6-8a5e4e5e02ce',
                'd836ab50-2a1f-44ca-ba42-49630339e968',
                'd0386379-9b6f-454e-830b-4d3405a5b4d4',
                'd1369717-16b5-4edc-a7c4-c9c8943cd13b',
                'da2f4771-e6e5-4790-a2c1-f99e26b500ab',
                'da545a6d-01ae-420d-a7e3-c25d1d61eb75',
                'db3c35e4-fc48-4d68-a3dd-2a3a004b8ec4',
                'db6da9be-47f8-451d-8401-ad3d4e1481d6',
                'db056cf7-7734-4d79-b075-fcc95c5e7ef5',
                'dbab7b6e-b561-47e4-b806-1ed75839c7a5',
                'dbed6220-e7a8-48cd-baef-33041df23d02',
                'dc176d65-fdce-4a79-a864-d7d9383286b4',
                'dd8c1859-8b62-442c-a229-34ecc156eb5f',
                'de7b16b5-e60f-413f-8a4e-cd7b118be170',
                'de13dc34-a0f1-405d-856f-e573d3bffe4f',
                'de64dbd6-77de-4f4a-8b99-ca0549c6fe3c',
                'de754705-7db1-4e76-8125-da482950c857',
                'df108376-3141-4317-9e08-10b5b8c078c6',
                'dfab3628-6180-40db-9c82-1e8d69a29f26',
                'e0dffcb1-c591-43d6-bead-7469ffb0c2fd',
                'e1fa23e2-8c97-4737-aa16-c346b4048c14',
                'e2dcb358-2c1d-4f35-8367-e420d247b82e',
                'e4af1074-6af5-4a0c-9075-4f77f00854f8',
                'e4b71de2-7243-4b6e-b493-48eef6362823',
                'e4ceb3c3-d4cd-437a-a341-ddc0bf688322',
                'e4d4f7c7-0b0f-4893-b487-5001a8d6b7bc',
                'e8bfeae4-7f9c-4720-bc1c-41aad9e16e75',
                'e9c7e77b-4d12-4bc0-8ff8-f19ad4a46e37',
                'e77e39af-7517-4c87-84fd-53af8119d621',
                'e43980ef-a192-4d64-8498-5dea5935bee9',
                'e876266c-5b11-4fb9-aa52-8c6096a9ac5f',
                'e993872d-f620-4fcd-ad14-8497f58cae53',
                'e9751133-b989-42a9-b590-f2f909103432',
                'ea53b942-1ecf-4a98-8e30-4fdd01b445e7',
                'eafd66f3-8d91-4ad3-ac22-393185062d1c',
                'eb561f68-463e-4c4b-b3cd-2fac6be06235',
                'eb668972-6542-435e-929a-b9d5ce82ced9',
                'eba300ca-3877-4df8-87d5-a4bec05b0538',
                'ed44e703-e06e-4c60-9a6f-bede4e77ec57',
                'ede625e6-473e-427f-a3cc-f702c3e5350b',
                'ee306053-39da-46c5-90ee-0da985c8308e',
                'eea0512b-fc0f-4ec0-abb5-a4b11bcce15e',
                'ef7d8334-5d10-472e-9d9d-bf3689a74954',
                'f0b9683d-97d5-49f4-9ab6-7bfa4cd286ff',
                'f1b4f357-7985-48fc-a01d-6385005a5c28',
                'f3fc912e-373c-4cdf-bf5d-82e8866a4a77',
                'f4aaa33a-5612-4280-8098-5592042a4095',
                'f4eb7d96-3203-40d8-9c51-ebf9fedd0866',
                'f4f60edc-2399-436a-b536-750fd93b9fb0',
                'f5ad2fa6-8977-4451-b623-18348d71e286',
                'f5be2c72-520f-40cd-a1cd-519056956d30',
                'f6a11f16-95e0-485d-bd16-ca9274c05f3b',
                'f8d32ab8-ae4c-4060-9871-58fc15a524c3',
                'f8d9676a-cb19-4079-8f50-40ca50e28997',
                'f16fafa0-7aae-4961-a08f-2231465255a1',
                'f18be162-9935-4c88-9484-a45605e1084d',
                'f45d3f03-3f3a-480d-96e7-7c222b9bb9ff',
                'f46c103e-7308-4548-8762-cbaacd5945b7',
                'f65d9c82-994b-440c-b2b3-7dbb16b74bf4',
                'f74e0b16-9c96-471a-9827-65498f1f0142',
                'f79bcc82-59e5-4a40-a045-b5c515fd72f8',
                'f9243a70-7118-4a03-8eb7-f80e333c7ce8',
                'f5500831-2f7f-477a-9e39-be056798ebd9',
                'fa2cd1ad-39b6-450c-bb33-5cadcf3bc69d',
                'fade82c4-b1d0-4e37-aec7-652392545b3c',
                'fb31151b-6006-44ab-9f5d-ce57053c73c3',
                'fbcbe999-fa3b-4515-a565-51066ec140ad',
                'fcdacce1-2b77-497d-8ae2-231cd8f57355',
                'ff4905a3-f5a9-488a-bcc1-468e70ed2dee',
                'ffbef39b-d6d1-4b33-8742-54d5cf112dd2'
                )
        group by conversationId
        ORDER BY TIMEDIFF(conversationEnd, conversationStart) ASC
        LIMIT 600
        OFFSET 0;

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

Spam protection -

Reply to "Untitled"