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 `z_mobile_fee_transcations_status` ORDER BY `modified_at` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts tid session_id transaction_id platformBillID student_id paidamount discount_amount payment_mode card_name conveyance_fee conveyance_fee_type payer_vpa sender_ifsc sender_account_number status moved_status transaction_at payment_type upi_ref remarks schoolCode yr_id fee_details discount_details split_details payment_gateway response_message response_code id_type id_no paid_type paid_by whatsApp_no message_send added_at modified_at Descending Ascending 1 moved_at added_by_cron added_by moved_by
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53985
53985 AISKGL_9741_2197066684 2012612511040446665 NULL 9741 70000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-05 11:04:44 Re-admmission fee AISKGL 19 {"split":[{"amount":"70000.00","product_id":"DEFAU... pg Transaction Successful. 00000 8310237900 N 2026-05-05 11:04:42 2026-05-05 11:05:24 2026-05-05 11:04:42 2026-05-05 11:05:03 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53984
53984 AISKGL_10600_6100774928 2012612510460356266 NULL 10600 89400.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-05 10:46:34 AISKGL 20 {"split":[{"amount":"89400.00","product_id":"DEFAU... pg Transaction Successful. 00000 9900105720 N 2026-05-05 10:46:34 2026-05-05 10:47:02 2026-05-05 10:46:34 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53983
53983 AISKGL_6508_5695077659 2022612510080565479 NULL 6508 5000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-05 10:08:55 School fee AISKGL 19 {"split":[{"amount":"5000.00","product_id":"DEFAUL... pg Transaction Successful. 00000 8971791482 N 2026-05-05 10:08:54 2026-05-05 10:09:39 2026-05-05 10:08:54 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53982
53982 AISKGL_5730_3946210388 2022612510060565444 NULL 5730 5000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-05 10:06:56 School fee AISKGL 19 {"split":[{"amount":"5000.00","product_id":"DEFAUL... pg Transaction Successful. 00000 8971791482 N 2026-05-05 10:06:54 2026-05-05 10:08:11 2026-05-05 10:06:54 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53981
53981 AISKGL_7152_7526758218 2022612509470035114 NULL 7152 70000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-05 09:47:03 AISKGL 19 {"split":[{"amount":"70000.00","product_id":"DEFAU... pg Transaction Successful. 00000 9611729565 N 2026-05-05 09:47:01 2026-05-05 09:47:53 2026-05-05 09:47:01 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53980
53980 AISKGL_8684_6008044473 2032612509300124862 NULL 8684 70000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-05 09:30:12 AISKGL 19 {"split":[{"amount":"70000.00","product_id":"DEFAU... pg Transaction Successful. 00000 8722777118 N 2026-05-05 09:30:11 2026-05-05 09:30:32 2026-05-05 09:30:11 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53979
53979 AISKGL_9924_1905322930 2022612508560494431 NULL 9924 35000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-05 08:56:48 Syed Arham AISKGL 19 {"split":[{"amount":"35000.00","product_id":"DEFAU... pg Transaction Successful. 00000 8095384102 N 2026-05-05 08:56:47 2026-05-05 08:57:32 2026-05-05 08:56:47 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53978
53978 AISKGL_9465_4987663234 2012612507530323925 NULL 9465 70000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-05 07:53:32 School fees payment 1st Instalment  60000 + 10000 ... AISKGL 19 {"split":[{"amount":"70000.00","product_id":"DEFAU... pg Transaction Successful. 00000 8095014776 N 2026-05-05 07:53:30 2026-05-05 07:55:01 2026-05-05 07:53:30 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53977
53977 AISKGL_9587_2222006828 2022612419320311533 NULL 9587 60000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 19:32:31 AISKGL 19 {"split":[{"amount":"60000.00","product_id":"DEFAU... pg Transaction Successful. 00000 9845820272 N 2026-05-04 19:32:30 2026-05-04 19:33:42 2026-05-04 19:32:30 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53976
53976 AISKGL_11070_9050268461 2022612417280259830 NULL 11070 30000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 17:28:25 AISKGL 20 {"split":[{"amount":"30000.00","product_id":"DEFAU... pg Transaction Successful. 00000 7022305341 N 2026-05-04 17:28:23 2026-05-04 17:28:51 2026-05-04 17:28:23 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53975
53975 AISKGL_11069_6439640589 2032612417060389506 NULL 11069 60000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 17:06:38 School fee for Lekhans 8th Std Admission to Arvind... AISKGL 20 {"split":[{"amount":"60000.00","product_id":"DEFAU... pg Transaction Successful. 00000 9480001026 N 2026-05-04 17:06:36 2026-05-04 17:07:08 2026-05-04 17:06:36 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53972
53972 AISKGL_11066_4531601268 2022612416360519072 NULL 11066 17000.00 0.00 UPI NULL 0.00 0 0 0 0 1 0 2026-05-04 16:36:51 AISKGL 20 {"split":[{"amount":"17000.00","product_id":"DEFAU... pg Transaction Not Processed By User. FFFFF 6361793480 N 2026-05-04 16:36:50 2026-05-04 16:45:04 2026-05-04 16:36:50 2026-05-04 16:45:04 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53974
53974 AISKGL_11066_9842189030 2022612416430099177 NULL 11066 5000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 16:43:08 AISKGL 20 {"split":[{"amount":"5000.00","product_id":"DEFAUL... pg Transaction Successful. 00000 6361793480 N 2026-05-04 16:43:08 2026-05-04 16:45:02 2026-05-04 16:43:08 2026-05-04 16:45:02 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53973
53973 AISKGL_11066_5440564736 2022612416380329102 NULL 11066 17000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 16:38:32 AISKGL 20 {"split":[{"amount":"17000.00","product_id":"DEFAU... pg Transaction Successful. 00000 6361793480 N 2026-05-04 16:38:31 2026-05-04 16:40:02 2026-05-04 16:38:31 2026-05-04 16:40:02 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53971
53971 AISKGL_I-209_1232847744 2022612416310338981 NULL I-209 1000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 16:31:33 AISKGL 20 Application {"split":[{"amount":"1000.00","product_id":"DEFAUL... pg Transaction Successful. 00000 N 2026-05-04 16:31:32 2026-05-04 16:32:06 2026-05-04 16:31:32 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53970
53970 AISKGL_11065_6553189028 2022612416150018709 NULL 11065 85000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 16:15:01 AISKGL 20 {"split":[{"amount":"85000.00","product_id":"DEFAU... pg Transaction Successful. 00000 9538615237 N 2026-05-04 16:15:00 2026-05-04 16:15:28 2026-05-04 16:15:00 2026-05-04 16:15:02 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53966
53966 AISKGL_8611_4539538366 2012612415500568299 NULL 8611 40000.00 0.00 NA NULL 0.00 0 0 0 0 1 0 2026-05-04 15:50:56 School fees AISKGL 19 {"split":[{"amount":"40000.00","product_id":"DEFAU... pg Failed - No action performed by customer on checko... FFFFF 9986572277 N 2026-05-04 15:50:52 2026-05-04 16:10:02 2026-05-04 15:50:52 2026-05-04 16:10:02 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53969
53969 AISKGL_11065_9986762611 2022612416050248557 NULL 11065 85000.00 0.00 UPI NULL 0.00 0 0 0 0 1 0 2026-05-04 16:05:23 AISKGL 20 {"split":[{"amount":"85000.00","product_id":"DEFAU... pg Customer Cancelled 064 9538615237 N 2026-05-04 16:05:22 2026-05-04 16:07:07 2026-05-04 16:05:22 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53967
53967 AISKGL_9634_1495548786 2032612415520358333 NULL 9634 50000.00 0.00 UPI NULL 0.00 0 0 0 0 1 0 2026-05-04 15:52:35 Fee AISKGL 19 {"split":[{"amount":"50000.00","product_id":"DEFAU... pg RISK THRESHOLD EXCEEDED ERU16 8867728404 N 2026-05-04 15:52:34 2026-05-04 15:55:02 2026-05-04 15:52:34 2026-05-04 15:55:02 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53968
53968 AISKGL_9634_9783636578 2032612415540318370 NULL 9634 49000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 15:54:31 Fee AISKGL 19 {"split":[{"amount":"49000.00","product_id":"DEFAU... pg Transaction Successful. 00000 8867728404 N 2026-05-04 15:54:30 2026-05-04 15:54:58 2026-05-04 15:54:30 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53965
53965 AISKGL_11063_2919032632 2032612415270297919 NULL 11063 25000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 15:27:29 AISKGL 20 {"split":[{"amount":"25000.00","product_id":"DEFAU... pg Transaction Successful. 00000 9902372497 N 2026-05-04 15:27:27 2026-05-04 15:27:56 2026-05-04 15:27:27 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53964
53964 AISKGL_10391_5937614934 2022612415240187863 NULL 10391 60000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 15:24:18 Collage feese AISKGL 19 {"split":[{"amount":"60000.00","product_id":"DEFAU... pg Transaction Successful. 00000 9986632222 N 2026-05-04 15:24:17 2026-05-04 15:24:57 2026-05-04 15:24:17 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53963
53963 AISKGL_11059_7364910746 2022612415080277547 NULL 11059 35000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 15:08:26 AISKGL 20 {"split":[{"amount":"35000.00","product_id":"DEFAU... pg Transaction Successful. 00000 9742214999 N 2026-05-04 15:08:22 2026-05-04 15:08:54 2026-05-04 15:08:22 NULL 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53962
53962 AISKGL_10056_7409849921 2022612414270376783 NULL 10056 70000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 14:27:37 AISKGL 19 {"split":[{"amount":"70000.00","product_id":"DEFAU... pg Transaction Successful. 00000 9964404607 N 2026-05-04 14:27:36 2026-05-04 14:31:49 2026-05-04 14:27:36 2026-05-04 14:30:02 0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_fee_transcations_status WHERE `z_mobile_fee_transcations_status`.`tid` = 53961
53961 AISKGL_9504_5996178777 2022612414260246758 NULL 9504 70000.00 0.00 UPI NULL 0.00 0 0 0 0 2 0 2026-05-04 14:26:24 9 th  admission fee AISKGL 19 {"split":[{"amount":"70000.00","product_id":"DEFAU... pg Transaction Successful. 00000 7975212688 N 2026-05-04 14:26:23 2026-05-04 14:27:39 2026-05-04 14:26:23 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