Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `inventory_transfer`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ID ITRNO ITRDATE FROMACCOUNTABLEID FROMACCOUNTABLE TOACCOUNTABLEID TOACCOUNTABLE ENTITYNAME FUNDCLUSTERID FUNDCLUSTER TRANSFERTYPE OTHERS REASON APPROVEDID APPROVED APPROVEDPOS APPROVEDDATE RELEASEDID RELEASED RELEASEDPOS RELEASEDDATE RECEIVEDID RECEIVED RECEIVEDPOS RECEIVEDDATE USERID STATUS TS trans_type
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 1 AND `inventory_transfer`.`RECEIVEDPOS` = 'SOCIAL WELFARE OFFICER III'
1 ITR-07-0001-2023 2023-07-28 0 JESEPA T. BUCOG 1429 KATHRYN APRIL O. BRIONES 1 General Fund Others (Specify) : resignation Resignation of Accountable Officer. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2023-07-28 1058 JESLYNE O. CANON GSO-PROPERTY SECTION STAFF 2023-07-28 1429 KATHRYN APRIL O. BRIONES SOCIAL WELFARE OFFICER III 2023-07-28 263 Cancelled 2023-07-28 16:12:10 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 2 AND `inventory_transfer`.`RECEIVEDPOS` = 'HRMO II'
2 ITR-04-0001-2023 2023-04-18 0 ROWENA R. ARNOZA 0 JOEL N. ANDALES 1 General Fund Relocate for the use of training center in South Pob. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2023-04-18 1058 JESLYNE O. CANON GSO-PROPERTY SECTION STAFF 2023-04-18 0 JOEL N. ANDALES HRMO II 2023-04-18 263 Active 2023-08-28 17:03:12 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 3 AND `inventory_transfer`.`RECEIVEDPOS` = 'HRMO II'
3 ITR-04-0002-2023 2023-04-18 0 KIN JOSEPH B. BACON 0 JOEL N. ANDALES 0 Relocate For the use of training center at South Pob. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2023-08-30 1058 JESLYNE O. CANON GSO-PROPERTY SECTION STAFF 2023-08-30 0 JOEL N. ANDALES HRMO II 2023-08-30 263 Active 2023-08-30 12:02:34 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 4 AND `inventory_transfer`.`RECEIVEDPOS` = 'DIVISION SUPPLY OFFICER'
4 ITR-09-0003-2023 2023-09-11 0 LGU - CITY OF NAGA 0 MARIO A. BAYA / CITY DIVISION DEP-ED / SEF 2 Special Education Fund Others (Specify) : TRANSFERRED For City of Naga Schools Division (AC # 1-07-07-02... 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2023-09-11 0 ALEXANDER D. MOZO SENIOR ADMINISTRATIVE ASSISTANT I 2023-09-11 0 MARIO A. BAYA DIVISION SUPPLY OFFICER 2023-09-11 263 Active 2023-09-11 11:15:27 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 5 AND `inventory_transfer`.`RECEIVEDPOS` = 'CITY DIVISIONS SCHOOLS SUPERINTENDENT'
5 ITR-09-0004-2023 2023-09-12 0 LGU - CITY OF NAGA 0 DR. RONALD G. GUTAY / CITY DIVISION DEP-ED / SEF 2 Special Education Fund Others (Specify) : Transferred For Purchase of Instructional Equipment (Robotics)... 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2023-09-12 0 ALEXANDER D. MOZO DRAFTSMAN I 2023-09-12 0 DR. RONALD G. GUTAY CITY DIVISIONS SCHOOLS SUPERINTENDENT 2023-09-12 263 Active 2023-09-12 14:50:29 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 6 AND `inventory_transfer`.`RECEIVEDPOS` = 'ENVIRONMENTAL MANAGEMENT SPECIALIST II'
6 ITR-09-0005-2023 2023-09-19 0 ARLY B. BARON 0 JAMES VINCENT G. GENERALE 0 Others (Specify) : Resignation Resignation of Accountable Person. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2023-09-19 0 HEIDI S. LIM ADMIN. AIDE I 2023-09-19 0 JAMES VINCENT G. GENERALE ENVIRONMENTAL MANAGEMENT SPECIALIST II 2023-09-19 263 Active 2023-09-19 15:02:07 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 7 AND `inventory_transfer`.`RECEIVEDPOS` = 'ADMINISTRATIVE AIDE I (UTILITY WORKER I)'
7 ITR-09-0006-2023 2023-09-26 0 VILMA  C. NAVALES 259 MARIA VICTORIA S. LOBRINO 0 Others (Specify) : Retirement For Retirement 0 GINEVEVE V. LAPUT GSO - DESIGNATE NULL 1058 JESLYNE O. CANON GSO PROPERTY STAFF NULL 259 MARIA VICTORIA S. LOBRINO ADMINISTRATIVE AIDE I (UTILITY WORKER I) NULL 263 Active 2023-10-06 14:21:51 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 8 AND `inventory_transfer`.`RECEIVEDPOS` = 'ADMIN. AIDE I ( CASUAL )'
8 ITR-09-0005-2023 2023-09-26 0 VILMA C. NAVALES 0 MADELINE P. GALEOS 0 Others (Specify) : Retirement For Retirement 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2023-10-07 1058 JESLYNE O. CANON GSO PROPERTY STAFF 2023-10-07 0 MADELINE P. GALEOS ADMIN. AIDE I ( CASUAL ) 2023-10-07 263 Active 2023-10-07 16:16:04 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 9 AND `inventory_transfer`.`RECEIVEDPOS` = ''
9 ITR-10-0001-2023 2023-10-25 0 0 2 Special Education Fund Others (Specify) : TRANSFERRED For City of Naga Schools Division (Capital Outlay ... 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2023-10-25 0 HEIDI S. LIM ADMIN. AIDE I (CASUAL) 2023-10-25 0 2023-10-25 263 Active 2023-10-25 14:53:06 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 10 AND `inventory_transfer`.`RECEIVEDPOS` = 'DIVISION SUPPLY OFFICER'
10 ITR-04-0003-2024 2024-04-15 0 HON. VALDEMAR M. CHIONG / CITY OF NAGA GOVERNMENT 0 DR. RONALD G. GUTAY / CITY OF NAGA DIVISION (DEP-E... 2 Special Education Fund Others (Specify) : TRANSFER For the Distribution of Teachers. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-04-15 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-04-15 0 MARIO A. BAYA DIVISION SUPPLY OFFICER 2024-04-15 263 Active 2024-04-15 14:20:19 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 11 AND `inventory_transfer`.`RECEIVEDPOS` = 'CITY DIVISIONS SCHOOLS SUPERINTENDENT'
11 ITR-05-0001-2024 2024-05-29 0 CITY OF NAGA GOVERNMENT 0 CITY OF NAGA DIVISION - DEP ED 2 Special Education Fund Others (Specify) : TRANSFER For Transfer of Learning Set/kit and Equipment for... 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-05-29 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-05-29 0 DR. RONALD G. GUTAY CITY DIVISIONS SCHOOLS SUPERINTENDENT 2024-05-29 263 Active 2024-05-29 10:43:54 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 12 AND `inventory_transfer`.`RECEIVEDPOS` = 'CITY DIVISIONS SCHOOLS SUPERINTENDENT'
12 PTR-06-0001-2024 2024-06-18 0 sampl 0 0 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-06-18 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-06-18 0 DR. RONALD G. GUTAY CITY DIVISIONS SCHOOLS SUPERINTENDENT 2024-06-18 1 Active 2024-06-18 11:07:16 PTR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 13 AND `inventory_transfer`.`RECEIVEDPOS` = 'BRGY. CAPTAIN - LUTAC'
13 ITR-07-0002-2024 2024-07-25 0 KIN JOSEPH B. BACON 0 JUANITA GESMAN 1 General Fund Others (Specify) : Transfer Transfer to Barangay Lutac. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-07-25 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-07-25 0 JUANITA GESMAN BRGY. CAPTAIN - LUTAC 2024-07-25 263 Active 2024-07-25 16:27:10 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 14 AND `inventory_transfer`.`RECEIVEDPOS` = 'BRGY. CAPTAIN - CABUNGAHAN'
14 ITR-07-0003-2024 2024-07-25 0 KIN JOSEPH B. BACON 0 ELMER PAÑOSO 1 General Fund Others (Specify) : TRANSFER TRANSFER TO BARANGAY CABUNGAHAN. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-07-25 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-07-25 0 ELMER PAÑOSO BRGY. CAPTAIN - CABUNGAHAN 2024-07-25 263 Active 2024-07-25 17:07:10 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 15 AND `inventory_transfer`.`RECEIVEDPOS` = 'BARANGAY CAPTAIN ( BAIRAN )'
15 ITR-07-0004-2024 2024-07-25 0 KIN JOSEPH B. BACON 0 REYNALDO B. ESPINOSA 1 General Fund Others (Specify) : Transfer Transfer to Barangay Bairan. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-07-25 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-07-25 0 REYNALDO B. ESPINOSA BARANGAY CAPTAIN ( BAIRAN ) 2024-07-25 263 Active 2024-07-25 17:11:10 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 16 AND `inventory_transfer`.`RECEIVEDPOS` = 'BRGY. CAPTAIN - ALPACO'
16 ITR-07-0005-2024 2024-07-25 0 KIN JOSEPH B. BACON 0 ROGELIO C. ABABA 1 General Fund Others (Specify) : Transfer Transfer to Barangay Alpaco. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-07-25 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-07-25 0 ROGELIO C. ABABA BRGY. CAPTAIN - ALPACO 2024-07-25 263 Active 2024-07-25 17:14:00 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 17 AND `inventory_transfer`.`RECEIVEDPOS` = 'BARANGAY CAPTAIN ( INOBURAN )'
17 ITR-07-0006-2024 2024-07-31 0 LGU - CITY OF NAGA 0 REDGIE CABIZAREZ / BRGY. INOBURAN 1 General Fund Others (Specify) : TRANSFER Transfer to Barangay Inoburan. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-07-31 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-07-31 0 REDGIE A. CABISAREZ BARANGAY CAPTAIN ( INOBURAN ) 2024-07-31 263 Active 2024-07-31 15:05:52 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 18 AND `inventory_transfer`.`RECEIVEDPOS` = 'BARANGAY CAPTAIN ( INOBURAN )'
18 ITR-07-0007-2024 2024-07-31 0 LGU - CITY OF NAGA 0 REDGIE CABIZAREZ / BRGY. INOBURAN 1 General Fund Others (Specify) : TRANSFER Transfer to Brgy. Inoburan. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-07-31 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-07-31 0 REDGIE A. CABISAREZ BARANGAY CAPTAIN ( INOBURAN ) 2024-07-31 263 Active 2024-07-31 15:14:09 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 19 AND `inventory_transfer`.`RECEIVEDPOS` = 'BARANGAY CAPTAIN ( INOBURAN )'
19 PTR-08-0001-2024 2024-08-20 363 EDDIE V. NACUA 1246 SALDE C. PARADERO Naga 0 Ressignment 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-08-20 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-08-20 0 REDGIE A. CABISAREZ BARANGAY CAPTAIN ( INOBURAN ) 2024-08-20 1 Active 2024-08-20 14:47:30 PTR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 20 AND `inventory_transfer`.`RECEIVEDPOS` = 'DIVISION SPORTS COORDINATOR'
20 ITR-11-0001-2024 2024-11-05 0 CITY OF NAGA GOVERNMENT 0 CITY OF NAGA DIVISION - DEP-ED 2 Special Education Fund Others (Specify) : TRANSFER for the use of taekwondo. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-11-05 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-11-05 0 NANETTE G. REPUNTE DIVISION SPORTS COORDINATOR 2024-11-05 263 Active 2024-11-05 10:36:06 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 21 AND `inventory_transfer`.`RECEIVEDPOS` = 'DIVISION SUPPLY OFFICER'
21 ITR-11-0002-2024 2024-11-08 0 HON. VALDEMAR M. CHIONG / CITY GOVERNMENT OF NAGA 0 MARIO A. BAYA / CITY OF NAGA DIVISION 1 General Fund Others (Specify) : Transfer For the Distribution of Printed Notebooks to vario... 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-11-11 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-11-11 0 MARIO A. BAYA DIVISION SUPPLY OFFICER 2024-11-11 263 Active 2024-11-11 13:26:01 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 22 AND `inventory_transfer`.`RECEIVEDPOS` = 'DIVISION SUPPLY OFFICER'
22 ITR-10-0002-2023 2023-10-27 0 CITY GOVERNMENT OF NAGA 0 CITY OF NAGA DIVISION 2 Special Education Fund Others (Specify) : TRANSFER 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-11-11 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-11-11 0 MARIO A. BAYA DIVISION SUPPLY OFFICER 2024-11-11 263 Active 2024-11-11 15:47:07 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 23 AND `inventory_transfer`.`RECEIVEDPOS` = 'SP MEMBER'
23 ITR-11-0006-2024 NULL 0 CITY GOVERNMENT OF NAGA 0 VARIOUS BARANGAYS 1 General Fund Others (Specify) : Transfer Transfer to Various Barangays. 0 GINEVEVE V. LAPUT GSO - DESIGNATE NULL 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF NULL 0 HON. CARMELINO N. CRUZ JR. SP  MEMBER NULL 263 Active 2024-11-18 11:33:03 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 24 AND `inventory_transfer`.`RECEIVEDPOS` = 'BARANGAY CAPTAIN ( SOUTH POBLACION )'
24 ITR-11-0004-2024 2024-11-20 0 CITY GOVERNMENT OF NAGA 0 NATHANIEL V. MONTEBON /BARANGAY SOUTH POBLACION 1 General Fund Others (Specify) : Transfer Transfer for the use of Barangay South Poblacion. 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-11-20 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-11-20 0 NATHANIEL V. MONTEBON BARANGAY CAPTAIN ( SOUTH POBLACION ) 2024-11-20 263 Cancelled 2024-11-20 08:48:49 ITR
Edit Edit Copy Copy Delete Delete
DELETE FROM inventory_transfer WHERE `inventory_transfer`.`ID` = 25 AND `inventory_transfer`.`RECEIVEDPOS` = 'BARANGAY CAPTAIN ( SOUTH POBLACION )'
25 ITR-11-0004-2024 2024-11-21 0 LGU - CITY OF NAGA 0 NATHANIEL V. MONTEBON 1 General Fund Others (Specify) : Transfer Transfer to Barangay South Poblacion 0 GINEVEVE V. LAPUT GSO - DESIGNATE 2024-11-21 1058 JESLYNE O. CANON GSO PROPERTY SECTION STAFF 2024-11-21 0 NATHANIEL V. MONTEBON BARANGAY CAPTAIN ( SOUTH POBLACION ) 2024-11-21 263 Active 2024-11-21 10:20:55 ITR
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view