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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark 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 `unit_action_incoming`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id denrtransactionno denrname denrsender denraddress denrdaterecv denrformtime denrsubject denrdocumentsource denrdoctype denrdocumentstatus denrdatetransmitted denrofficeorigin outgoing_frontdesk_timerecv outgoing_frontdesk_daterecv return_penro_processor return_penro_workgroup return_penro_purpose return_penro_date return_penro_time outgoing_penro_timerecv outgoing_penro_daterecv outgoing_penro_processor outgoing_penro_workgroup outgoing_penro_action outgoing_penro_date outgoing_penro_time penrorecvtime penrorecvdate penropriority penroprocessor penrodateprocessed penrotime penroaction penroactionother penrodepartment deptrecvtime deptrecvdate deptprocessor deptdateprocessed depttime deptpriority deptaction deptactionother deptworkgroup deptto return_dept_processor return_dept_workgroup return_dept_purpose return_dept_date return_dept_time outgoing_dept_timerecv outgoing_dept_daterecv outgoing_dept_processor outgoing_dept_workgroup outgoing_dept_action outgoing_dept_date outgoing_dept_time unitrecvtime unitrecvdate unitprocessor unitworkgroup unitdateprocessed unittime unitaction unitto
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 222
222 2024-14280 DANEKA NATULLA REGION TACLOBAN CITY 2024-11-28 02:47 PM REQUESTING FOR ASSISTANCE REGARDING YOUR CONCERN O... EMAIL LETTER Forwarded From TSD 2024-11-28 REGION 09:23 AM 2024-11-29 3 Kevin Memoracion 2024-11-29 09:50 AM For Appropriate Action TSD 10:10 AM 2024-11-29 Kevin Memoracion 2024-11-29 10:13 AM 3 For information and record, Others for monitoring. RPS EVANGELINE LOPEZ 11:26 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 223
223 2024-14253 DANEKA NATULLA CENRO BAYBAY BAYBAY CITY 2024-11-26 01:17 PM FINAL INVESTIGATION REPORT ON THE CLAIM OF GENIE P... WALK IN MEMORANDUM Forwarded From TSD 2024-11-26 CENRO BAYBAY 05:49 PM 2024-11-26 3 Kevin Memoracion 2024-11-27 01:56 PM For Appropriate Action TSD 01:57 PM 2024-11-27 Kevin Memoracion 2024-11-28 10:08 AM 2 For Appropriate Action, For review and evaluation,... For endorsement to RO for legal disposition if fou... RPS EVANGELINE LOPEZ 11:26 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 226
226 2024-14210 DANEKA NATULLA CENRO ORMOC ORMOC CITY 2024-11-25 09:05 AM RE: ANCESTRAL DOMAIN OF MARIKUDO DATU GARA LOCATED... WALK IN MEMORANDUM Forwarded From TSD 2024-11-25 CENRO ORMOC 05:50 PM 2024-11-26 3 Kevin Memoracion 2024-11-27 12:02 PM For Appropriate Action TSD 01:58 PM 2024-11-27 Kevin Memoracion 2024-11-28 09:39 AM 3 For endorsement preparation to RO, For information... RPS EVANGELINE LOPEZ 11:30 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 241
241 2024-14164 DANEKA NATULLA CENRO PALO PALO LEYTE 2024-11-21 03:47 PM PENRO LAND CASE NO. 1035 FINAL INVESTIGATION REPOR... WALK IN MEMORANDUM Forwarded From TSD 2024-11-21 CENRO PALO 05:51 PM 2024-11-26 3 Kevin Memoracion 2024-11-27 11:58 AM For Appropriate Action TSD 01:59 PM 2024-11-27 Kevin Memoracion 2024-11-28 09:24 AM 3 For review and evaluation, For endorsement prepara... RPS EVANGELINE LOPEZ 11:46 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 242
242 2024-14161 DANEKA NATULLA REGION TACLOBAN CITY 2024-11-21 01:26 PM REQUEST FR AUTHORITY TO DISPOSE THE TURNED-OVER LO... WALK IN MEMORANDUM Forwarded From TSD 2024-11-21 REGION 05:51 PM 2024-11-26 3 Kevin Memoracion 2024-11-27 11:58 AM For Appropriate Action TSD 01:59 PM 2024-11-27 Kevin Memoracion 2024-11-28 09:23 AM 3 For endorsement preparation to CENRO Ormoc, Others Let us discuss this with ARDTS if we can have one-... RPS EVANGELINE LOPEZ 11:46 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 245
245 2024-14108 DANEKA NATULLA MUNICIPAL TRIAL COURT 8TH JUDICIAL REGION HILONGOS LEYTE 2024-11-19 01:57 PM SPS. WILFREDO B. LABIDEZ AND TERESITA F. LABIDEZ (... MAIL NOTICE Forwarded From TSD 2024-11-19 MUNICIPAL TRIAL COURT 8TH JUDICIAL REGION 10:29 AM 2024-11-27 3 Kevin Memoracion 2024-11-27 11:17 AM For Appropriate Action TSD 02:02 PM 2024-11-27 Kevin Memoracion 2024-11-27 04:38 PM 3 For review and evaluation, For endorsement prepara... Please coordinate with L. Basilio on the records o... RPS EVANGELINE LOPEZ 11:53 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 247
247 2024-14025 DANEKA NATULLA CENRO PALO PALO LEYTE 2024-11-12 10:09 AM REQUEST FOR ISSUANCE OF ORDER OF INVESTIGATION: MI... WALK IN MEMORANDUM Forwarded From TSD 2024-11-12 CENRO PALO 03:05 PM 2024-11-12 1 Kevin Memoracion 2024-11-12 03:30 PM For Appropriate Action TSD 03:49 PM 2024-11-12 Kevin Memoracion 2024-11-12 03:50 PM 1 For review and evaluation, For comment(s)/recommen... Please act on this with dispatch if found complete... RPS EVANGELINE LOPEZ 11:57 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 248
248 2024-14018 DANEKA NATULLA CENRO BAYBAY BAYBAY CITY 2024-11-11 01:39 PM GRATUITOUS SPECIAL USE PERMIT (GSUP) APPLICATION O... WALK IN MEMORANDUM Forwarded From TSD 2024-11-11 CENRO BAYBAY 09:57 AM 2024-11-12 3 Kevin Memoracion 2024-11-12 10:16 AM For Appropriate Action TSD 10:17 AM 2024-11-12 Kevin Memoracion 2024-11-12 10:21 AM 3 For review and evaluation, For endorsement prepara... Please attach PENRO Checlklist of Requirements. Pl... RPS EVANGELINE LOPEZ 11:58 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 250
250 2024-13973 DANEKA NATULLA REGION TACLOBAN CITY 2024-11-05 11:19 AM FOLLOW-UP ON THE STATUS OF COMPLIANCE WITH THE REQ... EMAIL MEMORANDUM Forwarded From TSD 2024-11-05 REGION 02:23 PM 2024-11-05 1 Kevin Memoracion 2024-11-05 02:26 PM For Appropriate Action TSD 02:28 PM 2024-11-05 Kevin Memoracion 2024-11-05 02:33 PM 3 Others Let us comply based on available maps in shapefile... RPS EVANGELINE LOPEZ 11:59 AM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 251
251 2024-13963 DANEKA NATULLA REGION TACLOBAN CITY 2024-11-05 08:55 AM COMPLIANCE ON THE PRESCRIBED FORMSFORMAT ON THE AP... EMAIL MEMORANDUM Forwarded From TSD 2024-11-05 REGION 09:41 AM 2024-11-05 3 Kevin Memoracion 2024-11-05 02:22 PM For Appropriate Action TSD 02:28 PM 2024-11-05 Kevin Memoracion 2024-11-05 02:29 PM 3 For endorsement preparation to CENRO Baybay, For e... Please coordinate with M. Macalalag on the require... RPS EVANGELINE LOPEZ 12:00 PM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 252
252 2024-13938 DANEKA NATULLA CENRO BAYBAY BAYBAY CITY 2024-10-30 03:17 PM COMPLETED STAFF WORK (CSW) ON THE OFFICE-INITIATED... WALK IN MEMORANDUM Forwarded From TSD 2024-10-30 CENRO BAYBAY 02:10 PM 2024-11-04 3 Kevin Memoracion 2024-11-04 02:13 PM For Appropriate Action TSD 02:18 PM 2024-11-04 Kevin Memoracion 2024-11-04 02:24 PM 3 For review and evaluation, For comment(s)/recommen... Let us concur to CENROs recommendation to refer th... RPS EVANGELINE LOPEZ 12:00 PM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 253
253 2024-13916 DANEKA NATULLA CENRO PALO PALO, LEYTE 2024-10-30 08:15 AM INVESTIGATION REPORT RE: CORRECTION OF SURVEY CLAI... WALK IN MEMORANDUM Forwarded From TSD 2024-10-30 CENRO PALO 10:32 AM 2024-10-30 2 Kevin Memoracion 2024-10-30 10:39 AM For Appropriate Action TSD 10:53 AM 2024-10-30 Kevin Memoracion 2024-10-30 11:02 AM 2 For Appropriate Action, For review and evaluation,... RPS EVANGELINE LOPEZ 12:01 PM 2024-11-29
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 261
261 2024-14290 DANEKA NATULLA JVM BOLLARD CONTRUCTION AND SUPPLY TACLOBAN CITY 2024-12-02 10:34 AM LETTER OF INTENT (LOI) WALK IN LETTER Forwarded From TSD 2024-12-02 JVM BOLLARD CONTRUCTION AND SUPPLY 02:27 PM 2024-12-02 3 Kevin Memoracion 2024-12-02 02:30 PM For Appropriate Action TSD 02:44 PM 2024-12-02 Kevin Memoracion 2024-12-02 02:44 PM 3 For Appropriate Action RPS EVANGELINE LOPEZ 08:55 AM 2024-12-03
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 262
262 2024-14294 DANEKA NATULLA CENRO PALO PALO, LEYTE 2024-12-02 11:34 AM FPA 083747-335 OF JEROME D. VILLEZA, LOT NO. 4673,... WALK IN MEMORANDUM Forwarded From TSD 2024-12-02 CENRO PALO 02:27 PM 2024-12-02 3 Kevin Memoracion 2024-12-02 02:58 PM For Appropriate Action TSD 02:58 PM 2024-12-02 Kevin Memoracion 2024-12-02 04:12 PM 2 For Appropriate Action, For review and evaluation,... Please check if the HP refers to the 16 has sold. ... RPS EVANGELINE LOPEZ 08:55 AM 2024-12-03
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 263
263 2024-14298 DANEKA NATULLA FFJJ CONSTRUCTION COTABATO CITY 2024-12-02 12:07 PM LETTER OF INTENT: CONTRUCTION OF A SPRING BOX AND ... WALK IN LETTER Forwarded From TSD 2024-12-02 FFJJ CONSTRUCTION 02:26 PM 2024-12-02 3 Kevin Memoracion 2024-12-02 02:33 PM For Appropriate Action TSD 02:43 PM 2024-12-02 Kevin Memoracion 2024-12-02 02:44 PM 3 For Appropriate Action RPS EVANGELINE LOPEZ 08:55 AM 2024-12-03
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 264
264 2024-14297 DANEKA NATULLA R&B CONSTRUCTION MACARTHUR LEYTE 2024-12-02 12:02 PM LETTER OF INTENT: FOR SPRING DEVELOPMENT PROJECT: ... WALK IN LETTER Forwarded From TSD 2024-12-02 R&B CONSTRUCTION 02:26 PM 2024-12-02 3 Kevin Memoracion 2024-12-02 02:31 PM For Appropriate Action TSD 02:43 PM 2024-12-02 Kevin Memoracion 2024-12-02 02:44 PM 3 For Appropriate Action RPS EVANGELINE LOPEZ 08:55 AM 2024-12-03
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 265
265 2024-14295 DANEKA NATULLA KAMARI CONSTRUCTION AND SUPPLY JARO, LEYTE 2024-12-02 11:41 AM REPONSE TO THE INVITATION TO APPLY FOR ELIGIBILITY... WALK IN LETTER Forwarded From TSD 2024-12-02 KAMARI CONSTRUCTION AND SUPPLY 02:27 PM 2024-12-02 3 Kevin Memoracion 2024-12-02 02:30 PM For Appropriate Action TSD 02:43 PM 2024-12-02 Kevin Memoracion 2024-12-02 02:44 PM 3 For Appropriate Action RPS EVANGELINE LOPEZ 08:56 AM 2024-12-03
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 296
296 2024-14379 DANEKA NATULLA CENRO PALO PALO, LEYTE 2024-12-06 04:01 PM RE: ORDER TO CONDUCT INVESTIGATION, OCULAR INSPECT... WALK IN MEMORANDUM Forwarded From TSD 2024-12-06 CENRO PALO 08:16 AM 2024-12-10 3 Kevin Memoracion 2024-12-10 10:16 AM For Appropriate Action TSD 10:18 AM 2024-12-10 Kevin Memoracion 2024-12-10 10:53 AM 3 For Appropriate Action, For review and evaluation,... Please assign this to another SLI aho has been clo... RPS EVANGELINE LOPEZ 03:30 PM 2024-12-10
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 298
298 2024-14371 DANEKA NATULLA CENRO ORMOC ORMOC CITY 2024-12-06 03:41 PM RE; A PARCEL OF LAND DESIGNATED AS LOT NO. 6144-PA... WALK IN MEMORANDUM Forwarded From TSD 2024-12-06 CENRO ORMOC 08:17 AM 2024-12-10 3 Kevin Memoracion 2024-12-10 10:16 AM For Appropriate Action TSD 10:18 AM 2024-12-10 Kevin Memoracion 2024-12-10 10:26 AM 3 For information and record RPS EVANGELINE LOPEZ 03:31 PM 2024-12-10
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 299
299 2024-14370 DANEKA NATULLA CENRO BAYBAY BAYBAY CITY 2024-12-06 03:38 PM REQUEST FOR ORDER OF INVESSTIGATION: SANCHO M. ISR... WALK IN MEMORANDUM Forwarded From TSD 2024-12-06 CENRO BAYABY 08:17 AM 2024-12-10 3 Kevin Memoracion 2024-12-10 10:16 AM For Appropriate Action TSD 10:17 AM 2024-12-10 Kevin Memoracion 2024-12-10 10:55 AM 3 For review and evaluation, For endorsement prepara... For issuance of Order of Investigation if found co... RPS EVANGELINE LOPEZ 03:32 PM 2024-12-10
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 300
300 2024-14370 DANEKA NATULLA CENRO BAYBAY BAYBAY CITY 2024-12-06 03:38 PM REQUEST FOR ORDER OF INVESSTIGATION: SANCHO M. ISR... WALK IN MEMORANDUM Forwarded From TSD 2024-12-06 CENRO BAYABY 08:17 AM 2024-12-10 3 Kevin Memoracion 2024-12-10 10:16 AM For Appropriate Action TSD 10:17 AM 2024-12-10 Kevin Memoracion 2024-12-10 10:55 AM 3 For review and evaluation, For endorsement prepara... For issuance of Order of Investigation if found co... RPS EVANGELINE LOPEZ 03:32 PM 2024-12-10
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 301
301 2024-14370 DANEKA NATULLA CENRO BAYBAY BAYBAY CITY 2024-12-06 03:38 PM REQUEST FOR ORDER OF INVESSTIGATION: SANCHO M. ISR... WALK IN MEMORANDUM Forwarded From TSD 2024-12-06 CENRO BAYABY 08:17 AM 2024-12-10 3 Kevin Memoracion 2024-12-10 10:16 AM For Appropriate Action TSD 10:17 AM 2024-12-10 Kevin Memoracion 2024-12-10 10:55 AM 3 For review and evaluation, For endorsement prepara... For issuance of Order of Investigation if found co... RPS EVANGELINE LOPEZ 03:32 PM 2024-12-10
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 302
302 2024-14370 DANEKA NATULLA CENRO BAYBAY BAYBAY CITY 2024-12-06 03:38 PM REQUEST FOR ORDER OF INVESSTIGATION: SANCHO M. ISR... WALK IN MEMORANDUM Forwarded From TSD 2024-12-06 CENRO BAYABY 08:17 AM 2024-12-10 3 Kevin Memoracion 2024-12-10 10:16 AM For Appropriate Action TSD 10:17 AM 2024-12-10 Kevin Memoracion 2024-12-10 10:55 AM 3 For review and evaluation, For endorsement prepara... For issuance of Order of Investigation if found co... RPS EVANGELINE LOPEZ 03:32 PM 2024-12-10
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 353
353 2024-14448 DANEKA NATULLA CENRO ORMOC ORMOC CITY 2024-12-13 04:53 PM ALTERNATIVE DISPUTE RESOLUTION (ADR) PROCEEDING CO... EMAIL MEMORANDUM Forwarded From TSD 2024-12-13 CENRO ORMOC 02:19 PM 2024-12-16 3 Kevin Memoracion 2024-12-16 02:22 PM For Appropriate Action TSD 10:15 AM 2024-12-17 Kevin Memoracion 2024-12-17 10:56 AM 3 For information and record, Others For lodgement in the ADR-MRS database. RPS EVANGELINE LOPEZ 01:16 PM 2024-12-17
Edit Edit Copy Copy Delete Delete
DELETE FROM unit_action_incoming WHERE `unit_action_incoming`.`id` = 370
370 2024-14469 DANEKA NATULLA VFP CONSTRUCTION AND SUPPLIES BRGY. POBL. PARANAS, SAMAR 2024-12-18 03:05 PM INTENTION TO APPLY FOR ELIGIBILITY AND PARTICIPATE... WALK IN INTENTION TO APPLY FOR ELIGIBILITY AND PARTICIPATE... Forwarded From TSD 2024-12-18 VFP CONSTRUCTION AND SUPPLIES 12:00 PM 2024-12-23 3 Kevin Memoracion 2024-12-23 12:06 PM For Appropriate Action TSD 12:12 PM 2024-12-23 Kevin Memoracion 2024-12-23 12:13 PM 3 For Appropriate Action RPS EVANGELINE LOPEZ 04:11 PM 2024-12-23
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query