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 `transactions` ORDER BY `reference` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts reference Descending Ascending 1 user_id plan_id merchant_ref amount status created_at expired_at invoice_chat_id invoice_message_id is_perpanjang extend_months
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731931043JYXD6'
T4794731931043JYXD6 8020089854 2 PLAN-2-8020089854-1774413639035 5000 paid 1774413639 1774413939 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731901207QUBVK'
T4794731901207QUBVK 7811890183 2 PLAN-2-7811890183-1774302787544 5000 canceled 1774302793 1774303087 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T47947318707958FTIR'
T47947318707958FTIR 6877356776 3 PLAN-3-6877356776-1774164596986 15000 expired 1774164599 1774164896 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731824703EBIDD'
T4794731824703EBIDD 7546765937 3 PLAN-3-7546765937-1774001545618 15000 paid 1774001547 1774001845 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T47947316865843F4DY'
T47947316865843F4DY 7525616566 3 PLAN-3-7525616566-1773562706638 15000 expired 1773562707 1773563006 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T47947316735892JZGE'
T47947316735892JZGE 8041164336 2 PLAN-2-8041164336-1773521671605 5000 expired 1773521673 1773521971 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731606819U9DOL'
T4794731606819U9DOL 5886938793 3 PLAN-3-5886938793-1773331198477 15000 expired 1773331199 1773331498 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731577572FICZ9'
T4794731577572FICZ9 1926225116 2 PLAN-2-1926225116-1773238295438 5000 canceled 1773238296 1773238595 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T47947315622767IJ3B'
T47947315622767IJ3B 8331602646 2 PLAN-2-8331602646-1773204103140 5000 expired 1773204104 1773204403 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731547288RWUVO'
T4794731547288RWUVO 8583384996 2 PLAN-2-8583384996-1773168016457 5000 canceled 1773168017 1773168316 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731521601CCQGK'
T4794731521601CCQGK 7181788076 2 PLAN-2-7181788076-1773123244672 5000 expired 1773123245 1773123544 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731500680F9N5Y'
T4794731500680F9N5Y 8148729310 3 PLAN-3-8148729310-1773064605434 15000 paid 1773064612 1773064905 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731472937NL5O1'
T4794731472937NL5O1 1204823428 2 PLAN-2-1204823428-1772993822099 5000 paid 1772993822 1772994122 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731466940WT9YX'
T4794731466940WT9YX 6072324943 3 PLAN-3-6072324943-1772974700163 15000 expired 1772974701 1772975000 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T47947314541924D1AQ'
T47947314541924D1AQ 8487177327 2 PLAN-2-8487177327-1772943641590 5000 expired 1772943642 1772943941 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T47947314112194OYFD'
T47947314112194OYFD 7796670315 3 PLAN-3-7796670315-1772806169578 15000 expired 1772806170 1772806469 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731397951DBRVE'
T4794731397951DBRVE 5195458017 3 PLAN-3-5195458017-1772783000391 25000 expired 1772783002 1772783300 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731377250QYNTB'
T4794731377250QYNTB 1204823428 2 PLAN-2-1204823428-1772725847752 5000 canceled 1772725848 1772726147 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731373433EH2G7'
T4794731373433EH2G7 6886529931 3 PLAN-3-6886529931-1772718878853 25000 canceled 1772718879 1772719178 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731369293HAQTY'
T4794731369293HAQTY 8074885913 2 PLAN-2-8074885913-1772713147314 1000 paid 1772713148 1772713447 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731367458KHHLR'
T4794731367458KHHLR 8074885913 2 PLAN-2-8074885913-1772710859771 1000 paid 1772710860 1772711159 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731364123QEQWF'
T4794731364123QEQWF 6072324943 2 PLAN-2-6072324943-1772705494333 10000 canceled 1772705495 1772705794 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731363814IOMFX'
T4794731363814IOMFX 6032108642 3 PLAN-3-6032108642-1772705008168 25000 canceled 1772705008 1772705308 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T47947313626153PHTA'
T47947313626153PHTA 2116779448 2 PLAN-2-2116779448-1772703109708 10000 paid 1772703110 1772703409 NULL NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM transactions WHERE `transactions`.`reference` = 'T4794731361653OLKYI'
T4794731361653OLKYI 6886529931 3 PLAN-3-6886529931-1772701511900 25000 canceled 1772701512 1772701811 NULL NULL 0 0
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