Symfony Profiler

SELECT
            SUM(found_time) AS labor_time,
            SUM(found_time * cost_per_hour) AS labor_cost,
            :order_no AS `order`,
            (SELECT id FROM project_orders WHERE order_nr='1016-1860') AS order_id
            
        FROM (
            SELECT
                jt_p.cost_per_hour,
                jt_r.role_val,
                (
                    SELECT SUM(IFNULL(jt_s.t_direct, 0) + IFNULL(jt_b.t_branch_total, 0))
                    FROM JSON_TABLE(
                        jt_r.orders_json,
                        '$.*' COLUMNS (
                            o_no VARCHAR(100) PATH '$.order',
                            t_direct FLOAT PATH '$.time',
                            branches JSON PATH '$.branches'
                        )
                    ) AS jt_s
                    LEFT JOIN LATERAL (
                        SELECT SUM(b_val) AS t_branch_total 
                        FROM JSON_TABLE(jt_s.branches, '$.*' COLUMNS (b_val FLOAT PATH '$.time')) AS jt_b_inner
                    ) AS jt_b ON 1 = 1
                    WHERE jt_s.o_no = :order_no
                ) AS found_time,
                MIN(jt_r.role_val) OVER(PARTITION BY temp_days.col_origin) AS min_role
            FROM (
                SELECT m1_d1 AS day_data, 'm1_d1' AS col_origin FROM worker_timesheet WHERE m1_d1 IS NOT NULL AND JSON_VALID(m1_d1) AND JSON_LENGTH(m1_d1) > 0 UNION ALL SELECT m1_d2 AS day_data, 'm1_d2' AS col_origin FROM worker_timesheet WHERE m1_d2 IS NOT NULL AND JSON_VALID(m1_d2) AND JSON_LENGTH(m1_d2) > 0 UNION ALL SELECT m1_d3 AS day_data, 'm1_d3' AS col_origin FROM worker_timesheet WHERE m1_d3 IS NOT NULL AND JSON_VALID(m1_d3) AND JSON_LENGTH(m1_d3) > 0 UNION ALL SELECT m1_d4 AS day_data, 'm1_d4' AS col_origin FROM worker_timesheet WHERE m1_d4 IS NOT NULL AND JSON_VALID(m1_d4) AND JSON_LENGTH(m1_d4) > 0 UNION ALL SELECT m1_d5 AS day_data, 'm1_d5' AS col_origin FROM worker_timesheet WHERE m1_d5 IS NOT NULL AND JSON_VALID(m1_d5) AND JSON_LENGTH(m1_d5) > 0 UNION ALL SELECT m1_d6 AS day_data, 'm1_d6' AS col_origin FROM worker_timesheet WHERE m1_d6 IS NOT NULL AND JSON_VALID(m1_d6) AND JSON_LENGTH(m1_d6) > 0 UNION ALL SELECT m1_d7 AS day_data, 'm1_d7' AS col_origin FROM worker_timesheet WHERE m1_d7 IS NOT NULL AND JSON_VALID(m1_d7) AND JSON_LENGTH(m1_d7) > 0 UNION ALL SELECT m1_d8 AS day_data, 'm1_d8' AS col_origin FROM worker_timesheet WHERE m1_d8 IS NOT NULL AND JSON_VALID(m1_d8) AND JSON_LENGTH(m1_d8) > 0 UNION ALL SELECT m1_d9 AS day_data, 'm1_d9' AS col_origin FROM worker_timesheet WHERE m1_d9 IS NOT NULL AND JSON_VALID(m1_d9) AND JSON_LENGTH(m1_d9) > 0 UNION ALL SELECT m1_d10 AS day_data, 'm1_d10' AS col_origin FROM worker_timesheet WHERE m1_d10 IS NOT NULL AND JSON_VALID(m1_d10) AND JSON_LENGTH(m1_d10) > 0 UNION ALL SELECT m1_d11 AS day_data, 'm1_d11' AS col_origin FROM worker_timesheet WHERE m1_d11 IS NOT NULL AND JSON_VALID(m1_d11) AND JSON_LENGTH(m1_d11) > 0 UNION ALL SELECT m1_d12 AS day_data, 'm1_d12' AS col_origin FROM worker_timesheet WHERE m1_d12 IS NOT NULL AND JSON_VALID(m1_d12) AND JSON_LENGTH(m1_d12) > 0 UNION ALL SELECT m1_d13 AS day_data, 'm1_d13' AS col_origin FROM worker_timesheet WHERE m1_d13 IS NOT NULL AND JSON_VALID(m1_d13) AND JSON_LENGTH(m1_d13) > 0 UNION ALL SELECT m1_d14 AS day_data, 'm1_d14' AS col_origin FROM worker_timesheet WHERE m1_d14 IS NOT NULL AND JSON_VALID(m1_d14) AND JSON_LENGTH(m1_d14) > 0 UNION ALL SELECT m1_d15 AS day_data, 'm1_d15' AS col_origin FROM worker_timesheet WHERE m1_d15 IS NOT NULL AND JSON_VALID(m1_d15) AND JSON_LENGTH(m1_d15) > 0 UNION ALL SELECT m1_d16 AS day_data, 'm1_d16' AS col_origin FROM worker_timesheet WHERE m1_d16 IS NOT NULL AND JSON_VALID(m1_d16) AND JSON_LENGTH(m1_d16) > 0 UNION ALL SELECT m1_d17 AS day_data, 'm1_d17' AS col_origin FROM worker_timesheet WHERE m1_d17 IS NOT NULL AND JSON_VALID(m1_d17) AND JSON_LENGTH(m1_d17) > 0 UNION ALL SELECT m1_d18 AS day_data, 'm1_d18' AS col_origin FROM worker_timesheet WHERE m1_d18 IS NOT NULL AND JSON_VALID(m1_d18) AND JSON_LENGTH(m1_d18) > 0 UNION ALL SELECT m1_d19 AS day_data, 'm1_d19' AS col_origin FROM worker_timesheet WHERE m1_d19 IS NOT NULL AND JSON_VALID(m1_d19) AND JSON_LENGTH(m1_d19) > 0 UNION ALL SELECT m1_d20 AS day_data, 'm1_d20' AS col_origin FROM worker_timesheet WHERE m1_d20 IS NOT NULL AND JSON_VALID(m1_d20) AND JSON_LENGTH(m1_d20) > 0 UNION ALL SELECT m1_d21 AS day_data, 'm1_d21' AS col_origin FROM worker_timesheet WHERE m1_d21 IS NOT NULL AND JSON_VALID(m1_d21) AND JSON_LENGTH(m1_d21) > 0 UNION ALL SELECT m1_d22 AS day_data, 'm1_d22' AS col_origin FROM worker_timesheet WHERE m1_d22 IS NOT NULL AND JSON_VALID(m1_d22) AND JSON_LENGTH(m1_d22) > 0 UNION ALL SELECT m1_d23 AS day_data, 'm1_d23' AS col_origin FROM worker_timesheet WHERE m1_d23 IS NOT NULL AND JSON_VALID(m1_d23) AND JSON_LENGTH(m1_d23) > 0 UNION ALL SELECT m1_d24 AS day_data, 'm1_d24' AS col_origin FROM worker_timesheet WHERE m1_d24 IS NOT NULL AND JSON_VALID(m1_d24) AND JSON_LENGTH(m1_d24) > 0 UNION ALL SELECT m1_d25 AS day_data, 'm1_d25' AS col_origin FROM worker_timesheet WHERE m1_d25 IS NOT NULL AND JSON_VALID(m1_d25) AND JSON_LENGTH(m1_d25) > 0 UNION ALL SELECT m1_d26 AS day_data, 'm1_d26' AS col_origin FROM worker_timesheet WHERE m1_d26 IS NOT NULL AND JSON_VALID(m1_d26) AND JSON_LENGTH(m1_d26) > 0 UNION ALL SELECT m1_d27 AS day_data, 'm1_d27' AS col_origin FROM worker_timesheet WHERE m1_d27 IS NOT NULL AND JSON_VALID(m1_d27) AND JSON_LENGTH(m1_d27) > 0 UNION ALL SELECT m1_d28 AS day_data, 'm1_d28' AS col_origin FROM worker_timesheet WHERE m1_d28 IS NOT NULL AND JSON_VALID(m1_d28) AND JSON_LENGTH(m1_d28) > 0 UNION ALL SELECT m1_d29 AS day_data, 'm1_d29' AS col_origin FROM worker_timesheet WHERE m1_d29 IS NOT NULL AND JSON_VALID(m1_d29) AND JSON_LENGTH(m1_d29) > 0 UNION ALL SELECT m1_d30 AS day_data, 'm1_d30' AS col_origin FROM worker_timesheet WHERE m1_d30 IS NOT NULL AND JSON_VALID(m1_d30) AND JSON_LENGTH(m1_d30) > 0 UNION ALL SELECT m1_d31 AS day_data, 'm1_d31' AS col_origin FROM worker_timesheet WHERE m1_d31 IS NOT NULL AND JSON_VALID(m1_d31) AND JSON_LENGTH(m1_d31) > 0 UNION ALL SELECT m2_d1 AS day_data, 'm2_d1' AS col_origin FROM worker_timesheet WHERE m2_d1 IS NOT NULL AND JSON_VALID(m2_d1) AND JSON_LENGTH(m2_d1) > 0 UNION ALL SELECT m2_d2 AS day_data, 'm2_d2' AS col_origin FROM worker_timesheet WHERE m2_d2 IS NOT NULL AND JSON_VALID(m2_d2) AND JSON_LENGTH(m2_d2) > 0 UNION ALL SELECT m2_d3 AS day_data, 'm2_d3' AS col_origin FROM worker_timesheet WHERE m2_d3 IS NOT NULL AND JSON_VALID(m2_d3) AND JSON_LENGTH(m2_d3) > 0 UNION ALL SELECT m2_d4 AS day_data, 'm2_d4' AS col_origin FROM worker_timesheet WHERE m2_d4 IS NOT NULL AND JSON_VALID(m2_d4) AND JSON_LENGTH(m2_d4) > 0 UNION ALL SELECT m2_d5 AS day_data, 'm2_d5' AS col_origin FROM worker_timesheet WHERE m2_d5 IS NOT NULL AND JSON_VALID(m2_d5) AND JSON_LENGTH(m2_d5) > 0 UNION ALL SELECT m2_d6 AS day_data, 'm2_d6' AS col_origin FROM worker_timesheet WHERE m2_d6 IS NOT NULL AND JSON_VALID(m2_d6) AND JSON_LENGTH(m2_d6) > 0 UNION ALL SELECT m2_d7 AS day_data, 'm2_d7' AS col_origin FROM worker_timesheet WHERE m2_d7 IS NOT NULL AND JSON_VALID(m2_d7) AND JSON_LENGTH(m2_d7) > 0 UNION ALL SELECT m2_d8 AS day_data, 'm2_d8' AS col_origin FROM worker_timesheet WHERE m2_d8 IS NOT NULL AND JSON_VALID(m2_d8) AND JSON_LENGTH(m2_d8) > 0 UNION ALL SELECT m2_d9 AS day_data, 'm2_d9' AS col_origin FROM worker_timesheet WHERE m2_d9 IS NOT NULL AND JSON_VALID(m2_d9) AND JSON_LENGTH(m2_d9) > 0 UNION ALL SELECT m2_d10 AS day_data, 'm2_d10' AS col_origin FROM worker_timesheet WHERE m2_d10 IS NOT NULL AND JSON_VALID(m2_d10) AND JSON_LENGTH(m2_d10) > 0 UNION ALL SELECT m2_d11 AS day_data, 'm2_d11' AS col_origin FROM worker_timesheet WHERE m2_d11 IS NOT NULL AND JSON_VALID(m2_d11) AND JSON_LENGTH(m2_d11) > 0 UNION ALL SELECT m2_d12 AS day_data, 'm2_d12' AS col_origin FROM worker_timesheet WHERE m2_d12 IS NOT NULL AND JSON_VALID(m2_d12) AND JSON_LENGTH(m2_d12) > 0 UNION ALL SELECT m2_d13 AS day_data, 'm2_d13' AS col_origin FROM worker_timesheet WHERE m2_d13 IS NOT NULL AND JSON_VALID(m2_d13) AND JSON_LENGTH(m2_d13) > 0 UNION ALL SELECT m2_d14 AS day_data, 'm2_d14' AS col_origin FROM worker_timesheet WHERE m2_d14 IS NOT NULL AND JSON_VALID(m2_d14) AND JSON_LENGTH(m2_d14) > 0 UNION ALL SELECT m2_d15 AS day_data, 'm2_d15' AS col_origin FROM worker_timesheet WHERE m2_d15 IS NOT NULL AND JSON_VALID(m2_d15) AND JSON_LENGTH(m2_d15) > 0 UNION ALL SELECT m2_d16 AS day_data, 'm2_d16' AS col_origin FROM worker_timesheet WHERE m2_d16 IS NOT NULL AND JSON_VALID(m2_d16) AND JSON_LENGTH(m2_d16) > 0 UNION ALL SELECT m2_d17 AS day_data, 'm2_d17' AS col_origin FROM worker_timesheet WHERE m2_d17 IS NOT NULL AND JSON_VALID(m2_d17) AND JSON_LENGTH(m2_d17) > 0 UNION ALL SELECT m2_d18 AS day_data, 'm2_d18' AS col_origin FROM worker_timesheet WHERE m2_d18 IS NOT NULL AND JSON_VALID(m2_d18) AND JSON_LENGTH(m2_d18) > 0 UNION ALL SELECT m2_d19 AS day_data, 'm2_d19' AS col_origin FROM worker_timesheet WHERE m2_d19 IS NOT NULL AND JSON_VALID(m2_d19) AND JSON_LENGTH(m2_d19) > 0 UNION ALL SELECT m2_d20 AS day_data, 'm2_d20' AS col_origin FROM worker_timesheet WHERE m2_d20 IS NOT NULL AND JSON_VALID(m2_d20) AND JSON_LENGTH(m2_d20) > 0 UNION ALL SELECT m2_d21 AS day_data, 'm2_d21' AS col_origin FROM worker_timesheet WHERE m2_d21 IS NOT NULL AND JSON_VALID(m2_d21) AND JSON_LENGTH(m2_d21) > 0 UNION ALL SELECT m2_d22 AS day_data, 'm2_d22' AS col_origin FROM worker_timesheet WHERE m2_d22 IS NOT NULL AND JSON_VALID(m2_d22) AND JSON_LENGTH(m2_d22) > 0 UNION ALL SELECT m2_d23 AS day_data, 'm2_d23' AS col_origin FROM worker_timesheet WHERE m2_d23 IS NOT NULL AND JSON_VALID(m2_d23) AND JSON_LENGTH(m2_d23) > 0 UNION ALL SELECT m2_d24 AS day_data, 'm2_d24' AS col_origin FROM worker_timesheet WHERE m2_d24 IS NOT NULL AND JSON_VALID(m2_d24) AND JSON_LENGTH(m2_d24) > 0 UNION ALL SELECT m2_d25 AS day_data, 'm2_d25' AS col_origin FROM worker_timesheet WHERE m2_d25 IS NOT NULL AND JSON_VALID(m2_d25) AND JSON_LENGTH(m2_d25) > 0 UNION ALL SELECT m2_d26 AS day_data, 'm2_d26' AS col_origin FROM worker_timesheet WHERE m2_d26 IS NOT NULL AND JSON_VALID(m2_d26) AND JSON_LENGTH(m2_d26) > 0 UNION ALL SELECT m2_d27 AS day_data, 'm2_d27' AS col_origin FROM worker_timesheet WHERE m2_d27 IS NOT NULL AND JSON_VALID(m2_d27) AND JSON_LENGTH(m2_d27) > 0 UNION ALL SELECT m2_d28 AS day_data, 'm2_d28' AS col_origin FROM worker_timesheet WHERE m2_d28 IS NOT NULL AND JSON_VALID(m2_d28) AND JSON_LENGTH(m2_d28) > 0 UNION ALL SELECT m2_d29 AS day_data, 'm2_d29' AS col_origin FROM worker_timesheet WHERE m2_d29 IS NOT NULL AND JSON_VALID(m2_d29) AND JSON_LENGTH(m2_d29) > 0 UNION ALL SELECT m2_d30 AS day_data, 'm2_d30' AS col_origin FROM worker_timesheet WHERE m2_d30 IS NOT NULL AND JSON_VALID(m2_d30) AND JSON_LENGTH(m2_d30) > 0 UNION ALL SELECT m2_d31 AS day_data, 'm2_d31' AS col_origin FROM worker_timesheet WHERE m2_d31 IS NOT NULL AND JSON_VALID(m2_d31) AND JSON_LENGTH(m2_d31) > 0 UNION ALL SELECT m3_d1 AS day_data, 'm3_d1' AS col_origin FROM worker_timesheet WHERE m3_d1 IS NOT NULL AND JSON_VALID(m3_d1) AND JSON_LENGTH(m3_d1) > 0 UNION ALL SELECT m3_d2 AS day_data, 'm3_d2' AS col_origin FROM worker_timesheet WHERE m3_d2 IS NOT NULL AND JSON_VALID(m3_d2) AND JSON_LENGTH(m3_d2) > 0 UNION ALL SELECT m3_d3 AS day_data, 'm3_d3' AS col_origin FROM worker_timesheet WHERE m3_d3 IS NOT NULL AND JSON_VALID(m3_d3) AND JSON_LENGTH(m3_d3) > 0 UNION ALL SELECT m3_d4 AS day_data, 'm3_d4' AS col_origin FROM worker_timesheet WHERE m3_d4 IS NOT NULL AND JSON_VALID(m3_d4) AND JSON_LENGTH(m3_d4) > 0 UNION ALL SELECT m3_d5 AS day_data, 'm3_d5' AS col_origin FROM worker_timesheet WHERE m3_d5 IS NOT NULL AND JSON_VALID(m3_d5) AND JSON_LENGTH(m3_d5) > 0 UNION ALL SELECT m3_d6 AS day_data, 'm3_d6' AS col_origin FROM worker_timesheet WHERE m3_d6 IS NOT NULL AND JSON_VALID(m3_d6) AND JSON_LENGTH(m3_d6) > 0 UNION ALL SELECT m3_d7 AS day_data, 'm3_d7' AS col_origin FROM worker_timesheet WHERE m3_d7 IS NOT NULL AND JSON_VALID(m3_d7) AND JSON_LENGTH(m3_d7) > 0 UNION ALL SELECT m3_d8 AS day_data, 'm3_d8' AS col_origin FROM worker_timesheet WHERE m3_d8 IS NOT NULL AND JSON_VALID(m3_d8) AND JSON_LENGTH(m3_d8) > 0 UNION ALL SELECT m3_d9 AS day_data, 'm3_d9' AS col_origin FROM worker_timesheet WHERE m3_d9 IS NOT NULL AND JSON_VALID(m3_d9) AND JSON_LENGTH(m3_d9) > 0 UNION ALL SELECT m3_d10 AS day_data, 'm3_d10' AS col_origin FROM worker_timesheet WHERE m3_d10 IS NOT NULL AND JSON_VALID(m3_d10) AND JSON_LENGTH(m3_d10) > 0 UNION ALL SELECT m3_d11 AS day_data, 'm3_d11' AS col_origin FROM worker_timesheet WHERE m3_d11 IS NOT NULL AND JSON_VALID(m3_d11) AND JSON_LENGTH(m3_d11) > 0 UNION ALL SELECT m3_d12 AS day_data, 'm3_d12' AS col_origin FROM worker_timesheet WHERE m3_d12 IS NOT NULL AND JSON_VALID(m3_d12) AND JSON_LENGTH(m3_d12) > 0 UNION ALL SELECT m3_d13 AS day_data, 'm3_d13' AS col_origin FROM worker_timesheet WHERE m3_d13 IS NOT NULL AND JSON_VALID(m3_d13) AND JSON_LENGTH(m3_d13) > 0 UNION ALL SELECT m3_d14 AS day_data, 'm3_d14' AS col_origin FROM worker_timesheet WHERE m3_d14 IS NOT NULL AND JSON_VALID(m3_d14) AND JSON_LENGTH(m3_d14) > 0 UNION ALL SELECT m3_d15 AS day_data, 'm3_d15' AS col_origin FROM worker_timesheet WHERE m3_d15 IS NOT NULL AND JSON_VALID(m3_d15) AND JSON_LENGTH(m3_d15) > 0 UNION ALL SELECT m3_d16 AS day_data, 'm3_d16' AS col_origin FROM worker_timesheet WHERE m3_d16 IS NOT NULL AND JSON_VALID(m3_d16) AND JSON_LENGTH(m3_d16) > 0 UNION ALL SELECT m3_d17 AS day_data, 'm3_d17' AS col_origin FROM worker_timesheet WHERE m3_d17 IS NOT NULL AND JSON_VALID(m3_d17) AND JSON_LENGTH(m3_d17) > 0 UNION ALL SELECT m3_d18 AS day_data, 'm3_d18' AS col_origin FROM worker_timesheet WHERE m3_d18 IS NOT NULL AND JSON_VALID(m3_d18) AND JSON_LENGTH(m3_d18) > 0 UNION ALL SELECT m3_d19 AS day_data, 'm3_d19' AS col_origin FROM worker_timesheet WHERE m3_d19 IS NOT NULL AND JSON_VALID(m3_d19) AND JSON_LENGTH(m3_d19) > 0 UNION ALL SELECT m3_d20 AS day_data, 'm3_d20' AS col_origin FROM worker_timesheet WHERE m3_d20 IS NOT NULL AND JSON_VALID(m3_d20) AND JSON_LENGTH(m3_d20) > 0 UNION ALL SELECT m3_d21 AS day_data, 'm3_d21' AS col_origin FROM worker_timesheet WHERE m3_d21 IS NOT NULL AND JSON_VALID(m3_d21) AND JSON_LENGTH(m3_d21) > 0 UNION ALL SELECT m3_d22 AS day_data, 'm3_d22' AS col_origin FROM worker_timesheet WHERE m3_d22 IS NOT NULL AND JSON_VALID(m3_d22) AND JSON_LENGTH(m3_d22) > 0 UNION ALL SELECT m3_d23 AS day_data, 'm3_d23' AS col_origin FROM worker_timesheet WHERE m3_d23 IS NOT NULL AND JSON_VALID(m3_d23) AND JSON_LENGTH(m3_d23) > 0 UNION ALL SELECT m3_d24 AS day_data, 'm3_d24' AS col_origin FROM worker_timesheet WHERE m3_d24 IS NOT NULL AND JSON_VALID(m3_d24) AND JSON_LENGTH(m3_d24) > 0 UNION ALL SELECT m3_d25 AS day_data, 'm3_d25' AS col_origin FROM worker_timesheet WHERE m3_d25 IS NOT NULL AND JSON_VALID(m3_d25) AND JSON_LENGTH(m3_d25) > 0 UNION ALL SELECT m3_d26 AS day_data, 'm3_d26' AS col_origin FROM worker_timesheet WHERE m3_d26 IS NOT NULL AND JSON_VALID(m3_d26) AND JSON_LENGTH(m3_d26) > 0 UNION ALL SELECT m3_d27 AS day_data, 'm3_d27' AS col_origin FROM worker_timesheet WHERE m3_d27 IS NOT NULL AND JSON_VALID(m3_d27) AND JSON_LENGTH(m3_d27) > 0 UNION ALL SELECT m3_d28 AS day_data, 'm3_d28' AS col_origin FROM worker_timesheet WHERE m3_d28 IS NOT NULL AND JSON_VALID(m3_d28) AND JSON_LENGTH(m3_d28) > 0 UNION ALL SELECT m3_d29 AS day_data, 'm3_d29' AS col_origin FROM worker_timesheet WHERE m3_d29 IS NOT NULL AND JSON_VALID(m3_d29) AND JSON_LENGTH(m3_d29) > 0 UNION ALL SELECT m3_d30 AS day_data, 'm3_d30' AS col_origin FROM worker_timesheet WHERE m3_d30 IS NOT NULL AND JSON_VALID(m3_d30) AND JSON_LENGTH(m3_d30) > 0 UNION ALL SELECT m3_d31 AS day_data, 'm3_d31' AS col_origin FROM worker_timesheet WHERE m3_d31 IS NOT NULL AND JSON_VALID(m3_d31) AND JSON_LENGTH(m3_d31) > 0 UNION ALL SELECT m4_d1 AS day_data, 'm4_d1' AS col_origin FROM worker_timesheet WHERE m4_d1 IS NOT NULL AND JSON_VALID(m4_d1) AND JSON_LENGTH(m4_d1) > 0 UNION ALL SELECT m4_d2 AS day_data, 'm4_d2' AS col_origin FROM worker_timesheet WHERE m4_d2 IS NOT NULL AND JSON_VALID(m4_d2) AND JSON_LENGTH(m4_d2) > 0 UNION ALL SELECT m4_d3 AS day_data, 'm4_d3' AS col_origin FROM worker_timesheet WHERE m4_d3 IS NOT NULL AND JSON_VALID(m4_d3) AND JSON_LENGTH(m4_d3) > 0 UNION ALL SELECT m4_d4 AS day_data, 'm4_d4' AS col_origin FROM worker_timesheet WHERE m4_d4 IS NOT NULL AND JSON_VALID(m4_d4) AND JSON_LENGTH(m4_d4) > 0 UNION ALL SELECT m4_d5 AS day_data, 'm4_d5' AS col_origin FROM worker_timesheet WHERE m4_d5 IS NOT NULL AND JSON_VALID(m4_d5) AND JSON_LENGTH(m4_d5) > 0 UNION ALL SELECT m4_d6 AS day_data, 'm4_d6' AS col_origin FROM worker_timesheet WHERE m4_d6 IS NOT NULL AND JSON_VALID(m4_d6) AND JSON_LENGTH(m4_d6) > 0 UNION ALL SELECT m4_d7 AS day_data, 'm4_d7' AS col_origin FROM worker_timesheet WHERE m4_d7 IS NOT NULL AND JSON_VALID(m4_d7) AND JSON_LENGTH(m4_d7) > 0 UNION ALL SELECT m4_d8 AS day_data, 'm4_d8' AS col_origin FROM worker_timesheet WHERE m4_d8 IS NOT NULL AND JSON_VALID(m4_d8) AND JSON_LENGTH(m4_d8) > 0 UNION ALL SELECT m4_d9 AS day_data, 'm4_d9' AS col_origin FROM worker_timesheet WHERE m4_d9 IS NOT NULL AND JSON_VALID(m4_d9) AND JSON_LENGTH(m4_d9) > 0 UNION ALL SELECT m4_d10 AS day_data, 'm4_d10' AS col_origin FROM worker_timesheet WHERE m4_d10 IS NOT NULL AND JSON_VALID(m4_d10) AND JSON_LENGTH(m4_d10) > 0 UNION ALL SELECT m4_d11 AS day_data, 'm4_d11' AS col_origin FROM worker_timesheet WHERE m4_d11 IS NOT NULL AND JSON_VALID(m4_d11) AND JSON_LENGTH(m4_d11) > 0 UNION ALL SELECT m4_d12 AS day_data, 'm4_d12' AS col_origin FROM worker_timesheet WHERE m4_d12 IS NOT NULL AND JSON_VALID(m4_d12) AND JSON_LENGTH(m4_d12) > 0 UNION ALL SELECT m4_d13 AS day_data, 'm4_d13' AS col_origin FROM worker_timesheet WHERE m4_d13 IS NOT NULL AND JSON_VALID(m4_d13) AND JSON_LENGTH(m4_d13) > 0 UNION ALL SELECT m4_d14 AS day_data, 'm4_d14' AS col_origin FROM worker_timesheet WHERE m4_d14 IS NOT NULL AND JSON_VALID(m4_d14) AND JSON_LENGTH(m4_d14) > 0 UNION ALL SELECT m4_d15 AS day_data, 'm4_d15' AS col_origin FROM worker_timesheet WHERE m4_d15 IS NOT NULL AND JSON_VALID(m4_d15) AND JSON_LENGTH(m4_d15) > 0 UNION ALL SELECT m4_d16 AS day_data, 'm4_d16' AS col_origin FROM worker_timesheet WHERE m4_d16 IS NOT NULL AND JSON_VALID(m4_d16) AND JSON_LENGTH(m4_d16) > 0 UNION ALL SELECT m4_d17 AS day_data, 'm4_d17' AS col_origin FROM worker_timesheet WHERE m4_d17 IS NOT NULL AND JSON_VALID(m4_d17) AND JSON_LENGTH(m4_d17) > 0 UNION ALL SELECT m4_d18 AS day_data, 'm4_d18' AS col_origin FROM worker_timesheet WHERE m4_d18 IS NOT NULL AND JSON_VALID(m4_d18) AND JSON_LENGTH(m4_d18) > 0 UNION ALL SELECT m4_d19 AS day_data, 'm4_d19' AS col_origin FROM worker_timesheet WHERE m4_d19 IS NOT NULL AND JSON_VALID(m4_d19) AND JSON_LENGTH(m4_d19) > 0 UNION ALL SELECT m4_d20 AS day_data, 'm4_d20' AS col_origin FROM worker_timesheet WHERE m4_d20 IS NOT NULL AND JSON_VALID(m4_d20) AND JSON_LENGTH(m4_d20) > 0 UNION ALL SELECT m4_d21 AS day_data, 'm4_d21' AS col_origin FROM worker_timesheet WHERE m4_d21 IS NOT NULL AND JSON_VALID(m4_d21) AND JSON_LENGTH(m4_d21) > 0 UNION ALL SELECT m4_d22 AS day_data, 'm4_d22' AS col_origin FROM worker_timesheet WHERE m4_d22 IS NOT NULL AND JSON_VALID(m4_d22) AND JSON_LENGTH(m4_d22) > 0 UNION ALL SELECT m4_d23 AS day_data, 'm4_d23' AS col_origin FROM worker_timesheet WHERE m4_d23 IS NOT NULL AND JSON_VALID(m4_d23) AND JSON_LENGTH(m4_d23) > 0 UNION ALL SELECT m4_d24 AS day_data, 'm4_d24' AS col_origin FROM worker_timesheet WHERE m4_d24 IS NOT NULL AND JSON_VALID(m4_d24) AND JSON_LENGTH(m4_d24) > 0 UNION ALL SELECT m4_d25 AS day_data, 'm4_d25' AS col_origin FROM worker_timesheet WHERE m4_d25 IS NOT NULL AND JSON_VALID(m4_d25) AND JSON_LENGTH(m4_d25) > 0 UNION ALL SELECT m4_d26 AS day_data, 'm4_d26' AS col_origin FROM worker_timesheet WHERE m4_d26 IS NOT NULL AND JSON_VALID(m4_d26) AND JSON_LENGTH(m4_d26) > 0 UNION ALL SELECT m4_d27 AS day_data, 'm4_d27' AS col_origin FROM worker_timesheet WHERE m4_d27 IS NOT NULL AND JSON_VALID(m4_d27) AND JSON_LENGTH(m4_d27) > 0 UNION ALL SELECT m4_d28 AS day_data, 'm4_d28' AS col_origin FROM worker_timesheet WHERE m4_d28 IS NOT NULL AND JSON_VALID(m4_d28) AND JSON_LENGTH(m4_d28) > 0 UNION ALL SELECT m4_d29 AS day_data, 'm4_d29' AS col_origin FROM worker_timesheet WHERE m4_d29 IS NOT NULL AND JSON_VALID(m4_d29) AND JSON_LENGTH(m4_d29) > 0 UNION ALL SELECT m4_d30 AS day_data, 'm4_d30' AS col_origin FROM worker_timesheet WHERE m4_d30 IS NOT NULL AND JSON_VALID(m4_d30) AND JSON_LENGTH(m4_d30) > 0 UNION ALL SELECT m4_d31 AS day_data, 'm4_d31' AS col_origin FROM worker_timesheet WHERE m4_d31 IS NOT NULL AND JSON_VALID(m4_d31) AND JSON_LENGTH(m4_d31) > 0 UNION ALL SELECT m5_d1 AS day_data, 'm5_d1' AS col_origin FROM worker_timesheet WHERE m5_d1 IS NOT NULL AND JSON_VALID(m5_d1) AND JSON_LENGTH(m5_d1) > 0 UNION ALL SELECT m5_d2 AS day_data, 'm5_d2' AS col_origin FROM worker_timesheet WHERE m5_d2 IS NOT NULL AND JSON_VALID(m5_d2) AND JSON_LENGTH(m5_d2) > 0 UNION ALL SELECT m5_d3 AS day_data, 'm5_d3' AS col_origin FROM worker_timesheet WHERE m5_d3 IS NOT NULL AND JSON_VALID(m5_d3) AND JSON_LENGTH(m5_d3) > 0 UNION ALL SELECT m5_d4 AS day_data, 'm5_d4' AS col_origin FROM worker_timesheet WHERE m5_d4 IS NOT NULL AND JSON_VALID(m5_d4) AND JSON_LENGTH(m5_d4) > 0 UNION ALL SELECT m5_d5 AS day_data, 'm5_d5' AS col_origin FROM worker_timesheet WHERE m5_d5 IS NOT NULL AND JSON_VALID(m5_d5) AND JSON_LENGTH(m5_d5) > 0 UNION ALL SELECT m5_d6 AS day_data, 'm5_d6' AS col_origin FROM worker_timesheet WHERE m5_d6 IS NOT NULL AND JSON_VALID(m5_d6) AND JSON_LENGTH(m5_d6) > 0 UNION ALL SELECT m5_d7 AS day_data, 'm5_d7' AS col_origin FROM worker_timesheet WHERE m5_d7 IS NOT NULL AND JSON_VALID(m5_d7) AND JSON_LENGTH(m5_d7) > 0 UNION ALL SELECT m5_d8 AS day_data, 'm5_d8' AS col_origin FROM worker_timesheet WHERE m5_d8 IS NOT NULL AND JSON_VALID(m5_d8) AND JSON_LENGTH(m5_d8) > 0 UNION ALL SELECT m5_d9 AS day_data, 'm5_d9' AS col_origin FROM worker_timesheet WHERE m5_d9 IS NOT NULL AND JSON_VALID(m5_d9) AND JSON_LENGTH(m5_d9) > 0 UNION ALL SELECT m5_d10 AS day_data, 'm5_d10' AS col_origin FROM worker_timesheet WHERE m5_d10 IS NOT NULL AND JSON_VALID(m5_d10) AND JSON_LENGTH(m5_d10) > 0 UNION ALL SELECT m5_d11 AS day_data, 'm5_d11' AS col_origin FROM worker_timesheet WHERE m5_d11 IS NOT NULL AND JSON_VALID(m5_d11) AND JSON_LENGTH(m5_d11) > 0 UNION ALL SELECT m5_d12 AS day_data, 'm5_d12' AS col_origin FROM worker_timesheet WHERE m5_d12 IS NOT NULL AND JSON_VALID(m5_d12) AND JSON_LENGTH(m5_d12) > 0 UNION ALL SELECT m5_d13 AS day_data, 'm5_d13' AS col_origin FROM worker_timesheet WHERE m5_d13 IS NOT NULL AND JSON_VALID(m5_d13) AND JSON_LENGTH(m5_d13) > 0 UNION ALL SELECT m5_d14 AS day_data, 'm5_d14' AS col_origin FROM worker_timesheet WHERE m5_d14 IS NOT NULL AND JSON_VALID(m5_d14) AND JSON_LENGTH(m5_d14) > 0 UNION ALL SELECT m5_d15 AS day_data, 'm5_d15' AS col_origin FROM worker_timesheet WHERE m5_d15 IS NOT NULL AND JSON_VALID(m5_d15) AND JSON_LENGTH(m5_d15) > 0 UNION ALL SELECT m5_d16 AS day_data, 'm5_d16' AS col_origin FROM worker_timesheet WHERE m5_d16 IS NOT NULL AND JSON_VALID(m5_d16) AND JSON_LENGTH(m5_d16) > 0 UNION ALL SELECT m5_d17 AS day_data, 'm5_d17' AS col_origin FROM worker_timesheet WHERE m5_d17 IS NOT NULL AND JSON_VALID(m5_d17) AND JSON_LENGTH(m5_d17) > 0 UNION ALL SELECT m5_d18 AS day_data, 'm5_d18' AS col_origin FROM worker_timesheet WHERE m5_d18 IS NOT NULL AND JSON_VALID(m5_d18) AND JSON_LENGTH(m5_d18) > 0 UNION ALL SELECT m5_d19 AS day_data, 'm5_d19' AS col_origin FROM worker_timesheet WHERE m5_d19 IS NOT NULL AND JSON_VALID(m5_d19) AND JSON_LENGTH(m5_d19) > 0 UNION ALL SELECT m5_d20 AS day_data, 'm5_d20' AS col_origin FROM worker_timesheet WHERE m5_d20 IS NOT NULL AND JSON_VALID(m5_d20) AND JSON_LENGTH(m5_d20) > 0 UNION ALL SELECT m5_d21 AS day_data, 'm5_d21' AS col_origin FROM worker_timesheet WHERE m5_d21 IS NOT NULL AND JSON_VALID(m5_d21) AND JSON_LENGTH(m5_d21) > 0 UNION ALL SELECT m5_d22 AS day_data, 'm5_d22' AS col_origin FROM worker_timesheet WHERE m5_d22 IS NOT NULL AND JSON_VALID(m5_d22) AND JSON_LENGTH(m5_d22) > 0 UNION ALL SELECT m5_d23 AS day_data, 'm5_d23' AS col_origin FROM worker_timesheet WHERE m5_d23 IS NOT NULL AND JSON_VALID(m5_d23) AND JSON_LENGTH(m5_d23) > 0 UNION ALL SELECT m5_d24 AS day_data, 'm5_d24' AS col_origin FROM worker_timesheet WHERE m5_d24 IS NOT NULL AND JSON_VALID(m5_d24) AND JSON_LENGTH(m5_d24) > 0 UNION ALL SELECT m5_d25 AS day_data, 'm5_d25' AS col_origin FROM worker_timesheet WHERE m5_d25 IS NOT NULL AND JSON_VALID(m5_d25) AND JSON_LENGTH(m5_d25) > 0 UNION ALL SELECT m5_d26 AS day_data, 'm5_d26' AS col_origin FROM worker_timesheet WHERE m5_d26 IS NOT NULL AND JSON_VALID(m5_d26) AND JSON_LENGTH(m5_d26) > 0 UNION ALL SELECT m5_d27 AS day_data, 'm5_d27' AS col_origin FROM worker_timesheet WHERE m5_d27 IS NOT NULL AND JSON_VALID(m5_d27) AND JSON_LENGTH(m5_d27) > 0 UNION ALL SELECT m5_d28 AS day_data, 'm5_d28' AS col_origin FROM worker_timesheet WHERE m5_d28 IS NOT NULL AND JSON_VALID(m5_d28) AND JSON_LENGTH(m5_d28) > 0 UNION ALL SELECT m5_d29 AS day_data, 'm5_d29' AS col_origin FROM worker_timesheet WHERE m5_d29 IS NOT NULL AND JSON_VALID(m5_d29) AND JSON_LENGTH(m5_d29) > 0 UNION ALL SELECT m5_d30 AS day_data, 'm5_d30' AS col_origin FROM worker_timesheet WHERE m5_d30 IS NOT NULL AND JSON_VALID(m5_d30) AND JSON_LENGTH(m5_d30) > 0 UNION ALL SELECT m5_d31 AS day_data, 'm5_d31' AS col_origin FROM worker_timesheet WHERE m5_d31 IS NOT NULL AND JSON_VALID(m5_d31) AND JSON_LENGTH(m5_d31) > 0 UNION ALL SELECT m6_d1 AS day_data, 'm6_d1' AS col_origin FROM worker_timesheet WHERE m6_d1 IS NOT NULL AND JSON_VALID(m6_d1) AND JSON_LENGTH(m6_d1) > 0 UNION ALL SELECT m6_d2 AS day_data, 'm6_d2' AS col_origin FROM worker_timesheet WHERE m6_d2 IS NOT NULL AND JSON_VALID(m6_d2) AND JSON_LENGTH(m6_d2) > 0 UNION ALL SELECT m6_d3 AS day_data, 'm6_d3' AS col_origin FROM worker_timesheet WHERE m6_d3 IS NOT NULL AND JSON_VALID(m6_d3) AND JSON_LENGTH(m6_d3) > 0 UNION ALL SELECT m6_d4 AS day_data, 'm6_d4' AS col_origin FROM worker_timesheet WHERE m6_d4 IS NOT NULL AND JSON_VALID(m6_d4) AND JSON_LENGTH(m6_d4) > 0 UNION ALL SELECT m6_d5 AS day_data, 'm6_d5' AS col_origin FROM worker_timesheet WHERE m6_d5 IS NOT NULL AND JSON_VALID(m6_d5) AND JSON_LENGTH(m6_d5) > 0 UNION ALL SELECT m6_d6 AS day_data, 'm6_d6' AS col_origin FROM worker_timesheet WHERE m6_d6 IS NOT NULL AND JSON_VALID(m6_d6) AND JSON_LENGTH(m6_d6) > 0 UNION ALL SELECT m6_d7 AS day_data, 'm6_d7' AS col_origin FROM worker_timesheet WHERE m6_d7 IS NOT NULL AND JSON_VALID(m6_d7) AND JSON_LENGTH(m6_d7) > 0 UNION ALL SELECT m6_d8 AS day_data, 'm6_d8' AS col_origin FROM worker_timesheet WHERE m6_d8 IS NOT NULL AND JSON_VALID(m6_d8) AND JSON_LENGTH(m6_d8) > 0 UNION ALL SELECT m6_d9 AS day_data, 'm6_d9' AS col_origin FROM worker_timesheet WHERE m6_d9 IS NOT NULL AND JSON_VALID(m6_d9) AND JSON_LENGTH(m6_d9) > 0 UNION ALL SELECT m6_d10 AS day_data, 'm6_d10' AS col_origin FROM worker_timesheet WHERE m6_d10 IS NOT NULL AND JSON_VALID(m6_d10) AND JSON_LENGTH(m6_d10) > 0 UNION ALL SELECT m6_d11 AS day_data, 'm6_d11' AS col_origin FROM worker_timesheet WHERE m6_d11 IS NOT NULL AND JSON_VALID(m6_d11) AND JSON_LENGTH(m6_d11) > 0 UNION ALL SELECT m6_d12 AS day_data, 'm6_d12' AS col_origin FROM worker_timesheet WHERE m6_d12 IS NOT NULL AND JSON_VALID(m6_d12) AND JSON_LENGTH(m6_d12) > 0 UNION ALL SELECT m6_d13 AS day_data, 'm6_d13' AS col_origin FROM worker_timesheet WHERE m6_d13 IS NOT NULL AND JSON_VALID(m6_d13) AND JSON_LENGTH(m6_d13) > 0 UNION ALL SELECT m6_d14 AS day_data, 'm6_d14' AS col_origin FROM worker_timesheet WHERE m6_d14 IS NOT NULL AND JSON_VALID(m6_d14) AND JSON_LENGTH(m6_d14) > 0 UNION ALL SELECT m6_d15 AS day_data, 'm6_d15' AS col_origin FROM worker_timesheet WHERE m6_d15 IS NOT NULL AND JSON_VALID(m6_d15) AND JSON_LENGTH(m6_d15) > 0 UNION ALL SELECT m6_d16 AS day_data, 'm6_d16' AS col_origin FROM worker_timesheet WHERE m6_d16 IS NOT NULL AND JSON_VALID(m6_d16) AND JSON_LENGTH(m6_d16) > 0 UNION ALL SELECT m6_d17 AS day_data, 'm6_d17' AS col_origin FROM worker_timesheet WHERE m6_d17 IS NOT NULL AND JSON_VALID(m6_d17) AND JSON_LENGTH(m6_d17) > 0 UNION ALL SELECT m6_d18 AS day_data, 'm6_d18' AS col_origin FROM worker_timesheet WHERE m6_d18 IS NOT NULL AND JSON_VALID(m6_d18) AND JSON_LENGTH(m6_d18) > 0 UNION ALL SELECT m6_d19 AS day_data, 'm6_d19' AS col_origin FROM worker_timesheet WHERE m6_d19 IS NOT NULL AND JSON_VALID(m6_d19) AND JSON_LENGTH(m6_d19) > 0 UNION ALL SELECT m6_d20 AS day_data, 'm6_d20' AS col_origin FROM worker_timesheet WHERE m6_d20 IS NOT NULL AND JSON_VALID(m6_d20) AND JSON_LENGTH(m6_d20) > 0 UNION ALL SELECT m6_d21 AS day_data, 'm6_d21' AS col_origin FROM worker_timesheet WHERE m6_d21 IS NOT NULL AND JSON_VALID(m6_d21) AND JSON_LENGTH(m6_d21) > 0 UNION ALL SELECT m6_d22 AS day_data, 'm6_d22' AS col_origin FROM worker_timesheet WHERE m6_d22 IS NOT NULL AND JSON_VALID(m6_d22) AND JSON_LENGTH(m6_d22) > 0 UNION ALL SELECT m6_d23 AS day_data, 'm6_d23' AS col_origin FROM worker_timesheet WHERE m6_d23 IS NOT NULL AND JSON_VALID(m6_d23) AND JSON_LENGTH(m6_d23) > 0 UNION ALL SELECT m6_d24 AS day_data, 'm6_d24' AS col_origin FROM worker_timesheet WHERE m6_d24 IS NOT NULL AND JSON_VALID(m6_d24) AND JSON_LENGTH(m6_d24) > 0 UNION ALL SELECT m6_d25 AS day_data, 'm6_d25' AS col_origin FROM worker_timesheet WHERE m6_d25 IS NOT NULL AND JSON_VALID(m6_d25) AND JSON_LENGTH(m6_d25) > 0 UNION ALL SELECT m6_d26 AS day_data, 'm6_d26' AS col_origin FROM worker_timesheet WHERE m6_d26 IS NOT NULL AND JSON_VALID(m6_d26) AND JSON_LENGTH(m6_d26) > 0 UNION ALL SELECT m6_d27 AS day_data, 'm6_d27' AS col_origin FROM worker_timesheet WHERE m6_d27 IS NOT NULL AND JSON_VALID(m6_d27) AND JSON_LENGTH(m6_d27) > 0 UNION ALL SELECT m6_d28 AS day_data, 'm6_d28' AS col_origin FROM worker_timesheet WHERE m6_d28 IS NOT NULL AND JSON_VALID(m6_d28) AND JSON_LENGTH(m6_d28) > 0 UNION ALL SELECT m6_d29 AS day_data, 'm6_d29' AS col_origin FROM worker_timesheet WHERE m6_d29 IS NOT NULL AND JSON_VALID(m6_d29) AND JSON_LENGTH(m6_d29) > 0 UNION ALL SELECT m6_d30 AS day_data, 'm6_d30' AS col_origin FROM worker_timesheet WHERE m6_d30 IS NOT NULL AND JSON_VALID(m6_d30) AND JSON_LENGTH(m6_d30) > 0 UNION ALL SELECT m6_d31 AS day_data, 'm6_d31' AS col_origin FROM worker_timesheet WHERE m6_d31 IS NOT NULL AND JSON_VALID(m6_d31) AND JSON_LENGTH(m6_d31) > 0 UNION ALL SELECT m7_d1 AS day_data, 'm7_d1' AS col_origin FROM worker_timesheet WHERE m7_d1 IS NOT NULL AND JSON_VALID(m7_d1) AND JSON_LENGTH(m7_d1) > 0 UNION ALL SELECT m7_d2 AS day_data, 'm7_d2' AS col_origin FROM worker_timesheet WHERE m7_d2 IS NOT NULL AND JSON_VALID(m7_d2) AND JSON_LENGTH(m7_d2) > 0 UNION ALL SELECT m7_d3 AS day_data, 'm7_d3' AS col_origin FROM worker_timesheet WHERE m7_d3 IS NOT NULL AND JSON_VALID(m7_d3) AND JSON_LENGTH(m7_d3) > 0 UNION ALL SELECT m7_d4 AS day_data, 'm7_d4' AS col_origin FROM worker_timesheet WHERE m7_d4 IS NOT NULL AND JSON_VALID(m7_d4) AND JSON_LENGTH(m7_d4) > 0 UNION ALL SELECT m7_d5 AS day_data, 'm7_d5' AS col_origin FROM worker_timesheet WHERE m7_d5 IS NOT NULL AND JSON_VALID(m7_d5) AND JSON_LENGTH(m7_d5) > 0 UNION ALL SELECT m7_d6 AS day_data, 'm7_d6' AS col_origin FROM worker_timesheet WHERE m7_d6 IS NOT NULL AND JSON_VALID(m7_d6) AND JSON_LENGTH(m7_d6) > 0 UNION ALL SELECT m7_d7 AS day_data, 'm7_d7' AS col_origin FROM worker_timesheet WHERE m7_d7 IS NOT NULL AND JSON_VALID(m7_d7) AND JSON_LENGTH(m7_d7) > 0 UNION ALL SELECT m7_d8 AS day_data, 'm7_d8' AS col_origin FROM worker_timesheet WHERE m7_d8 IS NOT NULL AND JSON_VALID(m7_d8) AND JSON_LENGTH(m7_d8) > 0 UNION ALL SELECT m7_d9 AS day_data, 'm7_d9' AS col_origin FROM worker_timesheet WHERE m7_d9 IS NOT NULL AND JSON_VALID(m7_d9) AND JSON_LENGTH(m7_d9) > 0 UNION ALL SELECT m7_d10 AS day_data, 'm7_d10' AS col_origin FROM worker_timesheet WHERE m7_d10 IS NOT NULL AND JSON_VALID(m7_d10) AND JSON_LENGTH(m7_d10) > 0 UNION ALL SELECT m7_d11 AS day_data, 'm7_d11' AS col_origin FROM worker_timesheet WHERE m7_d11 IS NOT NULL AND JSON_VALID(m7_d11) AND JSON_LENGTH(m7_d11) > 0 UNION ALL SELECT m7_d12 AS day_data, 'm7_d12' AS col_origin FROM worker_timesheet WHERE m7_d12 IS NOT NULL AND JSON_VALID(m7_d12) AND JSON_LENGTH(m7_d12) > 0 UNION ALL SELECT m7_d13 AS day_data, 'm7_d13' AS col_origin FROM worker_timesheet WHERE m7_d13 IS NOT NULL AND JSON_VALID(m7_d13) AND JSON_LENGTH(m7_d13) > 0 UNION ALL SELECT m7_d14 AS day_data, 'm7_d14' AS col_origin FROM worker_timesheet WHERE m7_d14 IS NOT NULL AND JSON_VALID(m7_d14) AND JSON_LENGTH(m7_d14) > 0 UNION ALL SELECT m7_d15 AS day_data, 'm7_d15' AS col_origin FROM worker_timesheet WHERE m7_d15 IS NOT NULL AND JSON_VALID(m7_d15) AND JSON_LENGTH(m7_d15) > 0 UNION ALL SELECT m7_d16 AS day_data, 'm7_d16' AS col_origin FROM worker_timesheet WHERE m7_d16 IS NOT NULL AND JSON_VALID(m7_d16) AND JSON_LENGTH(m7_d16) > 0 UNION ALL SELECT m7_d17 AS day_data, 'm7_d17' AS col_origin FROM worker_timesheet WHERE m7_d17 IS NOT NULL AND JSON_VALID(m7_d17) AND JSON_LENGTH(m7_d17) > 0 UNION ALL SELECT m7_d18 AS day_data, 'm7_d18' AS col_origin FROM worker_timesheet WHERE m7_d18 IS NOT NULL AND JSON_VALID(m7_d18) AND JSON_LENGTH(m7_d18) > 0 UNION ALL SELECT m7_d19 AS day_data, 'm7_d19' AS col_origin FROM worker_timesheet WHERE m7_d19 IS NOT NULL AND JSON_VALID(m7_d19) AND JSON_LENGTH(m7_d19) > 0 UNION ALL SELECT m7_d20 AS day_data, 'm7_d20' AS col_origin FROM worker_timesheet WHERE m7_d20 IS NOT NULL AND JSON_VALID(m7_d20) AND JSON_LENGTH(m7_d20) > 0 UNION ALL SELECT m7_d21 AS day_data, 'm7_d21' AS col_origin FROM worker_timesheet WHERE m7_d21 IS NOT NULL AND JSON_VALID(m7_d21) AND JSON_LENGTH(m7_d21) > 0 UNION ALL SELECT m7_d22 AS day_data, 'm7_d22' AS col_origin FROM worker_timesheet WHERE m7_d22 IS NOT NULL AND JSON_VALID(m7_d22) AND JSON_LENGTH(m7_d22) > 0 UNION ALL SELECT m7_d23 AS day_data, 'm7_d23' AS col_origin FROM worker_timesheet WHERE m7_d23 IS NOT NULL AND JSON_VALID(m7_d23) AND JSON_LENGTH(m7_d23) > 0 UNION ALL SELECT m7_d24 AS day_data, 'm7_d24' AS col_origin FROM worker_timesheet WHERE m7_d24 IS NOT NULL AND JSON_VALID(m7_d24) AND JSON_LENGTH(m7_d24) > 0 UNION ALL SELECT m7_d25 AS day_data, 'm7_d25' AS col_origin FROM worker_timesheet WHERE m7_d25 IS NOT NULL AND JSON_VALID(m7_d25) AND JSON_LENGTH(m7_d25) > 0 UNION ALL SELECT m7_d26 AS day_data, 'm7_d26' AS col_origin FROM worker_timesheet WHERE m7_d26 IS NOT NULL AND JSON_VALID(m7_d26) AND JSON_LENGTH(m7_d26) > 0 UNION ALL SELECT m7_d27 AS day_data, 'm7_d27' AS col_origin FROM worker_timesheet WHERE m7_d27 IS NOT NULL AND JSON_VALID(m7_d27) AND JSON_LENGTH(m7_d27) > 0 UNION ALL SELECT m7_d28 AS day_data, 'm7_d28' AS col_origin FROM worker_timesheet WHERE m7_d28 IS NOT NULL AND JSON_VALID(m7_d28) AND JSON_LENGTH(m7_d28) > 0 UNION ALL SELECT m7_d29 AS day_data, 'm7_d29' AS col_origin FROM worker_timesheet WHERE m7_d29 IS NOT NULL AND JSON_VALID(m7_d29) AND JSON_LENGTH(m7_d29) > 0 UNION ALL SELECT m7_d30 AS day_data, 'm7_d30' AS col_origin FROM worker_timesheet WHERE m7_d30 IS NOT NULL AND JSON_VALID(m7_d30) AND JSON_LENGTH(m7_d30) > 0 UNION ALL SELECT m7_d31 AS day_data, 'm7_d31' AS col_origin FROM worker_timesheet WHERE m7_d31 IS NOT NULL AND JSON_VALID(m7_d31) AND JSON_LENGTH(m7_d31) > 0 UNION ALL SELECT m8_d1 AS day_data, 'm8_d1' AS col_origin FROM worker_timesheet WHERE m8_d1 IS NOT NULL AND JSON_VALID(m8_d1) AND JSON_LENGTH(m8_d1) > 0 UNION ALL SELECT m8_d2 AS day_data, 'm8_d2' AS col_origin FROM worker_timesheet WHERE m8_d2 IS NOT NULL AND JSON_VALID(m8_d2) AND JSON_LENGTH(m8_d2) > 0 UNION ALL SELECT m8_d3 AS day_data, 'm8_d3' AS col_origin FROM worker_timesheet WHERE m8_d3 IS NOT NULL AND JSON_VALID(m8_d3) AND JSON_LENGTH(m8_d3) > 0 UNION ALL SELECT m8_d4 AS day_data, 'm8_d4' AS col_origin FROM worker_timesheet WHERE m8_d4 IS NOT NULL AND JSON_VALID(m8_d4) AND JSON_LENGTH(m8_d4) > 0 UNION ALL SELECT m8_d5 AS day_data, 'm8_d5' AS col_origin FROM worker_timesheet WHERE m8_d5 IS NOT NULL AND JSON_VALID(m8_d5) AND JSON_LENGTH(m8_d5) > 0 UNION ALL SELECT m8_d6 AS day_data, 'm8_d6' AS col_origin FROM worker_timesheet WHERE m8_d6 IS NOT NULL AND JSON_VALID(m8_d6) AND JSON_LENGTH(m8_d6) > 0 UNION ALL SELECT m8_d7 AS day_data, 'm8_d7' AS col_origin FROM worker_timesheet WHERE m8_d7 IS NOT NULL AND JSON_VALID(m8_d7) AND JSON_LENGTH(m8_d7) > 0 UNION ALL SELECT m8_d8 AS day_data, 'm8_d8' AS col_origin FROM worker_timesheet WHERE m8_d8 IS NOT NULL AND JSON_VALID(m8_d8) AND JSON_LENGTH(m8_d8) > 0 UNION ALL SELECT m8_d9 AS day_data, 'm8_d9' AS col_origin FROM worker_timesheet WHERE m8_d9 IS NOT NULL AND JSON_VALID(m8_d9) AND JSON_LENGTH(m8_d9) > 0 UNION ALL SELECT m8_d10 AS day_data, 'm8_d10' AS col_origin FROM worker_timesheet WHERE m8_d10 IS NOT NULL AND JSON_VALID(m8_d10) AND JSON_LENGTH(m8_d10) > 0 UNION ALL SELECT m8_d11 AS day_data, 'm8_d11' AS col_origin FROM worker_timesheet WHERE m8_d11 IS NOT NULL AND JSON_VALID(m8_d11) AND JSON_LENGTH(m8_d11) > 0 UNION ALL SELECT m8_d12 AS day_data, 'm8_d12' AS col_origin FROM worker_timesheet WHERE m8_d12 IS NOT NULL AND JSON_VALID(m8_d12) AND JSON_LENGTH(m8_d12) > 0 UNION ALL SELECT m8_d13 AS day_data, 'm8_d13' AS col_origin FROM worker_timesheet WHERE m8_d13 IS NOT NULL AND JSON_VALID(m8_d13) AND JSON_LENGTH(m8_d13) > 0 UNION ALL SELECT m8_d14 AS day_data, 'm8_d14' AS col_origin FROM worker_timesheet WHERE m8_d14 IS NOT NULL AND JSON_VALID(m8_d14) AND JSON_LENGTH(m8_d14) > 0 UNION ALL SELECT m8_d15 AS day_data, 'm8_d15' AS col_origin FROM worker_timesheet WHERE m8_d15 IS NOT NULL AND JSON_VALID(m8_d15) AND JSON_LENGTH(m8_d15) > 0 UNION ALL SELECT m8_d16 AS day_data, 'm8_d16' AS col_origin FROM worker_timesheet WHERE m8_d16 IS NOT NULL AND JSON_VALID(m8_d16) AND JSON_LENGTH(m8_d16) > 0 UNION ALL SELECT m8_d17 AS day_data, 'm8_d17' AS col_origin FROM worker_timesheet WHERE m8_d17 IS NOT NULL AND JSON_VALID(m8_d17) AND JSON_LENGTH(m8_d17) > 0 UNION ALL SELECT m8_d18 AS day_data, 'm8_d18' AS col_origin FROM worker_timesheet WHERE m8_d18 IS NOT NULL AND JSON_VALID(m8_d18) AND JSON_LENGTH(m8_d18) > 0 UNION ALL SELECT m8_d19 AS day_data, 'm8_d19' AS col_origin FROM worker_timesheet WHERE m8_d19 IS NOT NULL AND JSON_VALID(m8_d19) AND JSON_LENGTH(m8_d19) > 0 UNION ALL SELECT m8_d20 AS day_data, 'm8_d20' AS col_origin FROM worker_timesheet WHERE m8_d20 IS NOT NULL AND JSON_VALID(m8_d20) AND JSON_LENGTH(m8_d20) > 0 UNION ALL SELECT m8_d21 AS day_data, 'm8_d21' AS col_origin FROM worker_timesheet WHERE m8_d21 IS NOT NULL AND JSON_VALID(m8_d21) AND JSON_LENGTH(m8_d21) > 0 UNION ALL SELECT m8_d22 AS day_data, 'm8_d22' AS col_origin FROM worker_timesheet WHERE m8_d22 IS NOT NULL AND JSON_VALID(m8_d22) AND JSON_LENGTH(m8_d22) > 0 UNION ALL SELECT m8_d23 AS day_data, 'm8_d23' AS col_origin FROM worker_timesheet WHERE m8_d23 IS NOT NULL AND JSON_VALID(m8_d23) AND JSON_LENGTH(m8_d23) > 0 UNION ALL SELECT m8_d24 AS day_data, 'm8_d24' AS col_origin FROM worker_timesheet WHERE m8_d24 IS NOT NULL AND JSON_VALID(m8_d24) AND JSON_LENGTH(m8_d24) > 0 UNION ALL SELECT m8_d25 AS day_data, 'm8_d25' AS col_origin FROM worker_timesheet WHERE m8_d25 IS NOT NULL AND JSON_VALID(m8_d25) AND JSON_LENGTH(m8_d25) > 0 UNION ALL SELECT m8_d26 AS day_data, 'm8_d26' AS col_origin FROM worker_timesheet WHERE m8_d26 IS NOT NULL AND JSON_VALID(m8_d26) AND JSON_LENGTH(m8_d26) > 0 UNION ALL SELECT m8_d27 AS day_data, 'm8_d27' AS col_origin FROM worker_timesheet WHERE m8_d27 IS NOT NULL AND JSON_VALID(m8_d27) AND JSON_LENGTH(m8_d27) > 0 UNION ALL SELECT m8_d28 AS day_data, 'm8_d28' AS col_origin FROM worker_timesheet WHERE m8_d28 IS NOT NULL AND JSON_VALID(m8_d28) AND JSON_LENGTH(m8_d28) > 0 UNION ALL SELECT m8_d29 AS day_data, 'm8_d29' AS col_origin FROM worker_timesheet WHERE m8_d29 IS NOT NULL AND JSON_VALID(m8_d29) AND JSON_LENGTH(m8_d29) > 0 UNION ALL SELECT m8_d30 AS day_data, 'm8_d30' AS col_origin FROM worker_timesheet WHERE m8_d30 IS NOT NULL AND JSON_VALID(m8_d30) AND JSON_LENGTH(m8_d30) > 0 UNION ALL SELECT m8_d31 AS day_data, 'm8_d31' AS col_origin FROM worker_timesheet WHERE m8_d31 IS NOT NULL AND JSON_VALID(m8_d31) AND JSON_LENGTH(m8_d31) > 0 UNION ALL SELECT m9_d1 AS day_data, 'm9_d1' AS col_origin FROM worker_timesheet WHERE m9_d1 IS NOT NULL AND JSON_VALID(m9_d1) AND JSON_LENGTH(m9_d1) > 0 UNION ALL SELECT m9_d2 AS day_data, 'm9_d2' AS col_origin FROM worker_timesheet WHERE m9_d2 IS NOT NULL AND JSON_VALID(m9_d2) AND JSON_LENGTH(m9_d2) > 0 UNION ALL SELECT m9_d3 AS day_data, 'm9_d3' AS col_origin FROM worker_timesheet WHERE m9_d3 IS NOT NULL AND JSON_VALID(m9_d3) AND JSON_LENGTH(m9_d3) > 0 UNION ALL SELECT m9_d4 AS day_data, 'm9_d4' AS col_origin FROM worker_timesheet WHERE m9_d4 IS NOT NULL AND JSON_VALID(m9_d4) AND JSON_LENGTH(m9_d4) > 0 UNION ALL SELECT m9_d5 AS day_data, 'm9_d5' AS col_origin FROM worker_timesheet WHERE m9_d5 IS NOT NULL AND JSON_VALID(m9_d5) AND JSON_LENGTH(m9_d5) > 0 UNION ALL SELECT m9_d6 AS day_data, 'm9_d6' AS col_origin FROM worker_timesheet WHERE m9_d6 IS NOT NULL AND JSON_VALID(m9_d6) AND JSON_LENGTH(m9_d6) > 0 UNION ALL SELECT m9_d7 AS day_data, 'm9_d7' AS col_origin FROM worker_timesheet WHERE m9_d7 IS NOT NULL AND JSON_VALID(m9_d7) AND JSON_LENGTH(m9_d7) > 0 UNION ALL SELECT m9_d8 AS day_data, 'm9_d8' AS col_origin FROM worker_timesheet WHERE m9_d8 IS NOT NULL AND JSON_VALID(m9_d8) AND JSON_LENGTH(m9_d8) > 0 UNION ALL SELECT m9_d9 AS day_data, 'm9_d9' AS col_origin FROM worker_timesheet WHERE m9_d9 IS NOT NULL AND JSON_VALID(m9_d9) AND JSON_LENGTH(m9_d9) > 0 UNION ALL SELECT m9_d10 AS day_data, 'm9_d10' AS col_origin FROM worker_timesheet WHERE m9_d10 IS NOT NULL AND JSON_VALID(m9_d10) AND JSON_LENGTH(m9_d10) > 0 UNION ALL SELECT m9_d11 AS day_data, 'm9_d11' AS col_origin FROM worker_timesheet WHERE m9_d11 IS NOT NULL AND JSON_VALID(m9_d11) AND JSON_LENGTH(m9_d11) > 0 UNION ALL SELECT m9_d12 AS day_data, 'm9_d12' AS col_origin FROM worker_timesheet WHERE m9_d12 IS NOT NULL AND JSON_VALID(m9_d12) AND JSON_LENGTH(m9_d12) > 0 UNION ALL SELECT m9_d13 AS day_data, 'm9_d13' AS col_origin FROM worker_timesheet WHERE m9_d13 IS NOT NULL AND JSON_VALID(m9_d13) AND JSON_LENGTH(m9_d13) > 0 UNION ALL SELECT m9_d14 AS day_data, 'm9_d14' AS col_origin FROM worker_timesheet WHERE m9_d14 IS NOT NULL AND JSON_VALID(m9_d14) AND JSON_LENGTH(m9_d14) > 0 UNION ALL SELECT m9_d15 AS day_data, 'm9_d15' AS col_origin FROM worker_timesheet WHERE m9_d15 IS NOT NULL AND JSON_VALID(m9_d15) AND JSON_LENGTH(m9_d15) > 0 UNION ALL SELECT m9_d16 AS day_data, 'm9_d16' AS col_origin FROM worker_timesheet WHERE m9_d16 IS NOT NULL AND JSON_VALID(m9_d16) AND JSON_LENGTH(m9_d16) > 0 UNION ALL SELECT m9_d17 AS day_data, 'm9_d17' AS col_origin FROM worker_timesheet WHERE m9_d17 IS NOT NULL AND JSON_VALID(m9_d17) AND JSON_LENGTH(m9_d17) > 0 UNION ALL SELECT m9_d18 AS day_data, 'm9_d18' AS col_origin FROM worker_timesheet WHERE m9_d18 IS NOT NULL AND JSON_VALID(m9_d18) AND JSON_LENGTH(m9_d18) > 0 UNION ALL SELECT m9_d19 AS day_data, 'm9_d19' AS col_origin FROM worker_timesheet WHERE m9_d19 IS NOT NULL AND JSON_VALID(m9_d19) AND JSON_LENGTH(m9_d19) > 0 UNION ALL SELECT m9_d20 AS day_data, 'm9_d20' AS col_origin FROM worker_timesheet WHERE m9_d20 IS NOT NULL AND JSON_VALID(m9_d20) AND JSON_LENGTH(m9_d20) > 0 UNION ALL SELECT m9_d21 AS day_data, 'm9_d21' AS col_origin FROM worker_timesheet WHERE m9_d21 IS NOT NULL AND JSON_VALID(m9_d21) AND JSON_LENGTH(m9_d21) > 0 UNION ALL SELECT m9_d22 AS day_data, 'm9_d22' AS col_origin FROM worker_timesheet WHERE m9_d22 IS NOT NULL AND JSON_VALID(m9_d22) AND JSON_LENGTH(m9_d22) > 0 UNION ALL SELECT m9_d23 AS day_data, 'm9_d23' AS col_origin FROM worker_timesheet WHERE m9_d23 IS NOT NULL AND JSON_VALID(m9_d23) AND JSON_LENGTH(m9_d23) > 0 UNION ALL SELECT m9_d24 AS day_data, 'm9_d24' AS col_origin FROM worker_timesheet WHERE m9_d24 IS NOT NULL AND JSON_VALID(m9_d24) AND JSON_LENGTH(m9_d24) > 0 UNION ALL SELECT m9_d25 AS day_data, 'm9_d25' AS col_origin FROM worker_timesheet WHERE m9_d25 IS NOT NULL AND JSON_VALID(m9_d25) AND JSON_LENGTH(m9_d25) > 0 UNION ALL SELECT m9_d26 AS day_data, 'm9_d26' AS col_origin FROM worker_timesheet WHERE m9_d26 IS NOT NULL AND JSON_VALID(m9_d26) AND JSON_LENGTH(m9_d26) > 0 UNION ALL SELECT m9_d27 AS day_data, 'm9_d27' AS col_origin FROM worker_timesheet WHERE m9_d27 IS NOT NULL AND JSON_VALID(m9_d27) AND JSON_LENGTH(m9_d27) > 0 UNION ALL SELECT m9_d28 AS day_data, 'm9_d28' AS col_origin FROM worker_timesheet WHERE m9_d28 IS NOT NULL AND JSON_VALID(m9_d28) AND JSON_LENGTH(m9_d28) > 0 UNION ALL SELECT m9_d29 AS day_data, 'm9_d29' AS col_origin FROM worker_timesheet WHERE m9_d29 IS NOT NULL AND JSON_VALID(m9_d29) AND JSON_LENGTH(m9_d29) > 0 UNION ALL SELECT m9_d30 AS day_data, 'm9_d30' AS col_origin FROM worker_timesheet WHERE m9_d30 IS NOT NULL AND JSON_VALID(m9_d30) AND JSON_LENGTH(m9_d30) > 0 UNION ALL SELECT m9_d31 AS day_data, 'm9_d31' AS col_origin FROM worker_timesheet WHERE m9_d31 IS NOT NULL AND JSON_VALID(m9_d31) AND JSON_LENGTH(m9_d31) > 0 UNION ALL SELECT m10_d1 AS day_data, 'm10_d1' AS col_origin FROM worker_timesheet WHERE m10_d1 IS NOT NULL AND JSON_VALID(m10_d1) AND JSON_LENGTH(m10_d1) > 0 UNION ALL SELECT m10_d2 AS day_data, 'm10_d2' AS col_origin FROM worker_timesheet WHERE m10_d2 IS NOT NULL AND JSON_VALID(m10_d2) AND JSON_LENGTH(m10_d2) > 0 UNION ALL SELECT m10_d3 AS day_data, 'm10_d3' AS col_origin FROM worker_timesheet WHERE m10_d3 IS NOT NULL AND JSON_VALID(m10_d3) AND JSON_LENGTH(m10_d3) > 0 UNION ALL SELECT m10_d4 AS day_data, 'm10_d4' AS col_origin FROM worker_timesheet WHERE m10_d4 IS NOT NULL AND JSON_VALID(m10_d4) AND JSON_LENGTH(m10_d4) > 0 UNION ALL SELECT m10_d5 AS day_data, 'm10_d5' AS col_origin FROM worker_timesheet WHERE m10_d5 IS NOT NULL AND JSON_VALID(m10_d5) AND JSON_LENGTH(m10_d5) > 0 UNION ALL SELECT m10_d6 AS day_data, 'm10_d6' AS col_origin FROM worker_timesheet WHERE m10_d6 IS NOT NULL AND JSON_VALID(m10_d6) AND JSON_LENGTH(m10_d6) > 0 UNION ALL SELECT m10_d7 AS day_data, 'm10_d7' AS col_origin FROM worker_timesheet WHERE m10_d7 IS NOT NULL AND JSON_VALID(m10_d7) AND JSON_LENGTH(m10_d7) > 0 UNION ALL SELECT m10_d8 AS day_data, 'm10_d8' AS col_origin FROM worker_timesheet WHERE m10_d8 IS NOT NULL AND JSON_VALID(m10_d8) AND JSON_LENGTH(m10_d8) > 0 UNION ALL SELECT m10_d9 AS day_data, 'm10_d9' AS col_origin FROM worker_timesheet WHERE m10_d9 IS NOT NULL AND JSON_VALID(m10_d9) AND JSON_LENGTH(m10_d9) > 0 UNION ALL SELECT m10_d10 AS day_data, 'm10_d10' AS col_origin FROM worker_timesheet WHERE m10_d10 IS NOT NULL AND JSON_VALID(m10_d10) AND JSON_LENGTH(m10_d10) > 0 UNION ALL SELECT m10_d11 AS day_data, 'm10_d11' AS col_origin FROM worker_timesheet WHERE m10_d11 IS NOT NULL AND JSON_VALID(m10_d11) AND JSON_LENGTH(m10_d11) > 0 UNION ALL SELECT m10_d12 AS day_data, 'm10_d12' AS col_origin FROM worker_timesheet WHERE m10_d12 IS NOT NULL AND JSON_VALID(m10_d12) AND JSON_LENGTH(m10_d12) > 0 UNION ALL SELECT m10_d13 AS day_data, 'm10_d13' AS col_origin FROM worker_timesheet WHERE m10_d13 IS NOT NULL AND JSON_VALID(m10_d13) AND JSON_LENGTH(m10_d13) > 0 UNION ALL SELECT m10_d14 AS day_data, 'm10_d14' AS col_origin FROM worker_timesheet WHERE m10_d14 IS NOT NULL AND JSON_VALID(m10_d14) AND JSON_LENGTH(m10_d14) > 0 UNION ALL SELECT m10_d15 AS day_data, 'm10_d15' AS col_origin FROM worker_timesheet WHERE m10_d15 IS NOT NULL AND JSON_VALID(m10_d15) AND JSON_LENGTH(m10_d15) > 0 UNION ALL SELECT m10_d16 AS day_data, 'm10_d16' AS col_origin FROM worker_timesheet WHERE m10_d16 IS NOT NULL AND JSON_VALID(m10_d16) AND JSON_LENGTH(m10_d16) > 0 UNION ALL SELECT m10_d17 AS day_data, 'm10_d17' AS col_origin FROM worker_timesheet WHERE m10_d17 IS NOT NULL AND JSON_VALID(m10_d17) AND JSON_LENGTH(m10_d17) > 0 UNION ALL SELECT m10_d18 AS day_data, 'm10_d18' AS col_origin FROM worker_timesheet WHERE m10_d18 IS NOT NULL AND JSON_VALID(m10_d18) AND JSON_LENGTH(m10_d18) > 0 UNION ALL SELECT m10_d19 AS day_data, 'm10_d19' AS col_origin FROM worker_timesheet WHERE m10_d19 IS NOT NULL AND JSON_VALID(m10_d19) AND JSON_LENGTH(m10_d19) > 0 UNION ALL SELECT m10_d20 AS day_data, 'm10_d20' AS col_origin FROM worker_timesheet WHERE m10_d20 IS NOT NULL AND JSON_VALID(m10_d20) AND JSON_LENGTH(m10_d20) > 0 UNION ALL SELECT m10_d21 AS day_data, 'm10_d21' AS col_origin FROM worker_timesheet WHERE m10_d21 IS NOT NULL AND JSON_VALID(m10_d21) AND JSON_LENGTH(m10_d21) > 0 UNION ALL SELECT m10_d22 AS day_data, 'm10_d22' AS col_origin FROM worker_timesheet WHERE m10_d22 IS NOT NULL AND JSON_VALID(m10_d22) AND JSON_LENGTH(m10_d22) > 0 UNION ALL SELECT m10_d23 AS day_data, 'm10_d23' AS col_origin FROM worker_timesheet WHERE m10_d23 IS NOT NULL AND JSON_VALID(m10_d23) AND JSON_LENGTH(m10_d23) > 0 UNION ALL SELECT m10_d24 AS day_data, 'm10_d24' AS col_origin FROM worker_timesheet WHERE m10_d24 IS NOT NULL AND JSON_VALID(m10_d24) AND JSON_LENGTH(m10_d24) > 0 UNION ALL SELECT m10_d25 AS day_data, 'm10_d25' AS col_origin FROM worker_timesheet WHERE m10_d25 IS NOT NULL AND JSON_VALID(m10_d25) AND JSON_LENGTH(m10_d25) > 0 UNION ALL SELECT m10_d26 AS day_data, 'm10_d26' AS col_origin FROM worker_timesheet WHERE m10_d26 IS NOT NULL AND JSON_VALID(m10_d26) AND JSON_LENGTH(m10_d26) > 0 UNION ALL SELECT m10_d27 AS day_data, 'm10_d27' AS col_origin FROM worker_timesheet WHERE m10_d27 IS NOT NULL AND JSON_VALID(m10_d27) AND JSON_LENGTH(m10_d27) > 0 UNION ALL SELECT m10_d28 AS day_data, 'm10_d28' AS col_origin FROM worker_timesheet WHERE m10_d28 IS NOT NULL AND JSON_VALID(m10_d28) AND JSON_LENGTH(m10_d28) > 0 UNION ALL SELECT m10_d29 AS day_data, 'm10_d29' AS col_origin FROM worker_timesheet WHERE m10_d29 IS NOT NULL AND JSON_VALID(m10_d29) AND JSON_LENGTH(m10_d29) > 0 UNION ALL SELECT m10_d30 AS day_data, 'm10_d30' AS col_origin FROM worker_timesheet WHERE m10_d30 IS NOT NULL AND JSON_VALID(m10_d30) AND JSON_LENGTH(m10_d30) > 0 UNION ALL SELECT m10_d31 AS day_data, 'm10_d31' AS col_origin FROM worker_timesheet WHERE m10_d31 IS NOT NULL AND JSON_VALID(m10_d31) AND JSON_LENGTH(m10_d31) > 0 UNION ALL SELECT m11_d1 AS day_data, 'm11_d1' AS col_origin FROM worker_timesheet WHERE m11_d1 IS NOT NULL AND JSON_VALID(m11_d1) AND JSON_LENGTH(m11_d1) > 0 UNION ALL SELECT m11_d2 AS day_data, 'm11_d2' AS col_origin FROM worker_timesheet WHERE m11_d2 IS NOT NULL AND JSON_VALID(m11_d2) AND JSON_LENGTH(m11_d2) > 0 UNION ALL SELECT m11_d3 AS day_data, 'm11_d3' AS col_origin FROM worker_timesheet WHERE m11_d3 IS NOT NULL AND JSON_VALID(m11_d3) AND JSON_LENGTH(m11_d3) > 0 UNION ALL SELECT m11_d4 AS day_data, 'm11_d4' AS col_origin FROM worker_timesheet WHERE m11_d4 IS NOT NULL AND JSON_VALID(m11_d4) AND JSON_LENGTH(m11_d4) > 0 UNION ALL SELECT m11_d5 AS day_data, 'm11_d5' AS col_origin FROM worker_timesheet WHERE m11_d5 IS NOT NULL AND JSON_VALID(m11_d5) AND JSON_LENGTH(m11_d5) > 0 UNION ALL SELECT m11_d6 AS day_data, 'm11_d6' AS col_origin FROM worker_timesheet WHERE m11_d6 IS NOT NULL AND JSON_VALID(m11_d6) AND JSON_LENGTH(m11_d6) > 0 UNION ALL SELECT m11_d7 AS day_data, 'm11_d7' AS col_origin FROM worker_timesheet WHERE m11_d7 IS NOT NULL AND JSON_VALID(m11_d7) AND JSON_LENGTH(m11_d7) > 0 UNION ALL SELECT m11_d8 AS day_data, 'm11_d8' AS col_origin FROM worker_timesheet WHERE m11_d8 IS NOT NULL AND JSON_VALID(m11_d8) AND JSON_LENGTH(m11_d8) > 0 UNION ALL SELECT m11_d9 AS day_data, 'm11_d9' AS col_origin FROM worker_timesheet WHERE m11_d9 IS NOT NULL AND JSON_VALID(m11_d9) AND JSON_LENGTH(m11_d9) > 0 UNION ALL SELECT m11_d10 AS day_data, 'm11_d10' AS col_origin FROM worker_timesheet WHERE m11_d10 IS NOT NULL AND JSON_VALID(m11_d10) AND JSON_LENGTH(m11_d10) > 0 UNION ALL SELECT m11_d11 AS day_data, 'm11_d11' AS col_origin FROM worker_timesheet WHERE m11_d11 IS NOT NULL AND JSON_VALID(m11_d11) AND JSON_LENGTH(m11_d11) > 0 UNION ALL SELECT m11_d12 AS day_data, 'm11_d12' AS col_origin FROM worker_timesheet WHERE m11_d12 IS NOT NULL AND JSON_VALID(m11_d12) AND JSON_LENGTH(m11_d12) > 0 UNION ALL SELECT m11_d13 AS day_data, 'm11_d13' AS col_origin FROM worker_timesheet WHERE m11_d13 IS NOT NULL AND JSON_VALID(m11_d13) AND JSON_LENGTH(m11_d13) > 0 UNION ALL SELECT m11_d14 AS day_data, 'm11_d14' AS col_origin FROM worker_timesheet WHERE m11_d14 IS NOT NULL AND JSON_VALID(m11_d14) AND JSON_LENGTH(m11_d14) > 0 UNION ALL SELECT m11_d15 AS day_data, 'm11_d15' AS col_origin FROM worker_timesheet WHERE m11_d15 IS NOT NULL AND JSON_VALID(m11_d15) AND JSON_LENGTH(m11_d15) > 0 UNION ALL SELECT m11_d16 AS day_data, 'm11_d16' AS col_origin FROM worker_timesheet WHERE m11_d16 IS NOT NULL AND JSON_VALID(m11_d16) AND JSON_LENGTH(m11_d16) > 0 UNION ALL SELECT m11_d17 AS day_data, 'm11_d17' AS col_origin FROM worker_timesheet WHERE m11_d17 IS NOT NULL AND JSON_VALID(m11_d17) AND JSON_LENGTH(m11_d17) > 0 UNION ALL SELECT m11_d18 AS day_data, 'm11_d18' AS col_origin FROM worker_timesheet WHERE m11_d18 IS NOT NULL AND JSON_VALID(m11_d18) AND JSON_LENGTH(m11_d18) > 0 UNION ALL SELECT m11_d19 AS day_data, 'm11_d19' AS col_origin FROM worker_timesheet WHERE m11_d19 IS NOT NULL AND JSON_VALID(m11_d19) AND JSON_LENGTH(m11_d19) > 0 UNION ALL SELECT m11_d20 AS day_data, 'm11_d20' AS col_origin FROM worker_timesheet WHERE m11_d20 IS NOT NULL AND JSON_VALID(m11_d20) AND JSON_LENGTH(m11_d20) > 0 UNION ALL SELECT m11_d21 AS day_data, 'm11_d21' AS col_origin FROM worker_timesheet WHERE m11_d21 IS NOT NULL AND JSON_VALID(m11_d21) AND JSON_LENGTH(m11_d21) > 0 UNION ALL SELECT m11_d22 AS day_data, 'm11_d22' AS col_origin FROM worker_timesheet WHERE m11_d22 IS NOT NULL AND JSON_VALID(m11_d22) AND JSON_LENGTH(m11_d22) > 0 UNION ALL SELECT m11_d23 AS day_data, 'm11_d23' AS col_origin FROM worker_timesheet WHERE m11_d23 IS NOT NULL AND JSON_VALID(m11_d23) AND JSON_LENGTH(m11_d23) > 0 UNION ALL SELECT m11_d24 AS day_data, 'm11_d24' AS col_origin FROM worker_timesheet WHERE m11_d24 IS NOT NULL AND JSON_VALID(m11_d24) AND JSON_LENGTH(m11_d24) > 0 UNION ALL SELECT m11_d25 AS day_data, 'm11_d25' AS col_origin FROM worker_timesheet WHERE m11_d25 IS NOT NULL AND JSON_VALID(m11_d25) AND JSON_LENGTH(m11_d25) > 0 UNION ALL SELECT m11_d26 AS day_data, 'm11_d26' AS col_origin FROM worker_timesheet WHERE m11_d26 IS NOT NULL AND JSON_VALID(m11_d26) AND JSON_LENGTH(m11_d26) > 0 UNION ALL SELECT m11_d27 AS day_data, 'm11_d27' AS col_origin FROM worker_timesheet WHERE m11_d27 IS NOT NULL AND JSON_VALID(m11_d27) AND JSON_LENGTH(m11_d27) > 0 UNION ALL SELECT m11_d28 AS day_data, 'm11_d28' AS col_origin FROM worker_timesheet WHERE m11_d28 IS NOT NULL AND JSON_VALID(m11_d28) AND JSON_LENGTH(m11_d28) > 0 UNION ALL SELECT m11_d29 AS day_data, 'm11_d29' AS col_origin FROM worker_timesheet WHERE m11_d29 IS NOT NULL AND JSON_VALID(m11_d29) AND JSON_LENGTH(m11_d29) > 0 UNION ALL SELECT m11_d30 AS day_data, 'm11_d30' AS col_origin FROM worker_timesheet WHERE m11_d30 IS NOT NULL AND JSON_VALID(m11_d30) AND JSON_LENGTH(m11_d30) > 0 UNION ALL SELECT m11_d31 AS day_data, 'm11_d31' AS col_origin FROM worker_timesheet WHERE m11_d31 IS NOT NULL AND JSON_VALID(m11_d31) AND JSON_LENGTH(m11_d31) > 0 UNION ALL SELECT m12_d1 AS day_data, 'm12_d1' AS col_origin FROM worker_timesheet WHERE m12_d1 IS NOT NULL AND JSON_VALID(m12_d1) AND JSON_LENGTH(m12_d1) > 0 UNION ALL SELECT m12_d2 AS day_data, 'm12_d2' AS col_origin FROM worker_timesheet WHERE m12_d2 IS NOT NULL AND JSON_VALID(m12_d2) AND JSON_LENGTH(m12_d2) > 0 UNION ALL SELECT m12_d3 AS day_data, 'm12_d3' AS col_origin FROM worker_timesheet WHERE m12_d3 IS NOT NULL AND JSON_VALID(m12_d3) AND JSON_LENGTH(m12_d3) > 0 UNION ALL SELECT m12_d4 AS day_data, 'm12_d4' AS col_origin FROM worker_timesheet WHERE m12_d4 IS NOT NULL AND JSON_VALID(m12_d4) AND JSON_LENGTH(m12_d4) > 0 UNION ALL SELECT m12_d5 AS day_data, 'm12_d5' AS col_origin FROM worker_timesheet WHERE m12_d5 IS NOT NULL AND JSON_VALID(m12_d5) AND JSON_LENGTH(m12_d5) > 0 UNION ALL SELECT m12_d6 AS day_data, 'm12_d6' AS col_origin FROM worker_timesheet WHERE m12_d6 IS NOT NULL AND JSON_VALID(m12_d6) AND JSON_LENGTH(m12_d6) > 0 UNION ALL SELECT m12_d7 AS day_data, 'm12_d7' AS col_origin FROM worker_timesheet WHERE m12_d7 IS NOT NULL AND JSON_VALID(m12_d7) AND JSON_LENGTH(m12_d7) > 0 UNION ALL SELECT m12_d8 AS day_data, 'm12_d8' AS col_origin FROM worker_timesheet WHERE m12_d8 IS NOT NULL AND JSON_VALID(m12_d8) AND JSON_LENGTH(m12_d8) > 0 UNION ALL SELECT m12_d9 AS day_data, 'm12_d9' AS col_origin FROM worker_timesheet WHERE m12_d9 IS NOT NULL AND JSON_VALID(m12_d9) AND JSON_LENGTH(m12_d9) > 0 UNION ALL SELECT m12_d10 AS day_data, 'm12_d10' AS col_origin FROM worker_timesheet WHERE m12_d10 IS NOT NULL AND JSON_VALID(m12_d10) AND JSON_LENGTH(m12_d10) > 0 UNION ALL SELECT m12_d11 AS day_data, 'm12_d11' AS col_origin FROM worker_timesheet WHERE m12_d11 IS NOT NULL AND JSON_VALID(m12_d11) AND JSON_LENGTH(m12_d11) > 0 UNION ALL SELECT m12_d12 AS day_data, 'm12_d12' AS col_origin FROM worker_timesheet WHERE m12_d12 IS NOT NULL AND JSON_VALID(m12_d12) AND JSON_LENGTH(m12_d12) > 0 UNION ALL SELECT m12_d13 AS day_data, 'm12_d13' AS col_origin FROM worker_timesheet WHERE m12_d13 IS NOT NULL AND JSON_VALID(m12_d13) AND JSON_LENGTH(m12_d13) > 0 UNION ALL SELECT m12_d14 AS day_data, 'm12_d14' AS col_origin FROM worker_timesheet WHERE m12_d14 IS NOT NULL AND JSON_VALID(m12_d14) AND JSON_LENGTH(m12_d14) > 0 UNION ALL SELECT m12_d15 AS day_data, 'm12_d15' AS col_origin FROM worker_timesheet WHERE m12_d15 IS NOT NULL AND JSON_VALID(m12_d15) AND JSON_LENGTH(m12_d15) > 0 UNION ALL SELECT m12_d16 AS day_data, 'm12_d16' AS col_origin FROM worker_timesheet WHERE m12_d16 IS NOT NULL AND JSON_VALID(m12_d16) AND JSON_LENGTH(m12_d16) > 0 UNION ALL SELECT m12_d17 AS day_data, 'm12_d17' AS col_origin FROM worker_timesheet WHERE m12_d17 IS NOT NULL AND JSON_VALID(m12_d17) AND JSON_LENGTH(m12_d17) > 0 UNION ALL SELECT m12_d18 AS day_data, 'm12_d18' AS col_origin FROM worker_timesheet WHERE m12_d18 IS NOT NULL AND JSON_VALID(m12_d18) AND JSON_LENGTH(m12_d18) > 0 UNION ALL SELECT m12_d19 AS day_data, 'm12_d19' AS col_origin FROM worker_timesheet WHERE m12_d19 IS NOT NULL AND JSON_VALID(m12_d19) AND JSON_LENGTH(m12_d19) > 0 UNION ALL SELECT m12_d20 AS day_data, 'm12_d20' AS col_origin FROM worker_timesheet WHERE m12_d20 IS NOT NULL AND JSON_VALID(m12_d20) AND JSON_LENGTH(m12_d20) > 0 UNION ALL SELECT m12_d21 AS day_data, 'm12_d21' AS col_origin FROM worker_timesheet WHERE m12_d21 IS NOT NULL AND JSON_VALID(m12_d21) AND JSON_LENGTH(m12_d21) > 0 UNION ALL SELECT m12_d22 AS day_data, 'm12_d22' AS col_origin FROM worker_timesheet WHERE m12_d22 IS NOT NULL AND JSON_VALID(m12_d22) AND JSON_LENGTH(m12_d22) > 0 UNION ALL SELECT m12_d23 AS day_data, 'm12_d23' AS col_origin FROM worker_timesheet WHERE m12_d23 IS NOT NULL AND JSON_VALID(m12_d23) AND JSON_LENGTH(m12_d23) > 0 UNION ALL SELECT m12_d24 AS day_data, 'm12_d24' AS col_origin FROM worker_timesheet WHERE m12_d24 IS NOT NULL AND JSON_VALID(m12_d24) AND JSON_LENGTH(m12_d24) > 0 UNION ALL SELECT m12_d25 AS day_data, 'm12_d25' AS col_origin FROM worker_timesheet WHERE m12_d25 IS NOT NULL AND JSON_VALID(m12_d25) AND JSON_LENGTH(m12_d25) > 0 UNION ALL SELECT m12_d26 AS day_data, 'm12_d26' AS col_origin FROM worker_timesheet WHERE m12_d26 IS NOT NULL AND JSON_VALID(m12_d26) AND JSON_LENGTH(m12_d26) > 0 UNION ALL SELECT m12_d27 AS day_data, 'm12_d27' AS col_origin FROM worker_timesheet WHERE m12_d27 IS NOT NULL AND JSON_VALID(m12_d27) AND JSON_LENGTH(m12_d27) > 0 UNION ALL SELECT m12_d28 AS day_data, 'm12_d28' AS col_origin FROM worker_timesheet WHERE m12_d28 IS NOT NULL AND JSON_VALID(m12_d28) AND JSON_LENGTH(m12_d28) > 0 UNION ALL SELECT m12_d29 AS day_data, 'm12_d29' AS col_origin FROM worker_timesheet WHERE m12_d29 IS NOT NULL AND JSON_VALID(m12_d29) AND JSON_LENGTH(m12_d29) > 0 UNION ALL SELECT m12_d30 AS day_data, 'm12_d30' AS col_origin FROM worker_timesheet WHERE m12_d30 IS NOT NULL AND JSON_VALID(m12_d30) AND JSON_LENGTH(m12_d30) > 0 UNION ALL SELECT m12_d31 AS day_data, 'm12_d31' AS col_origin FROM worker_timesheet WHERE m12_d31 IS NOT NULL AND JSON_VALID(m12_d31) AND JSON_LENGTH(m12_d31) > 0
            ) AS temp_days
            INNER JOIN JSON_TABLE(temp_days.day_data, '$.projects[*]' COLUMNS (
                p_id INT PATH '$.project',
                cost_per_hour FLOAT PATH '$.final.cost_per_hour',
                roles_json JSON PATH '$.roles'
            )) AS jt_p ON 1 = 1
            INNER JOIN JSON_TABLE(jt_p.roles_json, '$[*]' COLUMNS (
                role_val INT PATH '$.role',
                orders_json JSON PATH '$.orders'
            )) AS jt_r ON 1 = 1
            WHERE jt_p.p_id = :project_id
        ) AS final_res
        WHERE role_val = min_role AND found_time IS NOT NULL