2024-07-29 16:00:43.466883
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

2024-07-29 16:00:43.678052
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 =170 AND (pm.project_id='') ORDER BY value_name,pm.description

2024-07-29 16:00:43.691039
SELECT id, real_name, inactive  FROM 0_users ORDER BY real_name

2024-07-29 16:00:43.695508
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 >= '2024-06-29' AND pr.created_on <= '2024-07-30')

2024-07-29 16:00:43.698218
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 >= '2024-06-29' AND pr.created_on <= '2024-07-30') GROUP BY pr.pr_no LIMIT 0, 10

2024-07-29 16:00:48.430218
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

2024-07-29 16:00:48.449585
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 =170 AND (pm.project_id='') ORDER BY value_name,pm.description

2024-07-29 16:00:48.452313
SELECT id, real_name, inactive  FROM 0_users ORDER BY real_name

2024-07-29 16:00:48.455530
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 >= '2024-06-29' AND pr.created_on <= '2024-07-30') GROUP BY pr.pr_no LIMIT 20, 10

