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 `hd_tickets` ORDER BY `ticket_id` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ticket_id Descending Ascending 1 ticket_subject ticket_site ticket_firstreply ticket_lastreply lastupdate_by ticket_cat ticket_priority ticket_status ticket_notify ticket_tech ticket_techval ticket_author ticket_hide ticket_module ticket_resolution ticket_reference ticket_company_id ticket_remark_id ticket_class_id flag date_status billable ticket_pmr ticket_reportedby ticket_reportedbyname ticket_lastreplyby ticket_ccemail ticket_cr ticket_crstartdate ticket_crenddate ticket_crnum ticket_milestones from_email ticket_projecttype ticket_projectname ticket_deployment
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007687
10007687 Error encountered on WR 2904- Custom condition cla... Pantabangan 56286 56291 10058 2 3 9 1 0 0 10058 0 1 19 4 3 0 2026-08-06 13:51:44 0 mdmartires@firstgen.com.ph Mark Martires cmmsadministrator@firstgen.com.ph mmchica@firstgen.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007686
10007686 Request for Information: Operational Dashboard Pantabangan 56265 56290 10058 2 3 9 1 0 0 10058 0 1 0 19 4 1 0 2026-08-06 13:44:20 0 mdmartires@firstgen.com.ph Mark Martires cmmsadministrator@firstgen.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007685
10007685 Closed WO: Erroneous data entry on the actual labo... Pantabangan 56260 56294 10086 2 3 2 1 10034 10086 10058 0 1 4 19 4 4 0 2026-08-06 16:13:40 0 mdmartires@firstgen.com.ph Mark Martires wendy.felicitas@seambest.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007684
10007684 recorded "created by"  on Operator Logs does not p... FRLC 56257 56282 10086 2 3 10 1 0 10086 10058 0 1 0 19 4 16 0 2026-08-05 14:37:32 0 mdmartires@firstgen.com.ph Mark Martires wendy.felicitas@seambest.com.ph dcbagsic@firstgen.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007683
10007683 WO 39655 Std Action; review item desc Does not dis... Pantabangan 56255 56288 10086 2 3 10 1 0 10086 10058 0 1 0 19 4 16 0 2026-08-06 09:57:19 0 mdmartires@firstgen.com.ph Mark Martires wendy.felicitas@seambest.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007682
10007682 Ref ticket IBSI ticket 283107: ACCESS MANAGEMENT -... Pantabangan 56253 56287 10058 2 4 9 1 0 0 10058 0 1 2 19 4 12 0 2026-08-06 09:03:45 0 mdmartires@firstgen.com.ph Mark Martires cmmsadministrator@firstgen.com.ph 0 0000-00-00 0000-00-00 Deployed
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007681
10007681 PM Work Order Released Ahead of Scheduled Release ... FRLC 56246 56295 10086 2 3 2 1 10022 10086 10078 0 1 5 19 4 10 0 2026-08-07 09:52:26 0 mfeepi@firstgen.com.ph Marlo Frenshal E. Epi wendy.felicitas@seambest.com.ph mdmartires@firstgen.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007680
10007680 INVENTORY ADJUSTMENT INTEGRATION: Revision of SAP ... GNPK 56233 56234 10043 2 3 15 1 0 0 90 0 0 0 10007597 10 4 5 0 2026-07-24 09:44:24 0 ErickDave.Rosil@gnpk.com.ph DAVE jessa.delacruz@seambest.com.ph 0 0000-00-00 0000-00-00 Implementation
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007679
10007679 POs have incorrect GL debit account GNPK 56231 56236 10043 2 3 14 1 0 0 90 0 4 0 10 4 10 0 2026-07-24 09:48:13 0 ErickDave.Rosil@gnpk.com.ph dave jessa.delacruz@seambest.com.ph 0 0000-00-00 0000-00-00 Implementation
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007678
10007678 EXTEND THE CHARACTER LENGTH IN THE FIELD - DESCRIP... MPMCD 56229 56232 10043 2 3 10 1 0 0 10082 0 0 0 16 4 7 0 2026-07-23 16:34:28 1 erviecrystel8828@gmail.com Ervie Crystel L. Almodovar jessa.delacruz@seambest.com.ph genalyn.sebello@quezoncity.gov.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007677
10007677 automating buyer assignment and vendor shortlistin... GNPK 56227 56237 10043 2 3 14 1 0 10069 90 0 4 0 10006781 10 4 10 0 2026-07-24 09:48:39 0 ErickDave.Rosil@gnpk.com.ph dave jessa.delacruz@seambest.com.ph 0 0000-00-00 0000-00-00 Implementation
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007676
10007676 PO Line Configuration Discrepancy on PO Release – ... GNPK 56222 56223 90 2 3 9 1 0 0 90 0 4 10 4 10 0 2026-07-23 09:31:39 0 ErickDave.Rosil@gnpk.com.ph dave ErickDave.Rosil@gnpk.com.ph 0 0000-00-00 0000-00-00 Implementation
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007675
10007675 Request to Create Charge Account Transaction withi... GNPK 56221 56235 10043 2 3 14 1 0 0 90 0 4 0 10007620 10 4 10 0 2026-07-24 09:47:03 0 ErickDave.Rosil@gnpk.com.ph DAVE jessa.delacruz@seambest.com.ph 0 0000-00-00 0000-00-00 Implementation
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007674
10007674 encountered error in saving MR 1781 Pantabangan 56208 56220 10043 2 3 2 1 10069 10069 10058 0 5 4 19 4 3 0 2026-07-22 13:46:22 0 mdmartires@firstgen.com.ph Mark Martires jessa.delacruz@seambest.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007673
10007673 Request to Allow buyers to change the status of PO... GNPK 56194 56207 90 2 3 9 1 0 10069 90 0 4 0 10 4 3 0 2026-07-21 14:17:06 0 ErickDave.Rosil@gnpk.com.ph dave ErickDave.Rosil@gnpk.com.ph 0 0000-00-00 0000-00-00 Implementation
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007672
10007672 URGENT: SAP GSQ Environment Connection Failure for... GNPK 56185 56189 10043 2 2 15 1 0 0 90 0 0 0 10 4 5 0 2026-07-20 10:53:13 0 ErickDave.Rosil@gnpk.com.ph Dave jessa.delacruz@seambest.com.ph jessa.delacruz@seambest.com.ph 0 0000-00-00 0000-00-00 Implementation
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007671
10007671 encountered error during processing- Dept head app... Pantabangan 56175 56215 10069 2 3 2 1 10069 10069 10058 0 4 4 19 4 3 0 2026-07-22 10:21:04 0 mdmartires@firstgen.com.ph Mark Martires jeanclaudette.remolona@seambest.com.ph rmcawat@firstgen.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007670
10007670 Upper warning has been hit for Measure Point 10003... FRLC 56159 56206 10043 2 3 2 1 10034 10034 10058 0 1 4 19 4 3 0 2026-07-21 09:19:38 0 mdmartires@firstgen.com.ph Mark Martires jessa.delacruz@seambest.com.ph mfeepi@firstgen.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007669
10007669 Access Issue: Users can update inventory balance i... CWMD 56149 56156 10043 2 4 10 1 0 0 10083 0 5 0 16 4 12 0 2026-07-16 10:10:07 0 qccgsd.cwmd@gmail.com ANTONIO F. CARATING JR jessa.delacruz@seambest.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007668
10007668 Error encountered in Entering meter in the WO- Mte... Pantabangan 56147 56178 10086 2 3 2 1 10022 10086 10058 0 1 4 19 4 4 0 2026-07-17 12:51:13 0 mdmartires@firstgen.com.ph Mark Martires wendy.felicitas@seambest.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007667
10007667 Include meter description in the Work Order- meter... Pantabangan 56146 56179 10086 2 4 15 1 0 10086 10058 0 1 0 19 4 7 0 2026-07-17 12:55:22 1 mdmartires@firstgen.com.ph Mark Martires wendy.felicitas@seambest.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007666
10007666 KINDLY REMOVE THE AUTOMATIC TICK FOR EQUIPMENT AMO... MPMCD 56139 56154 10043 2 4 15 1 0 0 10082 0 4 0 16 4 1 0 2026-07-16 09:53:06 1 erviecrystel8828@gmail.com Ervie Crystel L. Almodovar jessa.delacruz@seambest.com.ph genalyn.sebello@quezoncity.gov.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007665
10007665 Missing HRMD Storeroom in Storeroom Filter CWMD 56112 56216 10043 2 2 2 1 0 0 10083 0 5 0 16 4 1 0 2026-07-22 11:01:06 0 qccgsd.cwmd@gmail.com ANTONIO F. CARATING JR jessa.delacruz@seambest.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007664
10007664 Duplicated Release of PM Work Orders FRLC 56109 56243 10086 2 3 2 1 10086 10086 10078 0 1 4 19 4 3 0 2026-07-27 14:41:25 0 mfeepi@firstgen.com.ph Marlo Frenshal E. Epi wendy.felicitas@seambest.com.ph mdmartires@firstgen.com.ph 0 0000-00-00 0000-00-00
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_tickets WHERE `hd_tickets`.`ticket_id` = 10007663
10007663 KINDLY REMOVE THE AUTOMATIC TICK FOR  AMOUNT BELOW... MPMCD 56095 56116 10043 2 4 15 1 0 0 10082 0 2 0 16 4 1 0 2026-07-13 11:04:13 1 erviecrystel8828@gmail.com Ervie Crsytel L. Almodovar jessa.delacruz@seambest.com.ph genalyn.sebello@quezoncity.gov.ph 0 0000-00-00 0000-00-00
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