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 `ep_accounts` ORDER BY `is_current` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id account_key remote_id bank_name account_reference bank_reference account_holder_name customer_name account_status created_date updated_date updated_by created_by email checker checker_confirmed checker_confirmed_by checker_confirmed_at telegram_message_id is_current Descending Ascending 1 raw_json created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 14336
14336 124da8e5fc099234ff3168e9bbfa201f65b49d58dcc2d3dec2... 1402211 Nagad Personal Payment 01312851568 SMN013 01312851568-NAGAD SMEX3EP-BKASH|NAGAD|UPAY|ROCKET (SMNM) EX03 1 1781768173945 1781964163517 ExPayBDT019 ExPayBDT107 [email protected] DV 1 system_known_number 2026-06-19 01:47:57 NULL 1 {"customerBankInfoId":1402211,"bankName":"Nagad Pe... 2026-06-19 01:47:57 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 1
1 51ba7d27bba2392d5433f1fb989b4ab832a44915f22c211075... 1400058 Rocket Personal Payment 013075099810 SMR013 013075099810-ROCKET SMEX3DB -BKASH|NAAGD|UPAY|ROCKET (SM24/7) EX03 1 1781644545022 1781943678903 ExPayBDT059 ExPayBDT107 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1400058,"bankName":"Rocket P... 2026-06-17 08:28:54 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 513
513 ffe8e0bcdd5bb189013458eb9373d5c09e379a08701a5de42c... 1169064 Bkash Personal Payment 01863003533 SMB018 01863003533-BKASH SMEX46(3)-BKASH|NAGAD (SM24/7) EX46 1 1771338793500 1781693576661 ExPayBDT037 ExPayBDT039 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1169064,"bankName":"Bkash Pe... 2026-06-17 08:28:57 2026-06-20 21:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 4609
4609 07a681f5fe096d2eae543bdbc341b91ec2149c67a9fa7f3677... 762310 Upay Personal Payment 01864064324 SMU018 01864064324-UPAY SMEX3FL -BKASH|NAGAD|UPAY|ROCKET  (SM24/7) EX03 1 1756169764142 1781948893900 ExPayBDT057 ExPayBDT018 [email protected] DV 1 system_known_number 2026-06-17 08:39:52 NULL 1 {"customerBankInfoId":762310,"bankName":"Upay Pers... 2026-06-17 08:39:52 2026-06-20 21:36:47
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 4865
4865 ea63a380bde4845309ac73bd31f6731dd98b983dbf7956b769... 387016 Upay Personal Payment 01962587192 SMU019 01962587192-UPAY SMEX3O-NAGAD|BKASH|UPAY|ROCKET (SMNM) EX03 1 1741842141943 1781865769517 ExPayBDT018 admin [email protected] DV 1 system_known_number 2026-06-17 08:39:55 NULL 1 {"customerBankInfoId":387016,"bankName":"Upay Pers... 2026-06-17 08:39:55 2026-06-20 21:36:48
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 14337
14337 dfecdc468801e6a915aa335014f43e50e8514972cb68ab18b7... 1402210 Bkash Personal Payment 01312851568 SMB013 01312851568-BKASH SMEX3EP-BKASH|NAGAD|UPAY|ROCKET (SMNM) EX03 1 1781768167303 1781964161486 ExPayBDT019 ExPayBDT107 [email protected] DV 1 system_known_number 2026-06-19 01:47:57 NULL 1 {"customerBankInfoId":1402210,"bankName":"Bkash Pe... 2026-06-19 01:47:57 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 2
2 52ebacde1751be6e958eacf64fa898c63c81f6f2e649c3e108... 1400046 Rocket Personal Payment 019892748656 SMR019 019892748656-ROCKET SMEX3CS-BKASH|NAGAD|UPAY|ROCKET (SM24/7) EX03 1 1781643191001 1781904211722 ExPayBDT037 ExPayBDT107 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1400046,"bankName":"Rocket P... 2026-06-17 08:28:54 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 514
514 f10c67229b1ea17955c872ee1d52549caebea46dd6ba4aa966... 1168873 Nagad Merchant Payment 01823077003 MPN018 01823077003-NAGAD MPEX04(7)-EMON SOLAR HOUSE (MPNM) EX25 1 1771324150037 1781963403618 ExPayBDT019 ExPayBDT057 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1168873,"bankName":"Nagad Me... 2026-06-17 08:28:57 2026-06-20 21:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 3842
3842 43f4df4bceb27c82c44e54e1b08037fe68c7e1c70b477845b2... 1320066 Bkash Personal Payment 01740116323 SMB017 01740116323-BKASH SMEX3E - NAGAD|BKASH|ROCKET|UPAY (SMNM) EX03 1 1778031894625 1781963770450 ExPayBDT019 ExPayBDT107 [email protected] DV 1 system_known_number 2026-06-17 08:39:47 NULL 1 {"customerBankInfoId":1320066,"bankName":"Bkash Pe... 2026-06-17 08:39:47 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 4866
4866 23dca61121bdb97f3b8aa1daf1bd89c58228dc03c86a4c068d... 387015 Bkash Personal Payment 01962587192 SMB019 01962587192-BKASH SMEX3O-NAGAD|BKASH|UPAY|ROCKET (SMNM) EX03 1 1741842099941 1781932341169 ExPayBDT019 admin [email protected] DV 1 system_known_number 2026-06-17 08:39:55 NULL 1 {"customerBankInfoId":387015,"bankName":"Bkash Per... 2026-06-17 08:39:55 2026-06-20 21:36:48
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 10498
10498 fd8788f51f2747041d14a2a1d5b8836018c3e849f74fb617ad... 1227679 Nagad Personal Payment 01820859349 SMN018 01820859349-NAGAD SMEX3GO-BKASH |NAGAD (SM24/7) EX03 1 1774184025158 1781957323509 ExPayBDT037 ExPayBDT107 [email protected] ST 1 admin 2026-06-18 11:23:29 575 1 {"customerBankInfoId":1227679,"bankName":"Nagad Pe... 2026-06-17 12:48:47 2026-06-20 21:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 14338
14338 bdfb758235bdba9ac7f526e833ca914c56d6620263e62387fa... 1402207 Nagad Personal Payment 01327279071 SMN013 01327279071-NAGAD SMEX3IM-NAGAD(SMNM) EX03 1 1781768075282 1781855797990 ExPayBDT018 ExPayBDT107 [email protected] Robot 1 Robot 2026-06-19 03:32:45 NULL 1 {"customerBankInfoId":1402207,"bankName":"Nagad Pe... 2026-06-19 01:47:57 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 3
3 6011cd782ec79542f8d08f65ec095e9e8e8fbd9125d37dfad4... 1400042 Bkash Personal Payment 01989274865 SMB019 01989274865-BKASH SMEX3CS-BKASH|NAGAD|UPAY|ROCKET (SM24/7) EX03 1 1781643170245 1781895367955 ExPayBDT037 ExPayBDT107 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1400042,"bankName":"Bkash Pe... 2026-06-17 08:28:54 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 515
515 04f383abf35ae75a38f03ae932903f3a6e2c417a02595cccbd... 1168866 Nagad Merchant Payment 01817965791 MPN018 01817965791-NAGAD MPEX04(6)-ASLAM TELECOM (MPNM) EX25 1 1771323388935 1781964820027 ExPayBDT019 ExPayBDT057 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1168866,"bankName":"Nagad Me... 2026-06-17 08:28:57 2026-06-20 21:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 3843
3843 f92d4bb76fdf3afcc93038d125f585caac24e520a43a57293b... 1320065 Nagad Personal Payment 01740116323 SMN017 01740116323-NAGAD SMEX3E - NAGAD|BKASH|ROCKET|UPAY (SMNM) EX03 1 1778031887701 1781951905513 ExPayBDT019 ExPayBDT107 [email protected] DV 1 system_known_number 2026-06-17 08:39:47 NULL 1 {"customerBankInfoId":1320065,"bankName":"Nagad Pe... 2026-06-17 08:39:47 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 4611
4611 d38c098fe7e4da4ea648e56644b722cba8d73825453d180f6d... 762126 Upay Personal Payment 01977529121 SMU019 01977529121-UPAY SMEX3EZ-BKASH|ROCKET|UPAY (SM24/7) EX03 1 1756154551507 1781892048513 ExPayBDT059 ExPayBDT018 [email protected] DV 1 system_known_number 2026-06-17 08:39:52 NULL 1 {"customerBankInfoId":762126,"bankName":"Upay Pers... 2026-06-17 08:39:52 2026-06-20 21:36:47
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 14339
14339 4590ed84249654306a79815d570c575bd9fa0e5482c1374ab3... 1401974 Bkash Personal Payment 01329972346 SMB013 01329972346-BKASH SMEX3HN-BKASH(SMNM) EX03 1 1781754583296 1781955343762 ExPayBDT019 ExPayBDT107 [email protected] Robot 1 Robot 2026-06-19 03:32:45 NULL 1 {"customerBankInfoId":1401974,"bankName":"Bkash Pe... 2026-06-19 01:47:57 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 14595
14595 7904732aadd3070f957b97572c6196530cc58690aab141fb28... 1245287 Rocket Personal Payment 017417010571 SMR017 017417010571-ROCKET SMEX03X-BKASH/NAGAD/UPAY/ROCKET (SM24/7) EX03 1 1774950538195 1781892009157 ExPayBDT023 ExPayBDT107 [email protected] Robot 1 Robot 2026-06-19 03:32:45 NULL 1 {"customerBankInfoId":1245287,"bankName":"Rocket P... 2026-06-19 01:48:13 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 260
260 8ec9dc79ffba4b07601a24436027e8a0b33f1da38870919a11... 1282893 Nagad Merchant Payment 01609667402 MP016 01609667402-NAGAD MPEX18(1)-MAMUN TELECOM AND VARIETIES (MP24/7) S13... 1 1776277657467 1781960292348 ExPayBDT023 ExPayBDT107 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1282893,"bankName":"Nagad Me... 2026-06-17 08:28:56 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 516
516 29523b0c762c258f03fd9265df77737f62b37d758670332b60... 1168859 Nagad Merchant Payment 01891509205 MPN018 01891509205-NAGAD MPEX04(5)-SHA ALOM ELECTRIC (MPNM) EX25 1 1771323203856 1781964885874 ExPayBDT019 ExPayBDT057 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1168859,"bankName":"Nagad Me... 2026-06-17 08:28:58 2026-06-20 21:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 14340
14340 eb5e1014e39715012e5a192dcd02e7190ccf4607a519844198... 1401924 Nagad Personal Payment 01796416534 SMN017 01796416534-NAGAD SMEX3R-NAGAD|BKASH|ROCKET|UPAY (SMNM) EX03 1 1781749357169 1781749391091 ExPayBDT018 ExPayBDT107 [email protected] Robot 1 Robot 2026-06-19 03:32:45 NULL 1 {"customerBankInfoId":1401924,"bankName":"Nagad Pe... 2026-06-19 01:47:57 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 14596
14596 4062aab7dbb652292507d7fcc7b6f266926576ad996a7e15e8... 1245286 Upay Personal Payment 01741701057 SMU017 01741701057-UPAY SMEX03X-BKASH/NAGAD/UPAY/ROCKET (SM24/7) EX03 1 1774950519220 1781892008949 ExPayBDT023 ExPayBDT107 [email protected] Robot 1 Robot 2026-06-19 03:32:45 NULL 1 {"customerBankInfoId":1245286,"bankName":"Upay Per... 2026-06-19 01:48:13 2026-06-20 21:36:45
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 517
517 f94e55d6eb76998a27254ba31f06dd6c0b9237052f65d3eecd... 1168823 Nagad Merchant Payment 01314943750 MPN013 01314943750-NAGAD MPEX03(3)-BHAI BHAI TELECOM (MPNM) EX18 1 1771321671384 1781702366755 ExPayBDT037 ExPayBDT057 [email protected] DV 1 system_current_baseline 2026-06-17 08:29:03 NULL 1 {"customerBankInfoId":1168823,"bankName":"Nagad Me... 2026-06-17 08:28:58 2026-06-20 21:36:46
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 4869
4869 f8109ee530a23d4eb1d3fe8754cd3983680522badca8e93aa6... 384447 Upay Personal Payment 01341282214 SMU013 01341282214-UPAY SMEX3BM-BKASH|NAGAD|ROCKET|UPAY (SM24/7) EX03 1 1741749091262 1781892025626 ExPayBDT037 admin [email protected] DV 1 system_known_number 2026-06-17 08:39:55 NULL 1 {"customerBankInfoId":384447,"bankName":"Upay Pers... 2026-06-17 08:39:55 2026-06-20 21:36:48
Edit Edit Copy Copy Delete Delete
DELETE FROM ep_accounts WHERE `ep_accounts`.`id` = 9989
9989 8a8689c05ad77b67ac19a77467a4c970770ede5394b3f05119... 907516 Nagad Personal Payment 01752347808 SMN017 01752347808-NAGAD SMEX06(28)-BKASH(SMNM) EX03 1 1760975425469 1781957526646 ExPayBDT019 ExPayBDT057 [email protected] ST 1 admin 2026-06-18 11:12:31 524 1 {"customerBankInfoId":907516,"bankName":"Nagad Per... 2026-06-17 10:19:18 2026-06-20 21:36:47
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