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_statistic`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ticket_id ticket_subject ticket_firstreply ticket_cat ticket_priority ticket_status ticket_notify ticket_tech ticket_hide ticket_module reply_author
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000001
10000001 FREQUENT MANUAL SHUTDOWNS AND RE‐STARTS OF T... 3 2 1 2 0 4 0 6 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000002
10000002 SLOW APPLICATION / PERFORMANCE PROBLEM 4 2 1 2 0 4 0 1 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000003
10000003 USD AVERAGE COST ARE HIGHER THAN PHP AVERAGE COST 5 2 2 2 0 4 0 1 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000004
10000004 UPON INVOICING OF REVISED PO 6 2 3 2 0 4 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000005
10000005 CANNOT CANCEL PO/PO LINE EVEN IF RECEIPT HAS BEEN ... 7 2 3 2 0 4 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000006
10000006 RECEIPTS OF PEPOI1305279 IS NOT REFLECTED TO ITEM ... 8 2 3 2 0 0 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000007
10000007 RECEIPTS OF PEPOI1305279 IS NOT REFLECTED TO ITEM ... 9 2 3 2 0 4 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000008
10000008 CANT SAVE PO RECORD WITH $6M COST. (BMXAA8123E) 10 2 3 2 0 4 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000009
10000009 ERROR DURING THE PROCESS OF ASSIGNING PROJECT NUMB... 11 2 2 2 0 4 0 1 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000010
10000010 AUTOMATION OF MRR# 12 2 3 2 0 4 0 6 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000011
10000011 WORK ORDER TRACKING APPLICATION. FIELDS (SUPERVISO... 13 2 3 2 0 4 0 1 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000012
10000012 WHAT WOULD BE THE BEST APPROACH IF PO LINE NEED TO... 14 2 3 2 0 4 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000013
10000013 INVENTORY LIST REPORT DISPLAYS IN‐ACCURATE F... 15 2 2 2 0 4 0 5 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000014
10000014 Revoke Write Access of all User to Work Order Trac... 29 2 3 2 0 4 0 1 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000015
10000015 BACK END CLOSING OF PR WITHOUT PO REFERENCE 38 2 3 2 0 4 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000016
10000016 TO REFLECT CV REF. AGAINST MRR NUM 39 2 3 2 0 4 0 6 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000017
10000017 WAS NOT ABLE TO RE-ORDER ITEM AUTOMATICALLY 43 2 3 2 0 4 0 5 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000018
10000018 SET CONTROL WHEREIN PR STATUS CANT BE CHANGED TO W... 48 2 3 2 0 4 0 6 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000019
10000019 READ ACCESS ACCOUNT FOR ACCOUNTVIL GROUP FOR PO DE... 49 2 3 2 0 4 0 6 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000020
10000020 WORK ORDER REPORTED BY SHOULD BE READ ONLY 50 2 3 2 0 4 0 1 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000021
10000021 PR Status UNBUDGETED 62 2 2 2 0 6 0 4 10
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000022
10000022 BMXAA0031E - The INVENTORY object is read only. Ve... 64 2 3 2 0 4 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000023
10000023 Dollar value of issuance transaction of items 7523... 67 2 2 2 0 4 0 5 14
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000024
10000024 PO CANCELLATION WHEN RECEIPT IS VOID 73 2 2 2 0 4 0 4 11
Edit Edit Copy Copy Delete Delete
DELETE FROM hd_statistic WHERE `hd_statistic`.`ticket_id` = 10000025
10000025 RFQ Report 74 2 2 2 0 4 0 4 10
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