API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 19th, 2019
537
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 38.94 KB | None | 0 0
raw download clone embed print report
  1. select COUNT(scan_log.id) as count, scan_log.object_id, v.vehicle_type_id, IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 0 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 604800, '1 Weeks', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 604800 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 1209600, '2 Weeks', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 1209600 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 1814400, '3 Weeks', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 1814400 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 2419200, '1 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 2419200 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 5256000, '2 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 5256000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 7884000, '3 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 7884000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 10512000, '4 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 10512000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 13140000, '5 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 13140000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 15768000, '6 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 15768000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 18396000, '7 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 18396000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 21024000, '8 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 21024000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 23652000, '9 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 23652000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 26280000, '10 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 26280000 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 28908060, '11 Months', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 28908060 && IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) <= 31536060, '1 Years', IF(IF(scan_log.aging_time IS NULL, TIMESTAMPDIFF(SECOND, scan_log.created_at, NOW()), scan_log.aging_time) >= 31536060, '>1 Tahun', '' ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) ) as aging_type from `scan_log` inner join \n
  2. (\n
  3. SELECT id,vehicle_type_id \n
  4. FROM vehicles \n
  5. WHERE vehicles.agent_code = 'mpm-motor' AND vehicles.vehicle_type_id IN ('01e88a60-b69c-11e9-a2e1-338a22ca9fc0','063e3860-8c08-11e9-a725-a39ee0ae689c','0a54bc20-8e3d-11e9-97ce-fb387783db72','10062b80-9ee2-11e9-a714-3da7ec4878fa','10b3ec70-b614-11e9-bddb-e9f15eead83e','124a3380-9186-11e9-8d5e-6501d664db73','134e7760-b614-11e9-b6cd-87420f628528','18c875b0-ac58-11e9-93dd-859c63e241fa','18fb1aa0-98cd-11e9-98e9-61bf73e57751','19125d30-c24f-11e9-a2e5-b1fb41910ba5','19992220-b748-11e9-975a-a73ed7fd0de9','19fc27d0-8b4d-11e9-8ad9-675abc02bc10','19fc3aa0-b69b-11e9-8e9c-8357b8c5f8bb','1e5c27e0-ae9a-11e9-8c18-7f79feb578b0','1f0d3170-b614-11e9-970b-3762abd67ba2','1fc4cbf0-ae9a-11e9-a279-51562474f3ad','203db2e0-b614-11e9-aef9-1f906cdadbd7','218e2f90-8b4d-11e9-b098-91258d6fdd80','24598040-b6a6-11e9-8625-5b4d48cd7823','25dc81a0-c24f-11e9-a4a4-c9a216504e49','25fb1c40-8cda-11e9-93e6-11350c93bd30','26084fb0-9645-11e9-bd06-e72514d998a4','26f72ba0-8396-11e9-b362-ebadb3d7b832','27799600-8b4d-11e9-8e25-a335885cfe80','2a323ab0-8b4d-11e9-8222-3b8aa5e9b048','2af5bcf0-b02d-11e9-ba16-73589d75cb3c','2de17520-ae9c-11e9-93dd-9fc10e2b78dd','2f93da10-c25f-11e9-b04c-91f5c96e3534','315605e0-9b96-11e9-81ab-5d5bff21cb50','316efa10-8c07-11e9-9254-dfd7aebbdc54','325103a0-b765-11e9-a376-fd04e476c277','327864e0-8ce9-11e9-a5cf-c537a38185dc','3459eb60-8ce9-11e9-8d8e-0f3e0cf67e92','35a19740-ac3e-11e9-902c-eb88881cbee6','384dd220-98b5-11e9-b4bd-89f89ad8613c','385e9470-ae99-11e9-a67a-6116720f4696','391b6600-b71d-11e9-a470-a35432706509','3931dbc0-b749-11e9-8eac-8da444f4c8bc','3caca560-b614-11e9-904b-fd823a93fe87','3d400970-919f-11e9-b6d6-2134d321df0c','3ee263c0-8c07-11e9-b940-479a9650c099','3f232f30-b747-11e9-9a18-3d3d9943d106','4126a780-8bee-11e9-9242-ab934b10d7ab','4146c480-ac3e-11e9-8101-69aee23c497d','42465bd0-c262-11e9-8fad-1bee494c4c5a','42e0bac0-b749-11e9-ba27-65b009f9efd0','42f46ce0-b745-11e9-9b36-250ef4d12dbf','43c92c00-90c0-11e9-b8ea-6515dcbbce4b','45b642e0-ac3e-11e9-895a-654909b73a1b','45d845e0-919f-11e9-a260-1f72a0204567','4b643ee0-8e3e-11e9-88b7-edda3f968044','4c682b40-8b47-11e9-a590-f95e4fd293f9','4d45def0-9641-11e9-9654-819cfaa45d52','4fd2cdc0-ae9c-11e9-bacb-e545377742fa','5005dd10-ae9c-11e9-8390-152584423e68','5122c5e0-b740-11e9-9c6c-15845ca32ba5','541a6480-b67d-11e9-a3f2-0be224f69e72','56d45960-ae9c-11e9-94d9-856eab53a106','577eb3b0-8b4d-11e9-8c60-7dc887618a01','5a7d6000-b6a0-11e9-9bf8-635509ae27fd','5bc8dae0-8ce9-11e9-aa7e-1be83ac27199','5ccbf9a0-90be-11e9-83ae-1f8dfd0f9208','5e6433c0-ae9c-11e9-9326-437a7ef2e38a','609832b0-90be-11e9-b91a-4dc56c09e5f2','61014660-ae9c-11e9-8ef7-c9f7264d88c0','616c2a00-ae9c-11e9-8f3a-792ea18322f9','62f997a0-8b47-11e9-bd00-297055e697f0','630e2070-8e7d-11e9-bc98-51ec55f6b44c','64d68f80-8b47-11e9-b96a-d39bd937c83c','659e79e0-8b47-11e9-8a03-7948c3f6bdf3','68512e80-8cda-11e9-9b7e-93cc53bc98e0','69446940-b767-11e9-ab43-57678edcf436','69461890-b895-11e9-8880-d1864cac7280','6948adc0-b895-11e9-a5fc-d39c97921ff6','6949c9d0-b895-11e9-a58d-d508acec75cd','694acb40-b895-11e9-8922-219379cb5b47','694bf7b0-b895-11e9-bd12-19a6b17f7908','694d0870-b895-11e9-86d1-374dc08ac57d','694e0580-b895-11e9-889e-b78eab4b6ec3','694f1250-b895-11e9-9f85-93ca09786b28','69503110-9947-11e9-af36-fd30d77e044d','695047d0-b895-11e9-9d54-b5dab933479f','69520210-b895-11e9-9c32-afd2a5a1175e','69532d60-b895-11e9-ac66-73a7da4f849b','69559950-b895-11e9-ae2e-e14571eee081','69587e80-b895-11e9-9a66-99fea04b2093','6959fc40-b895-11e9-ac27-d1b1ec94d36b','695b7570-b895-11e9-a194-0f749b4f1639','695cae10-b895-11e9-996a-030ae4e1a64c','695dd380-b895-11e9-938f-854fb028f1ec','695f4050-b895-11e9-91c9-a58082a0ff0c','69604e40-b895-11e9-b265-934a9e64f160','69614f10-b895-11e9-9aa5-576240199c05','69624f10-b895-11e9-be45-d195df02516c','696373a0-b895-11e9-9194-b16317ed7957','69647d60-b895-11e9-9f31-33dcdff51989','696585a0-b895-11e9-8b0e-6b936eb45ed4','69669700-b895-11e9-84a1-fd52c89d8a8f','6967b3d0-b895-11e9-b43c-a784c3a664f9','69693a90-b895-11e9-858b-c76920f05071','696ac880-b895-11e9-8302-55950cda766e','696c2b50-b895-11e9-bb8f-513c96a660ef','696e29e0-b895-11e9-84a1-2f6a48fc9eb9','697060c0-b895-11e9-8288-1f7e5d22c037','6971cae0-b895-11e9-b036-7b83cd4584eb','6972efa0-b895-11e9-a650-99d7d2e1acb8','69740550-b895-11e9-adaa-3bda0a991e21','69751de0-b895-11e9-8324-49903454fc31','69762890-b895-11e9-bec2-550420d868fe','69772f50-b895-11e9-8127-85410deb6f39','69783ce0-b895-11e9-be35-7d6d55c69a66','69794f10-b895-11e9-8ed0-7d1a35547090','697a4d10-b895-11e9-9263-0bc69fcf3b9d','697b69f0-b895-11e9-9b9c-03cf2e98ccfa','697dc7a0-b895-11e9-b0f1-056882d250b1','69811d60-b895-11e9-8cbd-a76e13eb87dd','698244a0-b895-11e9-909e-25232fa14ec3','69836ad0-b895-11e9-89e4-255a06ab7373','6984b300-b895-11e9-b557-e5b0f2f2090c','6985b710-b895-11e9-8fb6-4baa2804591a','6986c3a0-b895-11e9-bb07-4d892df65217','698832b0-b895-11e9-9096-e57fb8265998','698a6440-b895-11e9-9ee2-9bfb8b909aa3','698b7040-b895-11e9-b89a-2d90a372fa35','698c6620-b699-11e9-a79f-af7ab41f086d','698eb740-b895-11e9-ac84-3f0979430c70','69913b60-b895-11e9-8db6-f50a1c03bc8a','69926f00-b895-11e9-9818-9bf87c9a425e','6993e8c0-b895-11e9-b2b2-c9338a14479c','6994ec60-b895-11e9-bc58-fdec930398db','6995fb90-b895-11e9-8f10-3db9fb07ed3d','69970f80-b895-11e9-a533-8360d5f4f9cd','69983f50-b895-11e9-89cc-8344e3d971b1','699962a0-b895-11e9-bf85-137edfc63b69','699a7370-b895-11e9-bff6-bb9a62479b9a','699b85e0-b895-11e9-b43f-c95f54099d00','699c92b0-b895-11e9-ab56-e744685894bb','699db520-b895-11e9-bba7-2b734548eadf','69a091e0-b895-11e9-932a-3344b22a7bc5','69a27440-b895-11e9-ac19-6fc19de7bdec','69a44480-b895-11e9-aca4-7b696a18ee3f','69a57530-b895-11e9-87ae-4f8fd81ffd61','69a682b0-b895-11e9-baf2-758fdd55cd3f','69a78fe0-b895-11e9-83d5-13a28564a19b','69a89920-b895-11e9-b661-bd188112a3ed','69a9aee0-b895-11e9-81d2-110acc460ad1','69aab120-b895-11e9-a7bc-55b1be661be2','69abc580-b895-11e9-b9b9-23e6adfee3b3','69accf20-b895-11e9-ba97-234d3a933031','69addc10-b895-11e9-84e7-35a922724325','69b18740-b895-11e9-ba7a-0770155af54c','69b758b0-b895-11e9-9048-ef123456358a','69b85d80-b895-11e9-b0bd-6fd87fefdd27','69b963c0-b895-11e9-9abe-3bccc39303f1','69ba6ff0-b895-11e9-b379-6d473c002c62','69bbec70-b895-11e9-8663-4f64f6e8523a','69bd2b40-b895-11e9-92ba-db4ceb2bf660','69bea060-b895-11e9-b4e8-af2ebb3579e1','69bfcb20-b895-11e9-98f8-e59c5179794b','69c2d600-b895-11e9-ad3f-13e7b72fb6a7','69c404a0-b895-11e9-b233-eb005a185946','69c51910-b895-11e9-aec7-4fdf0baef64f','69c632c0-b895-11e9-af27-d93f8c958ffc','69c74a40-b895-11e9-b14b-7302fb0ebdd0','69c86150-b895-11e9-9c60-7d05b2342280','69c97170-b895-11e9-b124-8b667da5472b','69ca83e0-b895-11e9-9590-c7013aff1497','69cb9820-b895-11e9-abe3-affa11e6052e','69cf0be0-b895-11e9-bea5-1ddc74553e62','69d03c80-b895-11e9-8ddb-17e97e65daaa','69d20890-b895-11e9-9c12-f3e4caa08e11','69d34ae0-b895-11e9-9769-b174c9e695d8','69d47bc0-b895-11e9-bf4a-439076a1a5d5','69d58dc0-b895-11e9-ad28-07220b1363ca','69d694a0-b895-11e9-8d93-275cfd9ca45e','69d7afc0-b895-11e9-b86c-2b1108bf707d','69d8b520-b895-11e9-ae1b-258c029fe552','69d9c670-b895-11e9-a415-a581fd42efac','69daea20-b895-11e9-85ec-e34698fa1228','69dc6060-b895-11e9-8329-bbea88d42e15','69dde9b0-b895-11e9-81a9-9f97e13dd90d','69df5a30-b895-11e9-8ba7-0576e1a5ff7d','69e0d300-b895-11e9-8570-b7bce80797ae','69e3bb30-b895-11e9-b820-1f862a59a0e8','69e524f0-b895-11e9-bae1-f9e199418dc5','69e65880-b895-11e9-b72c-e12ca3fd4e1e','69e76ea0-b895-11e9-a507-4bb38bfa2559','69e88d40-b895-11e9-8ed3-55aea117c5ce','69e99e90-b895-11e9-a1d2-070eb721ea22','69ebea90-b895-11e9-8476-778e221a06f8','69eee480-b895-11e9-a767-c59a579a9326','69f017a0-b895-11e9-ba12-d7e9e62020af','69f43c30-b895-11e9-b32b-a121ac09738f','69f5fae0-b895-11e9-a1a0-833ec3cf29cc','69f70780-b895-11e9-b70e-65e06878b6c9','69f808c0-b895-11e9-b4e9-9f61662c371f','69f916e0-b895-11e9-a158-0bf0a9d334cf','69fa1ec0-b895-11e9-99ed-a76ae3778a07','69fb29f0-b895-11e9-9f5c-0f7019e6b8f7','69fc3810-b895-11e9-9d04-cd548aff218a','69fd3ad0-b895-11e9-9675-410452842be9','69fe4960-b895-11e9-a286-35865ec2d5b2','6a028230-b895-11e9-90e3-dd61af612177','6a03f700-b895-11e9-bd1a-43fa725b63c6','6a0566b0-b895-11e9-9d34-992bf4f610fa','6a068440-b895-11e9-99f5-8fd77e0a6a4a','6a07cff0-b895-11e9-8be6-73c9cf044743','6a0b9fb0-b895-11e9-b40f-51e8ac55dc77','6a0ca390-b895-11e9-9c7b-43f98ce1dcfa','6a0ea5d0-b895-11e9-ad7b-1fd8134a9ce4','6a141c60-b895-11e9-a2d4-55f2869bf101','6a154580-b895-11e9-b787-957c1f44a4be','6a17c300-b895-11e9-94be-ebe0a5b414de','6a18d9c0-b895-11e9-a42b-a95860584bda','6a19e510-b895-11e9-bf11-11e0e66b5c3c','6a1b20e0-b895-11e9-9158-b9c6a4d6b58c','6a1c3170-b895-11e9-95a0-9b813fd3448b','6a1d39a0-b895-11e9-8886-edc991e365f7','6a1e3520-b895-11e9-b974-ad9c96bdfad3','6a1f3ed0-b895-11e9-9d29-3da10c4b6110','6a203f00-b895-11e9-b64f-6dbb94d69fa3','6a215010-b895-11e9-913d-c124aee492cf','6a229f20-b895-11e9-ba17-971114e1e237','6a254460-b895-11e9-a1cb-3bf66f651f35','6a266fc0-b895-11e9-a375-dd83c73c6efa','6a287030-b895-11e9-ba98-3755b2ff16cb','6a2a85d0-b895-11e9-809a-a7fda5c84e71','6a2ba930-b895-11e9-a27c-e7199ed5156b','6a2cbc80-b895-11e9-b7fd-f9e41057d6f6','6a2dc970-b895-11e9-9d1e-cbb4b64ad68a','6a2ed640-b895-11e9-883b-13c4472dd3da','6a2fe5b0-b895-11e9-a42a-e9d0a29e70d2','6a30ec20-b895-11e9-993f-153604e7f8b2','6a331ad0-b895-11e9-a4a6-c70cb6c1e84b','6a344ca0-b895-11e9-aedb-899414598303','6a368d40-b895-11e9-8804-8ffbc6fc1262','6a37e040-b895-11e9-91c4-1fa385b9146c','6a39c100-b895-11e9-8679-07f473ee40d7','6a3b11e0-b895-11e9-ad13-51d77fc97357','6a3c2c60-b895-11e9-8ae9-5f16c6c15d94','6a3d2de0-b895-11e9-9298-994355367b19','6a3e4220-b895-11e9-bcb6-019fbb225140','6a3f4310-b895-11e9-94cf-73e4ba889546','6a405420-b895-11e9-a855-51459ed96076','6a41af20-b895-11e9-a913-792abcef53f4','6a432900-b895-11e9-9c52-a77c39ad10a1','6a44ac00-b895-11e9-8cc7-37368177440d','6a4718e0-b895-11e9-8f2b-8d13ddee006b','6a48efc0-b895-11e9-86dd-cbcdb10de29c','6a4a61e0-b895-11e9-a3dd-2bb4713e8f85','6a4b7180-b895-11e9-b913-332af88b9491','6a4c7ae0-b895-11e9-811b-bf65d5e247d4','6a4d8220-b895-11e9-bf8b-23f4a88a1680','6a4e8300-b895-11e9-a854-0b41709040da','6a4f8e70-b895-11e9-bf88-a5d37e5ce56a','6a5098d0-b895-11e9-9769-b55b5de49ded','6a51a3e0-b895-11e9-ab87-4bbb5a1c5bb6','6a52b300-b895-11e9-825b-c1625fee5968','6a581ec0-b895-11e9-a95b-0b02f6f98813','6a59ce80-b895-11e9-b6b0-cb9100ef7d94','6a5b2440-b895-11e9-a532-dfd1465e4224','6a5c2fe0-b895-11e9-b8aa-118bbbc3e417','6a5ddc50-b895-11e9-808e-e35606112c0a','6a5ee6f0-b895-11e9-a11c-675de46008b2','6a7ab0f0-b895-11e9-acdd-e9cf64fc9559','6a7bdfb0-b895-11e9-80c1-bbbcd3d82be8','6a7ce960-b895-11e9-a1b3-99c25d2573b7','6a7de790-b895-11e9-b0e3-610824743e17','6a7ef510-b895-11e9-92c4-61d5e77dff2d','6a800c00-b895-11e9-9143-c94f4b6b0f52','6a810a70-b895-11e9-a859-a147d5a3afea','6a8210e0-b895-11e9-af66-393a87885a6d','6a831db0-b895-11e9-93d3-09991a42c7ff','6a842010-b895-11e9-a532-0bf589bc0d35','6a853a50-b895-11e9-9644-c5c69d7946aa','6a86f880-b895-11e9-8078-8720721c740c','6a896ad0-b895-11e9-a5ba-254e8ad24172','6a8ae810-b895-11e9-bccd-e575e19418ba','6a8cd190-b895-11e9-9671-ddd1503d2a75','6a8def60-b895-11e9-bfec-759e66e75083','6a8f3d20-b895-11e9-adba-65ade0e4717c','6a92b630-b895-11e9-83e1-e72dc5008bfc','6a93b5f0-b895-11e9-8666-3f54e37ded71','6a94c360-b895-11e9-a1a9-9d6779124b2a','6a95c4a0-b895-11e9-a8d3-0b0398ee3b05','6a96d420-b895-11e9-9706-11a748aa1a8c','6a980ff0-b895-11e9-af46-67d36ce01ebe','6a994f90-b895-11e9-af20-8dcf8ca50415','6a9b03c0-b895-11e9-9a4c-f53391389994','6a9d4c30-b895-11e9-86c1-71d3293d567b','6aa01040-b895-11e9-86ac-87751e365289','6aa13a60-b895-11e9-ba92-4732d2457172','6aa24f70-b895-11e9-810e-f5b088cefa83','6aa35800-b895-11e9-9571-418a54cee84a','6aa45ce0-b895-11e9-a565-0d3ecf48a49d','6aa58540-b895-11e9-8c6e-fd9c0788fe2a','6aa68e70-b895-11e9-bd3c-69749c152a48','6aa796c0-b895-11e9-b30e-d37450960737','6aa89d80-b895-11e9-9e5f-9fafd6461ea6','6aa9b080-b895-11e9-9fe2-bfccd74983ea','6aada280-b895-11e9-b00a-d5540c793dad','6aaed380-b895-11e9-8267-c3922eb72761','6ab04180-b895-11e9-939f-1d1cce0a3029','6ab1aa50-b895-11e9-9c50-8537f335005b','6ab2b3a0-b895-11e9-a91a-eb953c6a1b9a','6ab3b7e0-b895-11e9-8ce1-454795adbbf8','6ab4bd60-b895-11e9-8aa9-a3b2fb3be20c','6ab5d0b0-b895-11e9-8ca5-031ddd90c721','6ab6d8a0-b895-11e9-8250-b9bf9152c687','6ab7e520-b895-11e9-b18a-8b1d37f9c892','6ab8f700-b895-11e9-afb3-05751895ffda','6aba0bf0-b895-11e9-8d82-73f70d4d7119','6abd0d10-b895-11e9-a4a5-f77d29aeb029','6abe35f0-b895-11e9-95db-1b3919c6dd0d','6abf6690-b895-11e9-80b2-875f68e04d02','6ac0ed40-b895-11e9-8ffd-25d98cabb58e','6ac217c0-b895-11e9-8ae0-3bfb6de2ef64','6ac33110-b895-11e9-b1f6-8dc1a9b54c0b','6ac46580-b895-11e9-b10d-6188c17c1790','6ac56500-b895-11e9-b65a-33ffdf6f8c9c','6ac669c0-b895-11e9-acda-f72d218b23ec','6ac774f0-b895-11e9-9067-7ddf747c49e5','6ac87520-b895-11e9-b6a7-5924c98f81b1','6ac971a0-b895-11e9-a16e-63756a4e6a56','6acb3760-b895-11e9-a441-9f325b7c7990','6acf1260-b895-11e9-b54e-c72761e6a351','6ad14e20-b895-11e9-bff6-8f707cc9958f','6ad28cd0-b895-11e9-94dc-df34f60790a4','6ad396a0-b895-11e9-91f2-ef407d25de4e','6ad5c800-b895-11e9-97ff-ab5455c1d44b','6ad6d440-b895-11e9-9c4d-4df47c5d17b4','6ad7da50-b895-11e9-a73f-618bfda751bd','6ad8e210-b895-11e9-aeb0-0f9ba396dbe1','6ada7a80-b895-11e9-b5e4-b15638a17c1a','6ae3d6c0-b895-11e9-a388-2b7551191e90','6ae4d600-b895-11e9-b23d-997502693746','6ae5e060-b895-11e9-8d78-a3d7b82dbe55','6ae6e6d0-b895-11e9-b8db-93d32778adac','6ae917b0-b895-11e9-8d62-85c76dddffe6','6aea24a0-b895-11e9-b95e-bf4fd58f6017','6aed1880-b895-11e9-8655-a1aa25a495c8','6aee41e0-b895-11e9-8633-034eba94bbb4','6aefbb50-b895-11e9-85d8-0f6a9bb1e000','6af1b680-b895-11e9-8c1e-4d919d3179a9','6af2d390-b895-11e9-ac8e-35fc140c6334','6af3e1c0-b895-11e9-a918-0f30c04e2271','6af4e940-b895-11e9-8bef-a192bc795d2b','6af5fcc0-b895-11e9-a54d-07d732019875','6af73110-b895-11e9-a5fe-d7350f395bb6','6af857e0-b895-11e9-a8d3-6bd25f75ac8e','6afa0450-b895-11e9-a7c8-b1189e36e143','6afba1f0-b895-11e9-a802-1daecc52d564','6afe4dc0-b895-11e9-941b-9912ab9a34ac','6b002f50-b895-11e9-9dbd-61c8cfb9fe8e','6b024740-b895-11e9-b71c-f95e5d9f2971','6b036680-b895-11e9-b232-375669c11b4c','6b04de20-b895-11e9-86aa-872abf6b181a','6b062dc0-b895-11e9-86b4-6dfc0f2e5b62','6b086180-b895-11e9-966d-c14c9a225cb0','6b09aa40-b895-11e9-9744-470cdd97dbee','6b0aefe0-b895-11e9-ba6a-43ef405c130a','6b0c4300-b895-11e9-bb0a-abbe3d709185','6b0ef5d0-b895-11e9-95ad-13617a69827d','6b116510-b895-11e9-a1d2-9f30079922a9','6b138280-b895-11e9-bc3f-e31c64d8a5a7','6b1575e0-b895-11e9-b9ed-c3537793f2cb','6b1767c0-b895-11e9-9ea9-995dd65a9dc8','6b195a40-b895-11e9-9b56-ed237455dd6a','6b1a9380-b895-11e9-836d-95f175d3b226','6b1c03b0-b895-11e9-b244-557fe6b84016','6b1d1140-b895-11e9-8002-77afed603005','6b1ea830-b895-11e9-b61a-5f817ba944a7','6b1fd280-b895-11e9-b45c-e78c6fd08aab','6b21b010-b895-11e9-a65b-2f503b6f8b96','6b22c5e0-b895-11e9-99c7-4d4383aa5cbb','6b250bd0-b895-11e9-9e72-dbaf57751020','6b26e960-b895-11e9-a8cc-bd7c44852574','6b2bb4b0-b895-11e9-9835-4dc32c042d1c','6b2cda90-b895-11e9-a659-d967b1b74a55','6b2e7330-b895-11e9-a64b-c72b62f6e38c','6b305260-b895-11e9-bc7b-2742e85a9ff3','6b3169e0-b895-11e9-82cf-a1d1545224de','6b326a10-b895-11e9-8d08-2954fddf4cdb','6b3382e0-b895-11e9-ab22-7f6e2f208751','6b348930-b895-11e9-9f9c-d9775857f5b6','6b35b370-b895-11e9-9df8-efdf3ab814da','6b36c6b0-b895-11e9-a0d7-d14e20b1bbea','6b37dc40-b895-11e9-9e0f-cb896b4abdd8','6b3a24e0-b895-11e9-b167-6d55ab43fd36','6b3b4830-b895-11e9-aa0e-8d71278b2aeb','6b3c5bb0-b895-11e9-8911-43bf94406bae','6b3d73c0-b895-11e9-a8b1-2f30340d4c19','6b3e9850-b895-11e9-b437-9d2315b0dbd5','6b40dd70-b895-11e9-bb0c-df0d9ea06b50','6b41e720-b895-11e9-b312-25314b0a3326','6b42fc00-b895-11e9-aaf4-813e7fa2235d','6b441120-b895-11e9-85ff-5b0719b57845','6b453360-b895-11e9-b944-cbf3f7bee932','6b46ac00-b895-11e9-bd47-7b8ad5ec9592','6b48c760-b895-11e9-be5c-eb244856fc1f','6b49cea0-b895-11e9-a6bb-315ee105c804','6b4ada80-b895-11e9-88b0-e71346dcad4e','6b4be710-b895-11e9-8f17-7ba3845fc7db','6b4cff40-b895-11e9-b0a0-a5fb3df7cb32','6b4f1bd0-b895-11e9-90f3-31994c7e8f8d','6b5036a0-b895-11e9-b7be-03df50947c93','6b5a8010-b895-11e9-86a3-d3ab4b52f85d','6b5bd650-b895-11e9-8d9b-994197744792','6b5d1250-b895-11e9-8d32-49426e1000d8','6b5f8010-b895-11e9-abd6-11a43c5fb898','6b612b80-b895-11e9-8ef3-8d7f943e815c','6b64e360-b895-11e9-9516-3be40e4a30ef','6b661da0-b895-11e9-a2e2-63bc44f457e6','6b678300-b895-11e9-9b10-ebc25dff658f','6b68e880-b895-11e9-84b6-cb13fd155076','6b6a4f70-b895-11e9-9031-9bda1ec3423c','6b6b9d40-b895-11e9-a55b-3518a04f5f51','6b6ca440-b895-11e9-b648-6b1c3761ad7b','6b6d9e60-b895-11e9-90f4-2f3d12c87c40','6b6eb590-b895-11e9-806e-63e3f9e6f403','6b6fb780-b895-11e9-b917-136fe89367ca','6b70c430-b895-11e9-a6fe-4f519576a761','6b727c40-b895-11e9-80b0-675716afc8d9','6b737a30-b895-11e9-9a58-1d8f7142d602','6b748830-b895-11e9-a1ef-b7da95d62cc5','6b795d70-b895-11e9-80c5-1b99dc7d82f1','6b7ab980-b895-11e9-b5b8-bb8b29e0fbc4','6b7ce4b0-b895-11e9-9460-371f319f082e','6b7dec60-b895-11e9-93ee-935a226306d9','6b829a70-b895-11e9-b8b6-0974aff1ec86','6b83bf00-b895-11e9-ba99-c1744d82b1ac','6b84ec90-b895-11e9-938b-fdb18dfdb75d','6b861d70-b895-11e9-9945-b78c5c0fb086','6b874bb0-b895-11e9-a6ac-8f2cb294d194','6b889fb0-b895-11e9-bcc4-cdb495bd5ce9','6ba2a4d0-b895-11e9-8db6-6bd605a06d3e','6ba485b0-b895-11e9-bf00-c9d5fcae8438','6ba58f80-b895-11e9-8830-3dfc7f1c5661','6ba69e70-b895-11e9-ba0b-17d9717337e1','6ba7a580-b895-11e9-b4d4-15c4b49ac017','6ba8a430-b895-11e9-bb79-83b1da3a1582','6ba9a720-b895-11e9-ab44-f7b67e7989d3','6baab7f0-b895-11e9-8a31-2591707380db','6babcf40-b895-11e9-b48c-bd819f2e0c8a','6bad77a0-b895-11e9-8089-037905b40299','6baeab70-b895-11e9-a4a2-d3f1645f9c78','6bb1c470-b895-11e9-a24b-41cddaa715f0','6bb3a500-b895-11e9-a91e-59cd17200849','6bb56950-b895-11e9-9e0b-23e2c31640e9','6bb67ad0-b895-11e9-b9cf-f98babcf953f','6bb7b0c0-b895-11e9-b44b-317c836563d6','6bb8e8e0-b895-11e9-8f7a-079d1c428d56','6bb9f800-b895-11e9-a902-751c860e13c7','6bbb06f0-b895-11e9-9a5a-092568af1ec7','6bbc0c50-b895-11e9-84e6-d9c3d40b12f0','6bbd1140-b895-11e9-a4fa-0deef090aeb3','6bbe1fe0-b895-11e9-84f5-7b1868ab33c1','6bbf3310-b895-11e9-89a3-dde787fc733b','6bc09da0-b895-11e9-99db-a519a498717c','6bc20f90-b895-11e9-9cef-0dcff1ee714b','6bc38f90-b895-11e9-b98b-a30faa8d2d07','6bc4cf00-b895-11e9-83fa-a73826944747','6bc5ecc0-b895-11e9-b997-034e738185f2','6bc70060-b895-11e9-9e9e-1366a84d8ae0','6bc82f30-b895-11e9-b5d1-e1603115d669','6bc9e2c0-b895-11e9-a4cc-4f63c16f4fb7','6bcb2330-b895-11e9-b424-f1e8ea85aa98','6bcca3d0-b895-11e9-b3aa-87d517fdfc38','6bcdb230-b895-11e9-b777-1fe3b7899b3e','6bcf6a00-b895-11e9-9e96-833b9b882108','6bd09f80-b895-11e9-aaa8-bfca969e087e','6bd24ce0-b895-11e9-a9a9-e101829a821b','6bd37520-b895-11e9-ab12-ff9368f6a7ea','6bd48ae0-b895-11e9-ba2d-a9d022a2e1e5','6bd5b4f0-b895-11e9-8b6a-5337dcc16665','6bd72ba0-b895-11e9-a60f-95a718e555f6','6bd8d470-b895-11e9-80e9-8b420926ffb0','6bda57b0-b895-11e9-a200-33aff8782cd8','6bdb97c0-b895-11e9-86cc-cb92e8c2245e','6bdd5130-b895-11e9-960b-11925753348a','6bdf5770-b895-11e9-858d-d344860eaaf6','6be0d290-b895-11e9-aabd-e7be12f31e4d','6be22f60-b895-11e9-9b6a-0b4a4e8e3dc0','6be360e0-b895-11e9-bbb0-eb7b082bd1a3','6be47ff0-b895-11e9-9ff0-9beeb70d0f2f','6be683b0-b895-11e9-b9d3-8f36f7fbcb0c','6be80a00-b895-11e9-a45f-6d22f6a35a60','6be95060-b895-11e9-9b51-6349dd460477','6beaa090-b895-11e9-b5c4-17aa93bf021e','6bec0930-b895-11e9-8394-a7b4597a25d4','6bed7980-b895-11e9-96ad-bbb8ec7e7504','6beee0c0-b895-11e9-815c-959d1bc8a5a8','6bf03090-b895-11e9-b356-7f8ca2b11cfd','6bf13da0-b895-11e9-a90a-0ba7077064d9','6bf25880-b895-11e9-a120-c10d5ee4533d','6bf37f20-b895-11e9-8c99-69476992ae28','6bf48ae0-b895-11e9-a84c-af4fab639c5f','6bf58f60-b895-11e9-be66-a549a8942c2d','6bf68f50-b895-11e9-b4ce-7fec25399436','6bf7a070-b895-11e9-9645-736396a61432','6bf8a730-b895-11e9-824f-4bafe47e2a59','6bf9b560-b895-11e9-ad04-1919529e215c','6bfb5350-b895-11e9-aab5-2982bf08ea32','6bfc7e00-b895-11e9-8d05-fd548867da13','6bfe1a90-b895-11e9-91f5-ff12d63d5247','6bff34c0-b895-11e9-b7fc-c75d50161541','6c003c00-b895-11e9-aecc-c1a801fc1517','6c014200-b895-11e9-a17a-afcb85577fc7','6c024280-b895-11e9-a118-edd10d9e43a7','6c0355d0-b895-11e9-b713-6fd2635bb8cd','6c0457c0-b895-11e9-89ae-a96b2d1051b8','6c055c00-b895-11e9-a413-f3e7b2173d58','6c065cf0-b895-11e9-b1f9-b72def5c76ff','6c075dd0-b895-11e9-b5f3-2398201179d8','6c08ebd0-b895-11e9-a3a8-552de9e81c5a','6c0a1100-b895-11e9-a310-4d7eb0ee2d46','6c0bbd10-b895-11e9-92ba-95aa33b7712a','6c0cdaf0-b895-11e9-aa89-757de6f99e22','6c0e2780-b895-11e9-b6a9-e11aca5b59fe','6c144d80-b895-11e9-ade5-3ba192a36ba5','6c155960-b895-11e9-8686-c9c27a8067f8','6c166400-b895-11e9-b889-b59e2edf9ab9','6c178f60-b895-11e9-aee0-43a548c1e5ff','6c191670-b895-11e9-8b3e-695e4648f9c8','6c1a3fa0-b895-11e9-9ff1-9b5448bf929f','6c1bb6a0-b895-11e9-ac4a-977dfa0c7e07','6c1cb670-b895-11e9-801a-37e0ab0882bd','6c1db600-b895-11e9-bf4a-097788aad745','6c1eb6c0-b895-11e9-b8be-892ac97afbb5','6c1fbf40-b895-11e9-a42a-1b2a1d061ad2','6c20cc60-b895-11e9-8676-9fd6d63d1957','6c21dca0-b895-11e9-bbb8-97967f9392ef','6c22e560-b895-11e9-801f-856bfec9f71a','6c23ed70-b895-11e9-96b3-7da9759267f0','6c250730-b895-11e9-ba06-c1d33d649a80','6c265450-b895-11e9-a514-2b83b284fff3','6c27aab0-b895-11e9-82ba-91d9ba743a87','6c28c970-b895-11e9-82ad-2de7ad886f99','6c29e2c0-b895-11e9-9b40-5ba003dc2197','6c2b0240-b895-11e9-85bb-e7591692d72f','6c2c0a10-b895-11e9-b8b6-c99bde9a4ae6','6c2d0ce0-b895-11e9-bf7a-07ce8e2979c1','6c2e10d0-b895-11e9-b7a1-87178d883842','6c2f2720-b895-11e9-885d-d7d277fe2dcf','6c302850-b895-11e9-b817-3919113edba6','6c312d90-b895-11e9-a37c-4d4713e72b4d','6c323620-b895-11e9-8d69-e50d48649d39','6c333c40-b895-11e9-a739-f158a8a046cc','6c345460-b895-11e9-811d-8b4d2db3f5ec','6c357420-b895-11e9-a95a-4186b7409070','6c369420-b895-11e9-af40-f73d5c24584f','6c37b8b0-b895-11e9-bfae-d5227f6d254f','6c392560-b895-11e9-8687-09d63a065d56','6c3a3990-b895-11e9-ab6e-cb854e6de7f3','6c3b7ad0-b895-11e9-aeed-275238eb9c73','6c3c77c0-b895-11e9-aa0d-696b7d94e953','6c3e15a0-b895-11e9-b9a7-adc27f8d9ce0','6c3f68e0-b895-11e9-9f9d-658fb4ba0cdc','6c3ff8e0-8e7d-11e9-8272-0905de8dd384','6c4070f0-b895-11e9-982b-a73160fd599b','6c4175e0-b895-11e9-9f77-cdc477f6f6d2','6c427b20-b895-11e9-9377-99b27070f795','6c4bd310-b895-11e9-b3c3-cb267f8d9a12','6c4cfd90-b895-11e9-ac84-21b419b61137','6c4e6b00-b895-11e9-a14d-f92993bf90c4','6c4f9390-b895-11e9-bd98-a506d989cc57','6c50aca0-b895-11e9-a496-2dde47833539','6c51ad60-b895-11e9-825b-61f330453f9a','6c52bc40-b895-11e9-8134-5f1a5f5932d2','6c54a7d0-b895-11e9-b838-0d4c4a8597a5','6c561e80-b895-11e9-99e3-03dcf7ec01b0','6c577dc0-b895-11e9-8586-19ac62d9e1d9','6c58b760-b895-11e9-a97d-19ce53071776','6c5aaf20-b895-11e9-865b-fd36098a00fd','6c5c19f0-b895-11e9-ace9-3f73e4ad3659','6c5dd400-b895-11e9-af11-d55a8edc67f4','6c5efd10-b895-11e9-b301-b92954b12918','6c600950-b895-11e9-9c49-4d532a761115','6c611bc0-b895-11e9-8b4a-b94a84b8c9dc','6c622df0-b895-11e9-bdd5-b1f855028865','6c63c490-b895-11e9-9c54-e5caa979f3dd','6c64e9a0-b895-11e9-a942-a3ad6f0b6a0f','6c6698c0-b895-11e9-9e95-79b3a923e9b0','6c6e89b0-b895-11e9-ba77-15bb12f339e9','6c6fa350-b895-11e9-a40c-c7d730a3eb47','6c714ae0-b895-11e9-93ba-83a5c5b33fca','6c7258c0-b895-11e9-be15-adac61538a4f','6c735ae0-b895-11e9-b435-c9ead29cd41b','6c745c80-b895-11e9-92e7-29cb5cc35432','6c756230-b895-11e9-90b3-af25b38aed44','6c768500-b895-11e9-b915-77abb8ffa07d','6c783490-b895-11e9-89be-6376020bbe0e','6c7958c0-b895-11e9-b4f4-a54f86190967','6c7c0590-b895-11e9-9ae4-937be355a6f8','6c7d3900-b895-11e9-b4b8-692f57e8a772','6c7e5230-b895-11e9-812a-1df26c91e86d','6c7ff8c0-b895-11e9-a1e3-633a08401603','6c80ffc0-b895-11e9-9a45-3b5095d3c70a','6c8599b0-b895-11e9-ace7-6925af2540f6','6c86a440-b895-11e9-b97e-e3d06d55b347','6c87b0b0-b895-11e9-97ba-436204c59b68','6c88efc0-b895-11e9-b656-d3566cbd447e','6c8aa030-b895-11e9-b00d-357ddd5a4fce','6c8bd100-b895-11e9-8d0e-b3c0b4364054','6c8db7d0-b895-11e9-9431-af81ea0eee33','6c8ee1e0-b895-11e9-85b3-151172e45ccc','6c90e150-b895-11e9-ba73-e358e51ad34e','6c928fa0-b895-11e9-93c4-03eb1a213276','6c939e50-b895-11e9-aa49-a72d1b57bb31','6c94b200-b895-11e9-b7f2-4fe654e89aee','6c95c000-b895-11e9-9c86-679dd12dfa6b','6c96cab0-b895-11e9-a951-65408e0eb375','6c97d8f0-b895-11e9-a4a5-cfc39f062bcd','6c98e460-b895-11e9-8df0-2db9fc160a88','6c99f6b0-b895-11e9-9ca1-cf80a64c9c58','6c9c5ca0-b895-11e9-b055-1946a192dcd3','6c9ecd60-b895-11e9-969e-c9a71fd03034','6c9ff7a0-b895-11e9-a67e-0f0ed45f6f86','6ca1a760-b895-11e9-9a12-db89b38649db','6ca2c320-b895-11e9-bd37-93192d7ab27f','6cab21c0-b614-11e9-9327-931257e44627','6cb46120-b895-11e9-903f-efad4e0b4068','6cb572b0-b895-11e9-83b1-058cd39fc461','6cb68380-b895-11e9-a806-4d9de21bdab7','6cb77f20-b895-11e9-be6e-8d503ffcae63','6cb89090-b895-11e9-918d-937888b3991f','6cb98ec0-b895-11e9-88b7-f9732eda3e91','6cbaa410-b895-11e9-9175-ed537cd6e0e1','6cbbf630-b895-11e9-a9b9-0763d84b72a2','6cbd1c40-b895-11e9-a844-a32a3659fc2d','6cc02ff0-b895-11e9-9342-29b3524fcb9c','6cc1b940-b895-11e9-b0e1-41eeaf26bceb','6cc321a0-b895-11e9-8fcf-1b6a39b02be6','6cc46de0-b895-11e9-8560-ef648a1c70a0','6cc579e0-b895-11e9-84ea-8577eabdd9f1','6cc68170-b895-11e9-9272-23d50cd4d461','6cc79300-b895-11e9-b9a9-7b496ba5bbf6','6cc89980-b895-11e9-8354-394fdaf47302','6cc9abe0-b895-11e9-8a37-6f0c4f8ecf69','6ccab200-b895-11e9-a35f-0975db222f98','6ccbd490-b895-11e9-a960-53cdd50c3a69','6ccf2c20-b895-11e9-bc3f-27d1427a9cae','6cd14880-b895-11e9-9232-dbff416a5572','6cd2db20-b895-11e9-8155-89231e9c170d','6cd3ebc0-b895-11e9-8de3-236cd548345d','6cd50b00-b895-11e9-bafd-030a2f68473c','6cd61180-b895-11e9-9ebc-d977cdd77253','6cd71f80-b895-11e9-aed1-ddf35faf8bdb','6cd82ba0-b895-11e9-85f4-1f7956a7c235','6cd929c0-b895-11e9-acbb-a3fc0d50842e','6cda4590-b895-11e9-8523-25cff80eb1db','6cdb49a0-b895-11e9-8d8c-c5d2cf969d08','6cde1820-b895-11e9-89cb-45174b4f2d69','6cdff3f0-b895-11e9-9fb3-cb97fe4ca287','6ce1b680-b895-11e9-9180-23ea8d0b5c0c','6ce2eb20-b895-11e9-95b9-33a275d93bfe','6ce415c0-b895-11e9-a14b-a77ef7f06e56','6ce53350-b895-11e9-a394-ed490ca22d3c','6ce639c0-b895-11e9-ad11-6b4b1df2fd1a','6ce73c00-b895-11e9-ac8e-294838e5c616','6ce856b0-b895-11e9-bc52-219e8d119750','6ce96c00-b895-11e9-9c94-e309bf53ba8b','6cea6c40-b895-11e9-9a10-75619dea6c54','6ceb77c0-b895-11e9-9cd8-dd6f4c48aed4','6ced9a00-b895-11e9-98dd-339faca8a885','6cefce70-b895-11e9-a7d9-9f3264bee10c','6cf0fbd0-b895-11e9-aa50-ab6cf996fc4c','6cf2e100-b895-11e9-bd8a-6f74ad50bf6e','6cf407d0-b895-11e9-bece-fd9918f11a9a','6cf61610-b895-11e9-b838-ff08db63ccf1','6cf81d40-b895-11e9-82ba-355217639f2c','6cf93f20-b895-11e9-bfc0-45f437f8a6e8','6cfa9590-b895-11e9-9f7c-b7498e18e749','6cfbab80-b895-11e9-bf46-0527663b524c','6cfcb8f0-b895-11e9-ba1c-c3e8f8ca6a41','6cfdcc20-b895-11e9-b5b6-d530f2647ff7','6cfed2d0-b895-11e9-9fe2-4d2ddcc00155','6cffe0f0-b895-11e9-8aee-83725430cc0a','6d00f0e0-b895-11e9-8d2b-0da1dbb3be2f','6d040420-b895-11e9-a247-5be3bae0d904','6d05c850-b895-11e9-a368-fd96195732bf','6d07cb10-b895-11e9-b726-d9b17b7ca516','6d0911c0-b895-11e9-840d-57bbb5c0093a','6d0a41c0-b895-11e9-bdb7-7dfba66b562f','6d0dd640-b895-11e9-95b1-934c43d1ee10','6d0ee050-b895-11e9-b2ec-53c74b3ceadb','6d0fecc0-b895-11e9-b5a7-e9799d2fbe8a','6d112a90-b895-11e9-a2fa-a5f246fea555','6d159700-b895-11e9-81e4-bb292eee43e6','6d198140-b895-11e9-8bbc-dbf6bed535a5','6d1cfc50-b895-11e9-9d5f-9bfbc0b9f8cf','6d1e0ec0-b895-11e9-a8ef-9f0c8170fd36','6d1f26e0-b895-11e9-b76d-49b8a70f096f','6d2031a0-b895-11e9-8dc1-773e10e07873','6d214440-b895-11e9-8b82-396bf4b38623','6d224c60-b895-11e9-825c-2f46232d0315','6d24aa40-b895-11e9-9e09-e31537d3798f','6d28bef0-b895-11e9-8f87-771b238f8ca7','6d2acf70-b895-11e9-b433-2b6ab0f557eb','6d2b4130-8b47-11e9-930c-a160c1aaa6cb','6d2bf870-b895-11e9-b964-45190a9e815c','6d2d1ad0-b895-11e9-8855-0d200c767b2a','6d2f54e0-b895-11e9-b55e-f185b4c4d179','6d3060c0-b895-11e9-8622-ddf70ddb9ffe','6d316be0-b895-11e9-bb8e-ed19e32e1975','6d33c2c0-b895-11e9-bb49-53fcff65aff0','6d34ea50-b895-11e9-8bbc-f3710a2c47a8','6d369480-b895-11e9-8c36-933ae501f0d2','6d3859c0-b895-11e9-b775-1da0b8ff361f','6d39a000-b895-11e9-9e2d-e9882e6e4941','6d3b75d0-b895-11e9-92b9-e5055d8c514b','6d3d1600-b895-11e9-a4c4-976ba4e82fe9','6d3e31e0-b895-11e9-a6d0-453ed478a9e7','6d3f5490-b895-11e9-83ee-d1765d4bd7f9','6d406330-b895-11e9-aaf0-79dd8115edeb','6d415c20-b895-11e9-9ddc-45756d07a41f','6d4255f0-b895-11e9-94f2-ebadf6a25a2d','6d435a10-b895-11e9-8142-53cf66f56b56','6d445d20-b895-11e9-8e86-81a909f77910','6d45afc0-b895-11e9-8192-851824c8dae1','6d472030-b895-11e9-aa3c-85de32bf340d','6d49c0d0-b895-11e9-b3da-3f05b7e5ae31','6d4b1180-b895-11e9-867d-1178c14ea855','6d4db430-b895-11e9-9f66-bdf6cebf3e2d','6d503b00-b895-11e9-9ec9-eb1c714da00f','6d553ec0-b895-11e9-bc92-cd1dfde22197','6d568220-b895-11e9-a784-ed4acbc97ef7','6d583c60-b895-11e9-8db9-2365cc8bdec5','6d5a8e40-b895-11e9-9a6c-3753fcbded23','6d5eb2d0-b895-11e9-bd17-8db9fd282cde','6d5fb820-b895-11e9-8508-3ba313322e44','6f9cd7f0-b614-11e9-85b7-6d4b321beede','6fb98cf0-8cdd-11e9-87d0-a362a5647b0d','72907aa0-ae9c-11e9-8363-97c56442b50d','72e1fd30-8b4d-11e9-87e3-c3cd8624947a','75bcc190-ae9a-11e9-ba6e-83fa4561210c','77aca620-b699-11e9-ae23-f931a4be1c2a','789726a0-924f-11e9-bef2-8bc82fb93462','7942cdc0-8e3d-11e9-9d57-95db0c990e14','7aadc590-8c07-11e9-a2c0-9585d8181a93','7b11ad60-994b-11e9-8442-0b9460e16b99','7e43d120-8b47-11e9-b024-3bd0de9fbf9f','7f443e50-8b47-11e9-8d2d-abdeb66452df','7f7d72d0-8c07-11e9-ada6-9fefde18625d','82adb000-8b47-11e9-9806-03921d9c58c3','82ba5740-ae9d-11e9-9347-193ca328beee','83172530-8e3d-11e9-ab90-51e0e1133433','835b8100-8b47-11e9-9c98-c1c79067b0f4','837aa780-8db2-11e9-8c4c-ddbbf4615de5','85058850-ae9a-11e9-a470-75dd6841949f','8597b000-8b47-11e9-9890-d11422c79133','8616aad0-8b47-11e9-8b9b-6124449a8570','8a0ecfc0-ae99-11e9-bf20-7b81f5e46990','8b5a6b60-8cdd-11e9-847d-211eab5fbfc0','8cdaafc0-af97-11e9-88e3-edfeea4e78b1','904f0420-97f0-11e9-bb0e-a1c34a409d04','9b769020-b679-11e9-9abc-913f16f3508e','9d3bed00-8cdd-11e9-933c-e5e29de4dd40','9d6e7f40-b679-11e9-9c53-135d5d4c0d02','9dfed670-b71c-11e9-8407-fbc2f5d837e4','9e5b4440-aeb3-11e9-bb8b-876b7abffc97','a15fe860-8cdc-11e9-994d-031937fcc305','a1b5c170-c318-11e9-84e3-a3daf1335e32','a21aa500-9b96-11e9-b7dd-411a66106a8e','a463f3d0-b679-11e9-a72b-479a6cff4ed8','a9dbc330-8cdd-11e9-8b50-b7882b6c6bd4','b16acaa0-b767-11e9-9025-a5dd485e9c3b','b173d8e0-ae99-11e9-8c17-dfdbb086e001','b5c1e840-b613-11e9-8e9f-27319203c82f','b66b1f00-8cdd-11e9-a71f-7f86af813e17','b69b9220-b67d-11e9-906f-a7dd36ab9c65','b700e1a0-b67d-11e9-8000-059f22932f0d','b86605f0-9318-11e9-8452-cd2ddd2573ef','b879fc10-b613-11e9-b8cb-778f3aa9433f','b8eef620-8c20-11e9-97a5-c94b68c6c56a','b9449270-b6a1-11e9-b9b6-a5c01297f4a0','b97fdd70-b67d-11e9-8c0e-63cc21964684','b999cf80-b675-11e9-930d-a301062f13c0','ba0800c0-b69a-11e9-927d-a35583d4231e','bb6f1c40-b675-11e9-9d3c-7f2b374b3452','bbd7bf20-b675-11e9-bf97-714530b5d8cb','bc0d4350-b675-11e9-83bd-31e06e37b910','bd3a9470-af62-11e9-a87b-e3a752b949ce','bd6f1ab0-b676-11e9-a0de-75e1d74a67c4','bde241f0-b67d-11e9-b21e-a96596b2d7cf','be5c2e80-b675-11e9-a9f6-01aa9cc94782','be8d26b0-b675-11e9-8078-13ec2770e4c5','bf730530-9331-11e9-88d2-197643351545','c0a1a280-b6a8-11e9-8107-f77e01d11db4','c16360d0-b613-11e9-8e6e-3da17b602f1e','c1a5f8a0-98b5-11e9-b1d7-cdbdfaae6aeb','c44fded0-b617-11e9-bcc7-f7653a8fce12','c5380410-8e3c-11e9-8e91-e19b5880c38b','c5b9f3e0-8e93-11e9-a30f-0bc497d2ae85','c7053de0-b613-11e9-87ae-4f9de5c7af01','cbb37200-b67d-11e9-95a3-8703a2e8b75e','cca95cd0-9ba4-11e9-b3e4-f37e68cbb946','cd133cd0-b69d-11e9-b42f-a365ef0d6e38','ce7b24c0-b749-11e9-937e-c34c812c49e0','cfcebfc0-8cdd-11e9-a9a2-c7475354cd08','cfed1680-b679-11e9-90cf-457bbd87b891','d0c19400-ae99-11e9-8635-912e5a47e234','d3867eb0-b679-11e9-924f-df7215374d96','d4450720-b76d-11e9-a35b-5d848de3dbcc','d86f2220-779b-11e9-9c8b-91143bd4fd73','d9feaba0-b02b-11e9-9dcc-3b01e54fa78c','da41f490-90c0-11e9-9880-33b29b207f38','dcb685a0-c2ec-11e9-998b-8f3170ad30e4','df00bf10-b613-11e9-8d24-bb04a6a1bfb4','df6733a0-b613-11e9-88e1-9309f847887f','e2bd4cc0-b69a-11e9-bcdd-8bcdd532b673','e3d1c640-b69b-11e9-9018-c5c08c299b28','e7c94020-c2ec-11e9-9031-0372ab9ea677','e7d22a10-b613-11e9-8ac9-d1944f2f8317','eba7d260-779a-11e9-9e34-615496653255','ed7d6c10-8f2a-11e9-bbef-b96e046be359','ee8d7dd0-b6a0-11e9-801f-1d743dd7aeb2','ef19edd0-b613-11e9-834e-f9327561a574','f1b60080-b613-11e9-8e7d-b9819853274a','f1e49910-b675-11e9-b8fb-67eedb295137','f49d32b0-b741-11e9-af15-bd49fb17acc3','f58a4a50-8e3c-11e9-80cb-2b7ef06a5bf2','f60133e0-c25e-11e9-b575-59e90a19c0f0','f7498ad0-b675-11e9-847d-73f3d4649709','fadfe530-b67c-11e9-96c1-3b1728bd9909','fbd9a340-b613-11e9-a690-3be796ddafd7','fcbf4560-b675-11e9-bcbd-cf451e0b416e','ff7cf820-b675-11e9-8bc0-d985a7457178','ffb537d0-ac56-11e9-82ca-c7d04259b8d4')\n
  6. ) as v on `scan_log`.`object_id` = `v`.`id` where `scan_log`.`agent_code` = 'mpm-motor' and `scan_log`.`branch_code` in ('SD1', 'A0000', 'A0010', 'A0011', 'A0012', 'A0020', 'A0021', 'A0022', 'A0030', 'A0040', 'A0041', 'A0050', 'A0060', 'A0061', 'A0070', 'A0090', 'A0091', 'A0092', 'A0100', 'A0101', 'A0102', 'A0160', 'A0161', 'A0200', 'A0201', 'A0230', 'A0231', 'A0450', 'A0460', 'A0462', 'A0490', 'A0500', 'A0510', 'A0520', 'A2060', 'A2710', 'B0000', 'B0010', 'B0020', 'B0030', 'B0070', 'B0140', 'B0150', 'B0151', 'B0160', 'B0170', 'B0180', 'B0181', 'B0190', 'B0200', 'B0210', 'B0220', 'B0230', 'B0240', 'B0250', 'B1250', 'B1320', 'B1340', 'B1350', 'B1360', 'B1480', 'C0000', 'C0010', 'C0011', 'C0020', 'C0021', 'C0022', 'C0030', 'C0040', 'C0041', 'C0050', 'C0051', 'C0060', 'C0061', 'C0070', 'C0071', 'C0080', 'C0081', 'C0090', 'C0100', 'C0160', 'C0180', 'C0220', 'C0230', 'C0240', 'C0250', 'C0260', 'C0510', 'C0520', 'C0521', 'C0530', 'C0540', 'C0550', 'C0551', 'C0570', 'C0610', 'C0620', 'C2280', 'D0000', 'D0010', 'D0020', 'D0030', 'D0040', 'D0050', 'D0070', 'D0080', 'D0100', 'D0110', 'D0140', 'D0141', 'D0142', 'D0160', 'D0230', 'D0240', 'D0250', 'D0251', 'D0252', 'D0260', 'D0261', 'D0262', 'D0263', 'D0270', 'D0280', 'D0290', 'D0310', 'D0350', 'E0010', 'E0020', 'E0030', 'E0040', 'E0050', 'E0060', 'E0130', 'E0140', 'E0150', 'E0160', 'E0170', 'E0720', 'E0730', 'F0010', 'F0020', 'F0021', 'F0030', 'F0031', 'F0032', 'F0033', 'F0040', 'F0041', 'F0050', 'F0060', 'F0070', 'F0200', 'F0470', 'F0480', 'F0490', 'F0500', 'F0650', 'F0680', 'F0720', 'F0730', 'F0750', 'F2230', 'G0000', 'G0010', 'G0011', 'G0012', 'G0020', 'G0030', 'G0040', 'G0050', 'G0060', 'G0070', 'G0090', 'G0130', 'G0150', 'G0160', 'G0161', 'G0162', 'G0170', 'G0180', 'G0190', 'G0200', 'G0210', 'G0230', 'G0240', 'G0260', 'G0280', 'G0290', 'G0291', 'G0300', 'G1350', 'G2590', 'H0000', 'H0010', 'H0020', 'H0030', 'H0040', 'H0050', 'H0060', 'H0070', 'H0080', 'H0110', 'H0120', 'H0130', 'H0150', 'H0151', 'H0160', 'H0180', 'H0190', 'H0191', 'H0200', 'H0210', 'H0220', 'H0320', 'H0370', 'H0420', 'H0470', 'H0490', 'H0570', 'H0580', 'H0610', 'H0650', 'H0670', 'H0680', 'H0681', 'H0850', 'H0900', 'H0920', 'H0990', 'H3640', 'H3930', 'H3940', 'K0010', 'K0011', 'K0020', 'K0030', 'K0040', 'K0050', 'K0060', 'K0070', 'K0080', 'K0090', 'M000', 'N0000', 'N0001', 'N0002', 'N0010', 'N0020', 'N0021', 'N0030', 'N0040', 'N0041', 'N0042', 'N0050', 'N0060', 'N0070', 'N0080', 'N0090', 'N0100', 'N0110', 'N0120', 'N0130', 'N0140', 'N0150', 'N0160', 'N0161', 'N0170', 'N0180', 'N0190', 'N0200', 'N0210', 'N0220', 'N1440', 'N1450', 'N1490', 'N1600', 'N3330', 'Z0010', 'Z0020', 'Z0030', 'Z0040', 'Z0041', 'Z0042', 'Z0050', 'Z0051', 'Z0060', 'Z0070', 'Z0071', 'Z0080', 'Z0090', 'Z0100', 'Z0110', 'Z0111', 'Z0120', 'Z0130', 'Z0140', 'Z0150', 'Z0160', 'Z0161', 'Z0170', 'Z0171', 'Z0180', 'Z0190', 'Z0200', 'Z0210', 'Z0220', 'Z0230', 'Z0240', 'Z0250', 'Z0260', 'Z0270', 'Z0280', 'Z0290', 'Z0300', 'Z0310', 'Z0320', 'Z0330', 'Z0340', 'Z0350', 'Z0360', 'Z0370', 'Z1970', 'Z2100', 'Z2230', 'D101', 'M3Z', 'GD1', 'D104', 'JBG', 'KPG', 'MKT', 'ML1', 'PRB', 'STO') and `scan_log`.`aging_time` > '0' and `scan_log`.`created_at` >= '2019-10-01 00:00:00' and `scan_log`.`created_at` <= '2019-10-19 23:59:59'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!