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 `service_requests`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id reference_no project project_config_id date_requested department system_module system_form_name form_number concerns priority data_points personnel print_status files workflow memo status created_at updated_at tag
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 1
1 CNIMS-2025-07-0001 CITY OF NAGA INTEGRATED MANAGEMENT SYSTEM 3 2025-07-30 TREASURY`S OFFICE TREASURY Check Disbursement CMIS01101 ["Revision (Enhancement of Existing)"] {"immediate":true,"outsideScope":false} [{"id":1,"field":"Remove only","reference":"check"... {"user":{"id":343,"name":"Vivira P. Ababa","dataTy... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 2
2 CNIMS-2025-07-0002 CITY OF NAGA INTEGRATED MANAGEMENT SYSTEM 3 2025-07-30 TREASURY`S OFFICE TREASURY Change OR Details CMIS01213 ["Data Override\/Deletion"] {"immediate":true,"outsideScope":false} [{"id":1,"field":"Nilayat ang OR#","reference":"OR... {"user":{"id":312,"name":"Celeste D. Legaspi","dat... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 3
3 CNIMS-2025-07-0003 CITY OF NAGA INTEGRATED MANAGEMENT SYSTEM 3 2025-07-30 TREASURY`S OFFICE TREASURY General Collection CMIS01137 ["Data Override\/Deletion"] {"immediate":true,"outsideScope":false} [{"id":1,"field":"Nasayop ang pag gamit sa Stub no... {"user":{"id":306,"name":"Adrian G. Ramil","dataTy... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 4
4 CNIMS-2025-07-0004 CITY OF NAGA INTEGRATED MANAGEMENT SYSTEM 3 2025-07-27 BUILDING OFFICIAL`S OFFICE OBO Certificate of Occupancy CMIS00920 ["Cosmetic (Fonts\/Color\/Header\/Footer)"] {"immediate":false,"outsideScope":true} [{"id":1,"field":"Endorsement to BFRP Occupancy - ... {"user":{"id":159,"name":"Maria Angelica G. Alforq... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 5
5 CNIMS-2025-07-0005 CITY OF NAGA INTEGRATED MANAGEMENT SYSTEM 3 2025-07-26 BUSINESS PERMIT AND LICENSING OFFICE BPLS Business Master List CMIS00239 ["Bugs"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"Dili ma save and Retrieve ang da... {"user":{"id":2,"name":"Jec S. Carretas","dataType... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 6
6 CNIMS-2025-07-0006 CITY OF NAGA INTEGRATED MANAGEMENT SYSTEM 3 2025-07-30 BUDGET OFFICE Budget Supplemental Budget CMIS00272 ["Bugs"] {"immediate":true,"outsideScope":false} [{"id":1,"field":"Supplemental SEF Balance not Equ... {"user":{"id":146,"name":"Maribeth M. Villarin","d... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For IT Approval","cylix":"Completed","deve... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 7
7 CNIMS-2025-07-0007 CITY OF NAGA INTEGRATED MANAGEMENT SYSTEM 3 2025-07-31 TREASURY`S OFFICE TREASURY Check Disbursement CMIS01101 ["Bugs"] {"immediate":true,"outsideScope":false} [{"id":1,"field":"nawala sa cumulative list","refe... {"user":{"id":325,"name":"Hanna Debb P. Chua","dat... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 8
8 CBMIS-2025-07-0001 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-17 LOCAL CIVIL REGISTRAR OFFICE LCR Death Report CMIS00898 ["Revision (Enhancement of Existing)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"When printing CHO and Comelec re... {"user":{"id":1418,"name":"Yvette L. Ortega","data... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For IT Approval","cylix":"Completed","deve... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 9
9 CBMIS-2025-07-0002 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-17 ENFORCEMENT DIVISION Other Department Citation Tickets CMIS00972 ["Revision (Enhancement of Existing)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"CHANGE THE CONTACT NO. TO ORDINA... {"user":{"id":944,"name":"Erwin L. Lepon","dataTyp... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For IT Approval","cylix":"Completed","deve... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 10
10 CBMIS-2025-07-0003 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-08-01 TREASURY`S OFFICE TREASURY Business Collection Report CMIS01124 ["New (Function\/Field\/Entry\/Column\/Row)"] {"immediate":true,"outsideScope":false,"committedD... [{"id":1,"field":"New tile for Business tax collec... {"user":{"id":1579,"name":"Julio S. Ursonal Jr., C... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For Head Approval","cylix":"Completed","de... Business Tax Collection Report PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 11
11 CBMIS-2025-07-0004 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-08-07 TRAFFIC`S OFFICE ZONING Building Zoning CMIS01349 ["Revision (Enhancement of Existing)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"revision no.3 sa building zoning... {"user":{"id":996,"name":"Manilyn T. Judilla","dat... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For Head Approval","cylix":"Completed","de... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 12
12 CBMIS-2025-07-0005 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-26 ASSESSOR`S OFFICE ASSESSOR Tax Dec Masterlist CMIS00191 ["New (Function\/Field\/Entry\/Column\/Row)","Cosm... {"immediate":false,"outsideScope":false} [{"id":1,"field":"Old\/previous format sa taxdec (... {"user":{"id":542,"name":"Reinver O. Cuambot","dat... {"userRequest":{"checked":false,"date":"45863"},"c... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For IT Approval","cylix":"Completed","deve... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 13
13 CBMIS-2025-07-0006 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-08-03 PERSONNEL AND EMPLOYMENT SERVICES OFFICE PESO List of Employers (Local and Overseas) CMIS00996 ["Bugs"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"ig click sa print list button ka... {"user":{"id":1417,"name":"Yeddah Marie S. Cueva",... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 14
14 CCMIS-2025-07-0001 CITY OF CARCAR MANAGEMENT INFORMATION SYSTEM 2 2025-08-02 ASSESSOR`S OFFICE ASSESSOR TAXDEC LIST CMIS00240 ["Bugs"] {"immediate":false,"outsideScope":false} [{"id":1,"field":"Property added as previous Td in... {"user":{"id":2636,"name":"Joyline R. Navarro","da... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For Head Approval","cylix":"Completed","de... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 15
15 CBMIS-2025-07-0007 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-08-14 TRAFFIC`S OFFICE ZONING Building Zoning CMIS01349 ["New (Function\/Field\/Entry\/Column\/Row)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"add print ctc function","referen... {"user":{"id":996,"name":"Manilyn T. Judilla","dat... {"userRequest":{"checked":false,"date":"45881"},"c... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For Head Approval","cylix":"Completed","de... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 16
16 CBMIS-2025-07-0008 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-12 PERSONNEL AND EMPLOYMENT SERVICES OFFICE PESO List of Employers (Local and Overseas) CMIS00996 ["New (Function\/Field\/Entry\/Column\/Row)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"mo generate certificate of SRA- ... {"user":{"id":1417,"name":"Yeddah Marie S. Cueva",... {"userRequest":{"checked":false,"date":"45848"},"c... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For IT Approval","cylix":"Completed","deve... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 17
17 CBMIS-2025-07-0009 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-12 PERSONNEL AND EMPLOYMENT SERVICES OFFICE PESO SPES Application Form CMIS01017 ["New (Function\/Field\/Entry\/Column\/Row)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"add function na mo generate cert... {"user":{"id":1417,"name":"Yeddah Marie S. Cueva",... {"userRequest":{"checked":false,"date":"45848"},"c... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For IT Approval","cylix":"Completed","deve... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 18
18 CBMIS-2025-07-0010 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-08-02 TRAFFIC`S OFFICE TRAFFIC Traffic Citation Tickets CMIS01110 ["Bugs"] {"immediate":true,"outsideScope":false,"committedD... [{"id":1,"field":"bugs on Citation Tickets","refer... {"user":{"id":673,"name":"Boyet L. Ancajas","dataT... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For Head Approval","cylix":"Completed","de... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 19
19 CBMIS-2025-07-0011 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-09 PERSONNEL AND EMPLOYMENT SERVICES OFFICE PESO NSRP Member Profile CMIS01013 ["New (Function\/Field\/Entry\/Column\/Row)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"additional tile for NSRP Form 2 ... {"user":{"id":1417,"name":"Yeddah Marie S. Cueva",... {"userRequest":{"checked":false,"date":"45848"},"c... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For IT Approval","cylix":"Completed","deve... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 20
20 CBMIS-2025-07-0012 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-12 PERSONNEL AND EMPLOYMENT SERVICES OFFICE PESO Pledge of Commitment CMIS01014 ["Revision (Enhancement of Existing)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"Revised ang report","reference":... {"user":{"id":1417,"name":"Yeddah Marie S. Cueva",... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 21
21 CBMIS-2025-07-0013 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-08-02 ENVIRONMENTAL AND NATURAL RESOURCES OFFICE CENRO Citation Ticket CMIS00301 ["Bugs"] {"immediate":true,"outsideScope":false,"committedD... [] {"user":{"id":853,"name":"Pamela V. Conchas","data... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 22
22 CBMIS-2025-07-0014 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-09 PERSONNEL AND EMPLOYMENT SERVICES OFFICE PESO SPES - PLACEMENT REPORT CMIS01016 ["New (Function\/Field\/Entry\/Column\/Row)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"new form SPES- PLACEMENT Report ... {"user":{"id":1417,"name":"Yeddah Marie S. Cueva",... {"userRequest":{"checked":false,"date":"45845"},"c... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 23
23 CBMIS-2025-07-0015 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-07-09 PERSONNEL AND EMPLOYMENT SERVICES OFFICE PESO SPES - GPAI CMIS01015 ["New (Function\/Field\/Entry\/Column\/Row)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"new form sa SPES-GPAIand mo gene... {"user":{"id":1417,"name":"Yeddah Marie S. Cueva",... {"userRequest":{"checked":false,"date":"45845"},"c... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"Approved","cylix":"Completed","development... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 24
24 CBMIS-2025-07-0016 CITY OF BOGO MANAGEMENT INFORMATION SYSTEM 1 2025-08-02 ENFORCEMENT DIVISION Other Department COBED Citation Ticket CMIS00978 ["Bugs"] {"immediate":true,"outsideScope":false,"committedD... [{"id":1,"field":"bugs on Citation Tickets","refer... {"user":{"id":939,"name":"Cielo L. Lepasana","data... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For IT Approval","cylix":"Completed","deve... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
Edit Edit Copy Copy Delete Delete
DELETE FROM service_requests WHERE `service_requests`.`id` = 25
25 CNIMS-2025-07-0008 CITY OF NAGA INTEGRATED MANAGEMENT SYSTEM 3 2025-08-02 BUDGET OFFICE HUMAN RESOURCE Overtime Application CMIS00679 ["New (Function\/Field\/Entry\/Column\/Row)"] {"immediate":false,"outsideScope":false,"committed... [{"id":1,"field":"Add Summary tab report","referen... {"integrator":{"id":26,"name":"Michael V Tan","dat... {"userRequest":{"checked":false,"date":""},"curren... [{"id":1,"name":"view","url":"https:\/\/drive.goog... {"lgu":"For Head Approval","cylix":"Completed","de... PENDING 2026-02-10 02:11:54 2026-02-10 02:11:54 1
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view