pma.tirexuserbot.com / localhost / violet / user_orders

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (297 total, Query took 0.0008 seconds.) [updated_at: 2026-04-19 14:47:59... - 2026-04-20 17:22:17...]

SELECT * FROM `user_orders` ORDER BY `updated_at` ASC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			order_id	user_id	target_username	quantity	rate_idr	total_idr	status	order_type	invoice_chat_id	invoice_message_id	owner_notifs_json	fragment_tx_hash	reason_text	created_at	updated_at 1	violet_checkout_token	violet_id_reference	violet_checkout_url	premium_months	bulk_items_json
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776610030996WFGQ4Y'	STARS-1776610030996WFGQ4Y	8074885913	violetmediapay	50	272	13600	cancelled	stars	8074885913	284	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-19 14:47:15	2026-04-19 14:47:59	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776610279839Y1CKSS'	STARS-1776610279839Y1CKSS	8074885913	violetmediapay	50	272	13600	failed	stars	8074885913	300	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Traceback (most recent call last): File "<string...	2026-04-19 14:51:23	2026-04-19 14:51:30	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-17766105931766RI7SI'	STARS-17766105931766RI7SI	8074885913	violetmediapay	50	272	13600	failed	stars	8074885913	310	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Traceback (most recent call last): File "<string...	2026-04-19 14:56:35	2026-04-19 14:56:38	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776611032991UKOX42'	STARS-1776611032991UKOX42	8074885913	violetmediapay	50	272	13600	processing	stars	8074885913	321	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	NULL	2026-04-19 15:03:55	2026-04-19 15:03:58	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776611288846XG67NP'	STARS-1776611288846XG67NP	8074885913	violetmediapay	50	272	13600	accepted	stars	8074885913	333	[{"ownerId":"8074885913","chatId":8074885913,"mess...	b4972511bca0693135b1047054bbc5c8035ae53242758f4018...	NULL	2026-04-19 15:08:10	2026-04-19 15:08:56	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776612266114T0FNFU'	STARS-1776612266114T0FNFU	7174723483	violetmediapay	50	272	13600	cancelled	stars	7174723483	351	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-19 15:24:28	2026-04-19 15:24:51	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776613355508Q5FR54'	STARS-1776613355508Q5FR54	7174723483	kalengsardenbos	50	272	13600	cancelled	stars	7174723483	387	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-19 15:42:38	2026-04-19 15:44:40	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776613763041EQYG6S'	STARS-1776613763041EQYG6S	7174723483	kalengsardenbos	50	272	13600	pending	stars	7174723483	399	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	NULL	2026-04-19 15:49:25	2026-04-19 15:49:25	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776614144339XGHQO3'	STARS-1776614144339XGHQO3	8074885913	techwiz37	50	272	13600	accepted	stars	8074885913	408	[{"ownerId":"8074885913","chatId":8074885913,"mess...	289e0d2d9929e2cd35e08a9990d2aba1ed23681135f011a13d...	NULL	2026-04-19 15:55:46	2026-04-19 16:01:28	D18667261AZAAUYX2IA7HSF	D18667261AZAAUYX2IA7HSF	https://violetmediapay.com/payout.php?D18667261AZA...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-177661620443070O72C'	STARS-177661620443070O72C	7174723483	kalengsardenbos	50	150	7500	cancelled	stars	7174723483	433	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-19 16:30:06	2026-04-19 16:30:40	D186672658AE84XI28Z6WBC	D186672658AE84XI28Z6WBC	https://violetmediapay.com/payout.php?D186672658AE...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-17766163003627Z40PK'	STARS-17766163003627Z40PK	7174723483	kalengsardenbos	50	90	4500	cancelled	stars	7174723483	448	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-19 16:31:43	2026-04-19 16:31:48	D1866726LJPJYNR7TNETBZR	D1866726LJPJYNR7TNETBZR	https://violetmediapay.com/payout.php?D1866726LJPJ...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-17766163523048B409B'	STARS-17766163523048B409B	7174723483	kalengsardenbos	50	10	500	failed	stars	7174723483	467	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Insufficient balance. Required: 0.575600 TON, Avai...	2026-04-19 16:32:35	2026-04-19 16:37:31	D1866726XTC6CN6FXR6YSD3	D1866726XTC6CN6FXR6YSD3	https://violetmediapay.com/payout.php?D1866726XTC6...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776616752483P7XP59'	STARS-1776616752483P7XP59	7174723483	kalengsardenbos	50	10	500	accepted	stars	7174723483	477	[{"ownerId":"8074885913","chatId":8074885913,"mess...	306d5aaf9070a3c8d999a7b3746874dbcb219ccecbe7a47597...	NULL	2026-04-19 16:39:17	2026-04-19 16:40:28	D18667265FDCUC07MW5REMD	D18667265FDCUC07MW5REMD	https://violetmediapay.com/payout.php?D18667265FDC...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776645971988YCAVU2'	STARS-1776645971988YCAVU2	5785996946	violetmediapay	50	273	13650	cancelled	stars	5785996946	557	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-20 00:46:16	2026-04-20 00:46:21	D18667268VZCXQ4FURSOOXC	D18667268VZCXQ4FURSOOXC	https://violetmediapay.com/payout.php?D18667268VZC...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'PREM-1776646001605ZFTYQH'	PREM-1776646001605ZFTYQH	5785996946	kalengsardenbos	0	0	210000	cancelled	premium	5785996946	566	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-20 00:46:44	2026-04-20 00:46:48	D1866726VQH06685QT2KL2L	D1866726VQH06685QT2KL2L	https://violetmediapay.com/payout.php?D1866726VQH0...	3	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'BULK-1776646032152C62BT0'	BULK-1776646032152C62BT0	5785996946		100	273	27300	cancelled	bulk	5785996946	574	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-20 00:47:14	2026-04-20 00:47:16	D1866726BMCKKU5400T3JY8	D1866726BMCKKU5400T3JY8	https://violetmediapay.com/payout.php?D1866726BMCK...	NULL	[{"username":"kalengsardenbos","qty":50},{"usernam...
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-1776648280990E01FDH'	STARS-1776648280990E01FDH	7174723483	kalengsardenbos	50	10	500	accepted	stars	7174723483	611	[{"ownerId":"8074885913","chatId":8074885913,"mess...	d5d1c09cde910c42e65357a7e1be6b7a0e579cc5a5481ef8f6...	NULL	2026-04-20 01:24:43	2026-04-20 01:26:01	D18667265NXPEKLDV0UDG0X	D18667265NXPEKLDV0UDG0X	https://violetmediapay.com/payout.php?D18667265NXP...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-17766512154037AIV85'	STARS-17766512154037AIV85	5785996946	kalengsardenbos	50	272	13600	cancelled	stars	5785996946	670	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-20 02:13:37	2026-04-20 02:14:09	D1866726WHP81HIS13YYFAJ	D1866726WHP81HIS13YYFAJ	https://violetmediapay.com/payout.php?D1866726WHP8...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'PREM-1776653361867X7ZJK0'	PREM-1776653361867X7ZJK0	1667414223	aboutodette	0	0	210000	failed	premium	1667414223	731	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Pembayaran gagal atau expired.	2026-04-20 02:49:30	2026-04-20 03:03:59	D1866726MVSCEVPO3IK7AJQ	D1866726MVSCEVPO3IK7AJQ	https://violetmediapay.com/payout.php?D1866726MVSC...	3	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'PREM-177665624213074SI58'	PREM-177665624213074SI58	6072324943	Kanjut	0	0	210000	cancelled	premium	6072324943	828	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-20 03:37:23	2026-04-20 03:37:29	D1866726L7P41BLSJ8W7U43	D1866726L7P41BLSJ8W7U43	https://violetmediapay.com/payout.php?D1866726L7P4...	3	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-17766695024555WAZQ4'	STARS-17766695024555WAZQ4	7174723483	violetmediapay	100	272	27200	cancelled	stars	7174723483	971	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-20 07:18:27	2026-04-20 07:18:35	D1866726F66EPT2NFPPPG3L	D1866726F66EPT2NFPPPG3L	https://violetmediapay.com/payout.php?D1866726F66E...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'PREM-17766750683923SVF8F'	PREM-17766750683923SVF8F	138786871	jangannbacot	0	0	210000	failed	premium	138786871	997	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Pembayaran gagal atau expired.	2026-04-20 08:51:25	2026-04-20 09:19:54	D1866726PXXN4EDSFNE3YE6	D1866726PXXN4EDSFNE3YE6	https://violetmediapay.com/payout.php?D1866726PXXN...	3	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-17766793640172UZQBY'	STARS-17766793640172UZQBY	341810197	prafz	50	272	13600	cancelled	stars	341810197	1067	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-20 10:02:45	2026-04-20 10:03:36	D1866726Y4ZC0LN7ECLYM8T	D1866726Y4ZC0LN7ECLYM8T	https://violetmediapay.com/payout.php?D1866726Y4ZC...	NULL	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'PREM-1776685451887EELWP6'	PREM-1776685451887EELWP6	1441228694	jerzzoffc	0	0	210000	cancelled	premium	1441228694	1128	[{"ownerId":"8074885913","chatId":8074885913,"mess...	NULL	Dibatalkan oleh user	2026-04-20 11:44:13	2026-04-20 11:44:19	D1866726N4IAJUB2XTVCJWA	D1866726N4IAJUB2XTVCJWA	https://violetmediapay.com/payout.php?D1866726N4IA...	3	[]
Edit	Copy	Delete DELETE FROM user_orders WHERE `user_orders`.`order_id` = 'STARS-17767056635438A9EAH'	STARS-17767056635438A9EAH	5868696837	mrdonok805	75	272	20400	accepted	stars	5868696837	1243	[{"ownerId":"8074885913","chatId":8074885913,"mess...	c678b976c0aaea54bb6cddb4c2d59ec4864e307c6d6ccf3e70...	NULL	2026-04-20 17:21:04	2026-04-20 17:22:17	D18667264CABHDQKXGUPSGT	D18667264CABHDQKXGUPSGT	https://violetmediapay.com/payout.php?D18667264CAB...	NULL	[]

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view