Hi there,

Yesterday we started having major issues with our ticket system and appears to relate to this query:
SELECT COUNT(DISTINCT CASE WHEN B5.value IS NOT NULL THEN A1.ticket_id END) AS q20, COUNT(DISTINCT CASE WHEN A1.staff_id IN (4) AND NOT A2.state IN ('closed', 'archived', 'deleted') THEN A1.ticket_id END) AS q34, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q137, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q138, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.id IN (9) AND A2.state = 'open' AND A1.team_id = 17 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q139, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.id IN (10) AND A2.state = 'open' AND A1.team_id = 17 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q140, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.id IN (1) AND A2.state = 'open' AND A1.team_id = 17 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q141, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.id IN (8) AND A2.state = 'open' AND A1.team_id = 17 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q142, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.id IN (1) AND A1.team_id = 16 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q144, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.id IN (1) AND A2.state = 'open' AND A1.team_id = 1 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q145, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.id IN (10) AND A2.state = 'open' AND A1.team_id = 1 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q146, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.id IN (14) AND A2.state = 'open' AND A1.team_id = 1 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q147, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.id IN (8) AND A2.state = 'open' AND A1.team_id = 1 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q148, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND B6.subject LIKE '%*%' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q151, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND B8.address LIKE '%office365alerts@microsoft.com%' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q152, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q153, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A2.state = 'open' AND A1.team_id = 2 AND NOT (A1.team_id IN (17, 1, 3, 16) OR A1.staff_id IN (36, 4, 8, 7, 2, 6, 27, 32, 1, 34, 9)) AND NOT A1.topic_id = 66 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q154, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A2.state = 'open' AND A1.team_id = 2 AND A1.staff_id IN (6) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q155, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A2.state = 'open' AND A1.team_id = 2 AND A1.staff_id IN (4) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q156, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A2.state = 'open' AND A1.team_id = 2 AND A1.topic_id = 20 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q157, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A2.state = 'open' AND A1.team_id = 2 AND (A1.team_id IN (17, 1, 3) OR A1.staff_id IN (7, 2, 27, 32, 1, 34)) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q158, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.id IN (13) AND A2.state = 'open' AND A1.team_id = 1 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q161, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.id IN (13) AND A2.state = 'open' AND A1.team_id = 17 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q163, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (17) AND A2.id IN (14) AND A2.state = 'open' AND A1.team_id = 17 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q164, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.id IN (9) AND A2.state = 'open' AND A1.team_id = 1 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q165, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A2.state = 'open' AND A1.team_id = 2 AND A1.topic_id = 23 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q171, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A1.topic_id = 23 AND A2.state = 'open' AND A1.team_id = 2 AND A1.topic_id = 23 AND A1.topic_id = 23 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q172, COUNT(DISTINCT CASE WHEN A1.topic_id IN (67, 63, 17, 18) AND A1.topic_id IN (67, 63, 17, 18) AND A2.state = 'open' AND A1.topic_id = 63 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q174, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND NOT A2.id IN (3, 2) AND NOT A2.state = 'closed' AND A1.dept_id = 42 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q176, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A1.team_id = 2 AND A2.state = 'open' AND A1.team_id = 2 AND A1.topic_id = 66 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q180, COUNT(DISTINCT CASE WHEN A1.topic_id IN (67, 63, 17, 18) AND A1.topic_id IN (67, 63, 17, 18) AND A1.topic_id = 67 AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q182, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.id IN (1) AND A2.state = 'open' AND A2.id IN (1) AND A2.id IN (1) AND A1.topic_id = 69 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q189, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.id IN (1) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q190, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.id IN (1) AND A2.state = 'open' AND A2.id IN (1) AND A2.id IN (1) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q191, COUNT(DISTINCT CASE WHEN NOT A2.id IN (3) AND A1.team_id IN (28) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q193, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 5 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q194, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 5 AND A2.id IN (1) AND A1.dept_id = 5 AND A2.id IN (1) AND A1.dept_id = 5 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q195, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 5 AND A2.id IN (1) AND A1.dept_id = 5 AND A2.id IN (1) AND A1.dept_id = 40 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q196, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 5 AND A2.id IN (1) AND A1.dept_id = 5 AND A2.id IN (1) AND A1.topic_id = 70 AND A1.dept_id = 5 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q197, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.state = 'open' AND NOT A2.id IN (3, 2) AND A1.team_id IN (1) AND A2.id IN (6) AND A2.state = 'open' AND A1.topic_id = 15 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q204, COUNT(DISTINCT CASE WHEN A1.topic_id IN (67, 63, 17, 18) AND A1.topic_id = 17 AND A2.state = 'open' AND A1.topic_id IN (67, 63, 17, 18) AND A1.topic_id = 17 AND A2.state = 'open' AND A2.id IN (1) AND B6.subject LIKE '%Please organise offboarding for%' AND A1.dept_id = 34 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q212, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q213, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q216, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND NOT A1.team_id IN (34, 33, 38, 36, 37, 35) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q218, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND NOT A2.id IN (6) AND A1.dept_id = 32 AND A1.team_id = 0 AND A1.staff_id = 0 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q219, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND A2.id IN (1) AND A1.team_id IN (15) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q220, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND A2.id IN (1) AND A1.team_id IN (10) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q221, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND A1.team_id IN (30) AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q222, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND A2.id IN (1) AND A1.team_id IN (31) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q223, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND A2.id IN (16) AND A1.team_id IN (30) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q224, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND A2.id IN (16) AND A1.team_id IN (15) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q225, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND A2.id IN (16) AND A1.team_id IN (31) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q226, COUNT(DISTINCT CASE WHEN A1.dept_id = 32 AND A1.dept_id = 32 AND A2.id IN (16) AND A1.team_id IN (10) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q227, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A1.team_id = 33 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q228, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A1.team_id = 34 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q229, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A1.team_id = 35 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q230, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A1.team_id = 36 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q231, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A1.team_id = 37 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q232, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q235, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q236, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 42 AND A2.id IN (1) AND A1.dept_id = 42 AND A1.dept_id = 42 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q237, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND C0.value REGEXP '\"?682(\"|,|$)' AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q238, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND C0.value REGEXP '\"?683(\"|,|$)' AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q239, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND C0.value REGEXP '\"?684(\"|,|$)' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q240, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q241, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q242, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q243, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q244, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q245, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q246, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A1.team_id = 39 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q247, COUNT(DISTINCT CASE WHEN A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.id IN (1) AND A1.dept_id = 47 AND A2.id IN (1) AND A1.team_id = 39 AND A2.state = 'open' AND NOT C0.value REGEXP '\"?682(\"|,|$)' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q248, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q1, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 27 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q89, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND NOT (A1.team_id IN (3, 12, 13) OR A1.staff_id IN (10, 8, 4, 7, 3, 2, 26, 6, 27, 1, 9)) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q23, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.team_id = 0 AND A1.staff_id = 0 AND NOT A1.dept_id IN (42, 32) AND NOT B8.address = 'office365alerts@microsoft.com' AND NOT A2.id IN (6) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q116, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND NOT (A1.team_id IN (1, 3, 12, 13) OR A1.staff_id IN (10, 8, 4, 7, 3, 2, 6, 27)) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q74, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND NOT (A1.team_id IN (17, 3, 12, 16, 13) OR A1.staff_id IN (10, 8, 4, 7, 3, 2, 26, 6, 27, 1)) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q75, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.id IN (8) AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q78, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.id IN (9) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q86, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 23 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q80, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.staff_id IN (7) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q51, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 19 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q21, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isoverdue = '1' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q4, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 12 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q24, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 12 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q22, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.topic_id = 20 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q25, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '1' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q3, COUNT(DISTINCT CASE WHEN A2.state = 'open' AND A2.state = 'open' AND A1.isanswered = '0' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q2, COUNT(DISTINCT CASE WHEN A1.topic_id IN (67, 63, 17, 18) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q84, COUNT(DISTINCT CASE WHEN A1.topic_id IN (67, 63, 17, 18) AND A1.topic_id IN (67, 63, 17, 18) AND A1.topic_id = 17 AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q70, COUNT(DISTINCT CASE WHEN A1.topic_id IN (67, 63, 17, 18) AND A1.topic_id IN (67, 63, 17, 18) AND A2.state = 'open' AND A1.topic_id = 18 AND A3.object_type = 'T' THEN A1.ticket_id END) AS q79, COUNT(DISTINCT CASE WHEN (A1.team_id IN (3, 12, 16, 17, 18, 28, 29, 30, 31, 32, 39) OR A1.staff_id IN (1)) AND A2.state = 'open' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q5, COUNT(DISTINCT CASE WHEN (A1.team_id IN (3, 12, 16, 17, 18, 28, 29, 30, 31, 32, 39) OR A1.staff_id IN (1)) AND A2.state = 'open' AND (A1.team_id IN (3, 12, 16, 17, 18, 28, 29, 30, 31, 32, 39) OR A1.staff_id IN (1)) AND A2.state = 'open' AND A1.staff_id IN (1) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q6, COUNT(DISTINCT CASE WHEN (A1.team_id IN (3, 12, 16, 17, 18, 28, 29, 30, 31, 32, 39) OR A1.staff_id IN (1)) AND A2.state = 'open' AND (A1.team_id IN (3, 12, 16, 17, 18, 28, 29, 30, 31, 32, 39) OR A1.staff_id IN (1)) AND A2.state = 'open' AND NOT A1.staff_id IN (1) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q7, COUNT(DISTINCT CASE WHEN A2.id IN (6) AND A3.object_type = 'T' THEN A1.ticket_id END) AS q50, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q8, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-11-11 00:00:00' AND '2021-11-11 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q9, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-11-10 00:00:00' AND '2021-11-10 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q10, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-11-08 00:00:00' AND '2021-11-14 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q11, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-11-01 00:00:00' AND '2021-11-30 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q12, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-10-01 00:00:00' AND '2021-12-31 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q13, COUNT(DISTINCT CASE WHEN A2.state = 'closed' AND A2.state = 'closed' AND A1.closed BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 23:59:59' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q14, COUNT(DISTINCT CASE WHEN C1.department REGEXP '\"?279(\"|,|$)' AND A3.object_type = 'T' THEN A1.ticket_id END) AS q52 FROM ost_ticket A1 JOIN ost_ticket_status A2 ON (A1.status_id = A2.id) LEFT JOIN ost_thread A3 ON (A3.object_type = 'T' AND A1.ticket_id = A3.object_id) LEFT JOIN ost_thread_referral A4 ON (A3.id = A4.thread_id) LEFT JOIN ost_staff A5 ON (A4.object_type = 'S' AND A4.object_id = A5.staff_id) LEFT JOIN ost_thread A6 ON (A1.ticket_id = A6.object_id AND A6.object_type = 'C') LEFT JOIN ost_thread_referral A7 ON (A6.id = A7.thread_id) LEFT JOIN ost_staff A8 ON (A7.object_type = 'S' AND A7.object_id = A8.staff_id) LEFT JOIN ost_team B0 ON (A4.object_type = 'E' AND A4.object_id = B0.team_id) LEFT JOIN ost_team B1 ON (A7.object_type = 'E' AND A7.object_id = B1.team_id) LEFT JOIN ost_department B2 ON (A4.object_type = 'D' AND A4.object_id = B2.id) LEFT JOIN ost_department B3 ON (A7.object_type = 'D' AND A7.object_id = B3.id) JOIN ost_form_entry B4 ON (B4.object_type = 'T' AND A1.ticket_id = B4.object_id) LEFT JOIN ost_form_entry_values B5 ON (B4.id = B5.entry_id) LEFT JOIN ost_ticket__cdata B6 ON (A1.ticket_id = B6.ticket_id) LEFT JOIN ost_user B7 ON (A1.user_id = B7.id) LEFT JOIN ost_user_email B8 ON (B7.id = B8.user_id) LEFT JOIN ost_form_entry_values C0 ON (B4.id = C0.entry_id) LEFT JOIN ost_user__cdata C1 ON (B7.id = C1.user_id) WHERE ((A2.state = 'open' AND (A1.staff_id = 1 OR A5.staff_id = 1 OR A6.object_type = 'C' AND A8.staff_id = 1 OR A1.team_id IN (3, 12, 16, 17, 18, 28, 29, 30, 31, 32, 39) OR B0.team_id IN (3, 12, 16, 17, 18, 28, 29, 30, 31, 32, 39) OR A6.object_type = 'C' AND B1.team_id IN (3, 12, 16, 17, 18, 28, 29, 30, 31, 32, 39))) OR (A2.state IN ('open', 'closed') AND (A1.dept_id IN (1, 3, 5, 7, 32, 33, 34, 36, 37, 39, 42, 47) OR B2.id IN (1, 3, 5, 7, 32, 33, 34, 36, 37, 39, 42, 47))) OR A6.object_type = 'C' AND B3.id IN (1, 3, 5, 7, 32, 33, 34, 36, 37, 39, 42, 47))

I think it might relate to a queue that we have setup that is causing mayhem on the Database. So in light of this, we have spun up a separate database server on Ubuntu 20.04 where the Frontend is on 18.04 and now the system is unable to fetch any mail from Office365 where it was before we migrated the database out.

Are we supposed to do anything special? Is it the database server that is fetching the mail from the mail server or is it the front end fetching the mail and passing it through to the database?

Any help would be amazing as we have a lot of users who currently cannot complete their work.