2022-06-01 14:59:09.805007
SELECT name, value FROM 0_sys_prefs

2022-06-01 14:59:11.853216
SELECT l.loc_code, l.location_name, l.inactive
                FROM 0_locations l 
                    LEFT JOIN 0_locations pl ON 
                            l.loc_code = pl.reservation_loc_code 
                WHERE pl.loc_code IS NULL ORDER BY l.location_name

2022-06-01 14:59:11.855487
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =196 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 14:59:11.860230
SELECT id, real_name, inactive  FROM 0_users ORDER BY real_name

2022-06-01 14:59:11.863136
SELECT COUNT(DISTINCT pr.pr_no) FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id  AND pr.created_on >= '2022-05-02' AND pr.created_on <= '2022-06-02')

2022-06-01 14:59:11.865082
SELECT 
                pr.pr_no, 
                pr.reference,  
                l.location_name location,
                p.description, 
                pr.pr_date,
                u.real_name originator_name,
                pr.created_on,
                pr.approval_status,
                pr.pr_complete 
	 FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id  AND pr.created_on >= '2022-05-02' AND pr.created_on <= '2022-06-02') GROUP BY pr.pr_no LIMIT 0, 10

2022-06-01 14:59:12.366804
SELECT l.loc_code, l.location_name, l.inactive
                FROM 0_locations l 
                    LEFT JOIN 0_locations pl ON 
                            l.loc_code = pl.reservation_loc_code 
                WHERE pl.loc_code IS NULL ORDER BY l.location_name

2022-06-01 14:59:12.373080
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =196 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 14:59:12.375060
SELECT id, real_name, inactive  FROM 0_users ORDER BY real_name

2022-06-01 14:59:12.378020
SELECT COUNT(DISTINCT pr.pr_no) FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id  AND pr.created_on >= '2022-05-02' AND pr.created_on <= '2022-06-02')

2022-06-01 14:59:12.380005
SELECT 
                pr.pr_no, 
                pr.reference,  
                l.location_name location,
                p.description, 
                pr.pr_date,
                u.real_name originator_name,
                pr.created_on,
                pr.approval_status,
                pr.pr_complete 
	 FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id  AND pr.created_on >= '2022-05-02' AND pr.created_on <= '2022-06-02') GROUP BY pr.pr_no LIMIT 0, 10

2022-06-01 14:59:17.558683
SELECT l.loc_code, l.location_name, l.inactive
                FROM 0_locations l 
                    LEFT JOIN 0_locations pl ON 
                            l.loc_code = pl.reservation_loc_code 
                WHERE pl.loc_code IS NULL ORDER BY l.location_name

2022-06-01 14:59:17.561145
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =196 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 14:59:17.562889
SELECT id, real_name, inactive  FROM 0_users ORDER BY real_name

2022-06-01 14:59:17.565810
SELECT COUNT(DISTINCT pr.pr_no) FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id AND pr.pr_no = '593')

2022-06-01 14:59:17.567263
SELECT 
                pr.pr_no, 
                pr.reference,  
                l.location_name location,
                p.description, 
                pr.pr_date,
                u.real_name originator_name,
                pr.created_on,
                pr.approval_status,
                pr.pr_complete 
	 FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id AND pr.pr_no = '593') GROUP BY pr.pr_no LIMIT 0, 10

2022-06-01 14:59:42.646958
SELECT l.loc_code, l.location_name, l.inactive
                FROM 0_locations l 
                    LEFT JOIN 0_locations pl ON 
                            l.loc_code = pl.reservation_loc_code 
                WHERE pl.loc_code IS NULL ORDER BY l.location_name

2022-06-01 14:59:42.655775
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =196 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 14:59:42.662549
SELECT id, real_name, inactive  FROM 0_users ORDER BY real_name

2022-06-01 14:59:42.670974
SELECT COUNT(DISTINCT pr.pr_no) FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id AND pr.pr_no = '577')

2022-06-01 14:59:42.678645
SELECT 
                pr.pr_no, 
                pr.reference,  
                l.location_name location,
                p.description, 
                pr.pr_date,
                u.real_name originator_name,
                pr.created_on,
                pr.approval_status,
                pr.pr_complete 
	 FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id AND pr.pr_no = '577') GROUP BY pr.pr_no LIMIT 0, 10

2022-06-01 14:59:47.426471
SELECT l.loc_code, l.location_name, l.inactive
                FROM 0_locations l 
                    LEFT JOIN 0_locations pl ON 
                            l.loc_code = pl.reservation_loc_code 
                WHERE pl.loc_code IS NULL ORDER BY l.location_name

2022-06-01 14:59:47.428916
SELECT project_id, project_code, value_name, description, project_name  
            FROM 0_projects_master pm 
                    INNER JOIN 0_user_data_access_groups udag ON
                            pm.dag_id = udag.dag_id  
                    LEFT JOIN 0_list_values lv ON 
                            pm.department_id = lv.id 
            WHERE pm.inactive = 0 AND udag.user_id =196 AND (pm.project_id='') ORDER BY value_name,pm.description

2022-06-01 14:59:47.430527
SELECT id, real_name, inactive  FROM 0_users ORDER BY real_name

2022-06-01 14:59:47.433929
SELECT COUNT(DISTINCT pr.pr_no) FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id AND pr.pr_no = '601')

2022-06-01 14:59:47.435731
SELECT 
                pr.pr_no, 
                pr.reference,  
                l.location_name location,
                p.description, 
                pr.pr_date,
                u.real_name originator_name,
                pr.created_on,
                pr.approval_status,
                pr.pr_complete 
	 FROM 0_purchase_requisitions as pr, 
                0_projects_master as p, 
                0_locations l,
                0_users as u
	  WHERE (pr.project_id = p.project_id AND 
                l.loc_code = pr.location AND 
                pr.created_by = u.id AND pr.pr_no = '601') GROUP BY pr.pr_no LIMIT 0, 10

