Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafe »Table: tbl_purchases
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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (11778 total, Query took 0.0029 seconds.) [post_date: 2025-12-31... - 2025-03-15...]
SELECT * FROM `tbl_purchases` ORDER BY `post_date` DESC 
Full texts id_noidhashsupplier_idcrdrdetailstransporttypepost_date Descending Ascending 1post_timestatusMethodPaidBylast_updated
10274 10273 605ff764c617d3cd28dbbdd72be8f9a2 14 123426 123416 10273 127 Pending 2025-12-31 07:00:10 1 From Restaurant Bank From Restaurant Bank
10273 10272 0584ce565c824b7b7f50282d9a19945b 6 3100 3090 10272 0 Pending 2025-12-31 06:53:21 1 From Restaurant Bank From Restaurant Bank
10275 10274 3988c7f88ebcb58c6ce932b957b6f332 19 42510 42500 10274 0 Pending 2025-12-06 07:35:21 1 From Restaurant Bank From Restaurant Bank
11780 11779 7c590f01490190db0ed02a5070e20f01 17 15214 0 11779 0 Pending 2025-03-15 05:44:52 1 Pending
11779 11778 192fc044e74dffea144f9ac5dc9f3395 28 10760 0 11778 0 Pending 2025-03-15 05:39:00 1 Pending
11778 11777 81e74d678581a3bb7a720b019f4f1a93 80 4950 0 11777 0 Pending 2025-03-15 05:37:49 1 Pending
11777 11776 24b16fede9a67c9251d3e7c7161c83ac 80 7600 0 11776 0 Pending 2025-03-15 05:36:47 1 Pending
11776 11775 beb22fb694d513edcf5533cf006dfeae 80 6660 0 11775 0 Pending 2025-03-15 05:34:23 1 Pending
11775 11774 ffeabd223de0d4eacb9a3e6e53e5448d 42 14400 0 11774 0 Pending 2025-03-15 05:30:15 1 Pending
11774 11773 0f840be9b8db4d3fbd5ba2ce59211f55 36 9700 9700 11773 0 Paid 2025-03-15 05:27:57 1 From Restaurant Cash
11773 11772 fe9fc289c3ff0af142b6d3bead98a923 28 11800 11800 11772 0 Paid 2025-03-15 05:21:33 1 From Restaurant Cash
11772 11771 55a7cf9c71f1c9c495413f934dd1a158 28 2500 2500 11771 0 Paid 2025-03-15 05:21:01 1 From Restaurant Cash
11771 11770 ac1dd209cbcc5e5d1c6e28598e8cbbe8 28 4500 4500 11770 0 Paid 2025-03-15 05:19:39 1 From Restaurant Cash
11770 11769 3d8e28caf901313a554cebc7d32e67e5 31 540 540 11769 0 Paid 2025-03-15 05:19:04 1 From Restaurant Cash
11769 11768 c203d8a151612acf12457e4d67635a95 31 540 540 11768 0 Paid 2025-03-15 04:24:45 1 From Restaurant Cash
11768 11767 c042f4db68f23406c6cecf84a7ebb0fe 28 2880 2880 11767 0 Paid 2025-03-15 04:24:25 1 From Restaurant Cash
11767 11766 bd4c9ab730f5513206b999ec0d90d1fb 9 30495 30495 11766 0 Paid 2025-03-15 04:23:58 1 From Restaurant Cash
11766 11765 eecca5b6365d9607ee5a9d336962c534 89 5797 5797 11765 0 Paid 2025-03-15 04:18:31 1 From Restaurant Cash
11765 11764 a666587afda6e89aec274a3657558a27 28 8180 8180 11764 0 Paid 2025-03-15 04:17:51 1 From Restaurant Cash
11764 11763 d96409bf894217686ba124d7356686c9 43 820 820 11763 0 Paid 2025-03-15 04:15:29 1 From Restaurant Cash
11763 11762 3a835d3215755c435ef4fe9965a3f2a0 36 800 800 11762 0 Paid 2025-03-15 04:14:51 1 From Restaurant Cash
11762 11761 0d0871f0806eae32d30983b62252da50 28 2100 2100 11761 0 Paid 2025-03-15 04:13:42 1 From Restaurant Cash
11761 11760 8f468c873a32bb0619eaeb2050ba45d1 34 6763 6763 11760 0 Paid 2025-03-15 04:13:01 1 From Restaurant Cash
11760 11759 6e0721b2c6977135b916ef286bcb49ec 32 2000 2000 11759 0 Paid 2025-03-15 04:12:29 1 From Restaurant Cash
11759 11758 9232fe81225bcaef853ae32870a2b0fe 6 45212 45212 11758 0 Paid 2025-03-15 04:11:01 1 From Restaurant Bank