Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafe »Table: tbl_sup_payments
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 (27550 total, Query took 0.0361 seconds.) [post_date: 2025-12-31... - 2025-03-15...]
SELECT * FROM `tbl_sup_payments` ORDER BY `post_date` DESC 
Full texts idbill_idsupplier_iddrcrbalancedescriptionMethodPaidBypost_date Descending Ascending 1post_timestatuslast_updated
23844 10273 14 0.00 59714.00 0.00 Purchase ID: 10273 - 3.000 Pack of Cocoa powder (d... Pending 2025-12-31 07:00:10 1
23843 10273 14 0.00 39520.00 0.00 Purchase ID: 10273 - 8.000 Kg of Chocobourne - Ext... Pending 2025-12-31 07:00:10 1
23842 10273 14 0.00 7080.00 0.00 Purchase ID: 10273 - 1.000 Kg of Chocobourne white... Pending 2025-12-31 07:00:10 1
23841 10273 14 0.00 1550.00 0.00 Purchase ID: 10273 - 2.000 Pcs of Red Vibgyor Food... Pending 2025-12-31 07:00:10 1
23840 10273 14 0.00 1462.00 0.00 Purchase ID: 10273 - 2.000 Pcs of White Vibgyor Fo... Pending 2025-12-31 07:00:10 1
23839 10273 14 0.00 14100.00 0.00 Purchase ID: 10273 - 60.000 Kg of Caster sugar (Su... Pending 2025-12-31 07:00:10 1
23838 10272 6 0.00 3100.00 0.00 Purchase ID: 10272 - 5.000 Pack of Eka Powder Pending 2025-12-31 06:53:21 1
23845 10274 19 0.00 42510.00 0.00 Purchase ID: 10274 - 1.000 Pcs of Scaner Pending 2025-12-06 07:35:21 1
27557 11779 17 0.00 6444.00 0.00 Purchase ID: 11779 - 1.000 MainSection of Vegetabl... Pending 2025-03-15 05:44:52 1
27556 11779 17 0.00 4870.00 0.00 Purchase ID: 11779 - 1.000 Staff of Vegetables Pending 2025-03-15 05:44:52 1
27555 11779 17 0.00 1780.00 0.00 Purchase ID: 11779 - 1.000 PastrySection of Vegeta... Pending 2025-03-15 05:44:52 1
27554 11779 17 0.00 2120.00 0.00 Purchase ID: 11779 - 1.000 BarSection of Vegetable... Pending 2025-03-15 05:44:52 1
27553 11778 28 0.00 10760.00 0.00 Purchase ID: 11778 - 25.000 Kg of Puff Pastry Pending 2025-03-15 05:39:00 1
27552 11777 80 0.00 1480.00 0.00 Purchase ID: 11777 - 4.000 Pcs of Kitchen Tissue R... Pending 2025-03-15 05:37:49 1
27551 11777 80 0.00 1180.00 0.00 Purchase ID: 11777 - 2.000 Pcs of Cling Film Pending 2025-03-15 05:37:49 1
27550 11777 80 0.00 740.00 0.00 Purchase ID: 11777 - 2.000 Pcs of Kitchen Tissue R... Pending 2025-03-15 05:37:49 1
27549 11777 80 0.00 1000.00 0.00 Purchase ID: 11777 - 2.000 Pcs of Kiwi Wood Polish Pending 2025-03-15 05:37:49 1
27548 11777 80 0.00 550.00 0.00 Purchase ID: 11777 - 5.000 Pack of Straws Black Pending 2025-03-15 05:37:49 1
27547 11776 80 0.00 1480.00 0.00 Purchase ID: 11776 - 4.000 Pcs of Kitchen Tissue R... Pending 2025-03-15 05:36:47 1
27546 11776 80 0.00 1160.00 0.00 Purchase ID: 11776 - 2.000 Pcs of Cling Film Pending 2025-03-15 05:36:47 1
27545 11776 80 0.00 740.00 0.00 Purchase ID: 11776 - 2.000 Pcs of Kitchen Tissue R... Pending 2025-03-15 05:36:47 1
27544 11776 80 0.00 580.00 0.00 Purchase ID: 11776 - 1.000 Pcs of Cling Film Pending 2025-03-15 05:36:47 1
27543 11776 80 0.00 1000.00 0.00 Purchase ID: 11776 - 2.000 Pcs of Kiwi Wood Polish Pending 2025-03-15 05:36:47 1
27542 11776 80 0.00 700.00 0.00 Purchase ID: 11776 - 1.000 Pcs of Piping Bag (Larg... Pending 2025-03-15 05:36:47 1
27541 11776 80 0.00 1200.00 0.00 Purchase ID: 11776 - 5.000 Pack of Napkin Tissue Pending 2025-03-15 05:36:47 1