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 `travel_requests`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id ref_no requester_id request_type for_employee for_driver driver_instruction needs_vehicle travel_date destination dest_lat dest_lng dest_address purpose time_from time_to department_id requisitioner_name approver_id approver_name status approver_remarks decided_at qr_token qr_sent_at admin_status date_received vehicle_id driver1_id driver2_id driver_sched_departure driver_sched_arrival arrangement_made_by arrangement_approved_by admin_remarks admin_updated_by admin_updated_at guard_status time_departure km_out time_arrival km_in guard_id guard_name guard_remarks created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 1
1 TGP-2026-00001 10 OB 1 0 NULL 0 2026-11-11 CALAMBA SM NULL NULL NULL DATE WITH MY BABYCAKES 12:00:00 17:00:00 6 GUERRERO, GERARDO C. 6 CAYABYAB, EDWIN P. APPROVED balik ka kaagad ha 2026-11-11 10:23:55 354ca16da0651f33af6086a1f2fe13591c74f36f 2026-11-11 10:25:42 NOT_REQUIRED NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-11 10:22:52 2026-11-18 15:38:33
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 2
2 TGP-2026-00002 11 OB 1 0 NULL 0 2026-11-12 STO TOMAS NULL NULL NULL DATE WITH MY BABYCAKES 10:30:00 14:28:00 1 LIA, JO C. 1 LEAÑO, GILMORE M. APPROVED nyenye 2026-11-11 10:29:23 0bd782f534acc5b2deee85cdc5905502baa52ef4 2026-11-11 10:29:23 NOT_REQUIRED NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-11 10:28:44 2026-11-18 15:38:33
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 3
3 TGP-2026-00003 12 PERSONAL 1 0 NULL 0 2026-11-12 STO. TOMAS NULL NULL NULL PERSONAL MATTER 14:00:00 15:00:00 1 DE, RUBY ANN V. 1 LEAÑO, GILMORE M. APPROVED NOTED 2026-11-12 13:37:01 d2e6cdeea3e873bb0fde7a1aef476c3379212111 2026-11-12 13:37:01 NOT_REQUIRED NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-12 13:32:55 2026-11-12 13:37:01
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 4
4 TGP-2026-00004 10 OB 1 0 NULL 0 2026-11-13 STO TOMAS NULL NULL NULL DATE WITH MY BABYCAKES 17:57:00 19:57:00 6 GUERRERO, GERARDO C. 6 CAYABYAB, EDWIN P. APPROVED NULL 2026-11-13 17:58:36 3ff5e80677817203786366c53eee5d8e0fc7c914 2026-11-13 17:58:36 NOT_REQUIRED NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-13 17:58:08 2026-11-18 15:38:33
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 5
5 TGP-2026-00005 12 OB 1 0 NULL 1 2026-11-13 STO. TOMAS NULL NULL NULL NOTARY 19:00:00 22:00:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. APPROVED noted 2026-11-13 18:08:46 3f80f049cfbceb112fa620485694f35ee45b5699 2026-11-13 18:08:46 PENDING NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-13 18:06:40 2026-11-13 18:08:46
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 6
6 TGP-2026-00006 12 PERSONAL 1 0 NULL 0 2026-11-13 STO. TOMAS NULL NULL NULL PERSONAL MATTER 19:00:00 19:01:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. APPROVED noted 2026-11-13 18:33:24 faceb803a06928e9b1fc529324eb432dc7efdbc6 2026-11-13 18:33:24 NOT_REQUIRED NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL OUT 2026-11-13 19:05:00 NULL NULL NULL 7 SECURITY GUARD ON DUTY NULL 2026-11-13 18:32:39 2026-11-13 18:36:12
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 7
7 TGP-2026-00007 12 OB 1 0 NULL 1 2026-11-13 STO. TOMAS NULL NULL NULL NOTARY 18:37:00 18:41:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. APPROVED NULL 2026-11-13 18:38:36 5d55005478e4570b17c4ebdaad0fd745502aa236 2026-11-13 18:38:36 ARRANGED 2026-11-13 2 2 NULL 2026-11-13 18:37:00 2026-11-13 18:41:00 HR & ADMIN OFFICE LEAÑO, GILMORE M. NULL 13 2026-11-13 18:43:56 RETURNED 2026-11-13 18:38:00 150.0 2026-11-13 22:48:00 160.0 7 SECURITY GUARD ON DUTY NULL 2026-11-13 18:37:54 2026-11-13 18:48:48
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 8
8 TGP-2026-00008 12 OB 1 0 NULL 1 2026-11-13 STO TOMAS NULL NULL NULL DOLE TRANSACTION 19:45:00 22:10:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. PENDING NULL NULL NULL NULL PENDING NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-13 19:09:08 2026-11-13 19:09:09
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 9
9 TGP-2026-00009 12 OB 1 0 NULL 1 2026-11-18 STO. TOMAS NULL NULL NULL DOLE TRANSACTION 18:00:00 19:00:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. APPROVED noted 2026-11-18 16:11:22 f0a5cc36331e7b9fefbfb8be31f7853b4d966781 2026-11-18 16:11:22 PENDING NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-18 16:10:44 2026-11-18 16:11:22
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 10
10 TGP-2026-00010 10 OB 1 0 NULL 1 2026-11-19 SM CITY CALAMBA BYPASS ROAD 14.2019624 121.1557454 SM City Calamba Bypass Road, SM City Calamba, Real... NOTARY 11:34:00 12:34:00 6 GUERRERO, GERARDO C. 6 CAYABYAB, EDWIN P. APPROVED NULL 2026-11-19 10:36:05 e366a858ec2dc6592a9e44dbc9e50eda0c2860d9 2026-11-19 10:36:05 ARRANGED 2026-11-19 2 2 NULL 2026-11-19 11:34:00 2026-11-19 12:34:00 HR & ADMIN OFFICE LEAÑO, GILMORE M. NULL 13 2026-11-19 10:36:48 WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-19 10:35:30 2026-11-19 10:36:48
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 11
11 TGP-2026-00011 12 OB 1 0 NULL 1 2026-11-19 SANTO TOMAS 7.5328350 125.6232185 Santo Tomas, Davao del Norte, Davao Region, 8112, ... DOLE TRANSACTION 11:02:00 12:00:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. APPROVED NULL 2026-11-19 11:05:07 1e981b8c7d27cab5a66b7ada25718ae11109bade 2026-11-19 11:05:22 PENDING NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-19 11:03:47 2026-11-19 11:05:22
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 12
12 TGP-2026-00012 12 OB 1 0 NULL 1 2026-11-19 SANTO TOMAS 7.5328350 125.6232185 Santo Tomas, Davao del Norte, Davao Region, 8112, ... DOLE TRANSACTION 11:02:00 12:00:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. PENDING NULL NULL NULL NULL PENDING NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-19 11:04:08 2026-11-19 11:04:08
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 13
13 TGP-2026-00013 12 OB 1 0 NULL 1 2026-11-19 SANTO TOMAS 7.5328350 125.6232185 Santo Tomas, Davao del Norte, Davao Region, 8112, ... DOLE TRANSACTION 11:02:00 12:00:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. PENDING NULL NULL NULL NULL PENDING NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-19 11:04:19 2026-11-19 11:04:19
Edit Edit Copy Copy Delete Delete
DELETE FROM travel_requests WHERE `travel_requests`.`id` = 14
14 TGP-2026-00014 12 OB 1 0 NULL 1 2026-11-19 SANTO TOMAS 7.5328350 125.6232185 Santo Tomas, Davao del Norte, Davao Region, 8112, ... DOLE TRANSACTION 11:02:00 12:00:00 1 DEQUIRO, RUBY ANN V. 1 LEAÑO, GILMORE M. PENDING NULL NULL NULL NULL PENDING NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL WAITING NULL NULL NULL NULL NULL NULL NULL 2026-11-19 11:04:31 2026-11-19 11:04:31
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