Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafelahore »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
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 (19477 total, Query took 0.0071 seconds.)
SELECT * FROM `tbl_sup_payments`
Full texts idbill_idsupplier_iddrcrbalancedescriptionMethodPaidBypost_datepost_timestatuslast_updated
1 6189 1 0.00 2200.00 0.00 Purchase ID: 6189 - 4.000 Pcs of Egg SB (Tray) Pending 2024-06-26 02:20:24 1
2 6189 1 2200.00 0.00 0.00 Restaurant - Cash 2024-06-26 03:09:38 1 1719396578
3 6190 1 375.00 375.00 0.00 Purchase ID: 6190 - 25.000 Pcs of Roti From Restaurant Cash 2024-06-27 10:17:39 1
4 6191 4 2400.00 2400.00 0.00 Purchase ID: 6191 - 3.000 Pcs of Zip Bag (L) From Restaurant Cash 2024-06-27 10:21:53 1
5 6192 5 7445.00 7445.00 0.00 Purchase ID: 6192 - 2.000 Pack of Oppa fries From Restaurant Cash 2024-06-27 10:24:01 1
6 6193 4 3700.00 3700.00 0.00 Purchase ID: 6193 - 6.000 Pcs of Cling Film From Restaurant Cash 2024-06-27 10:25:52 1
7 6194 6 3600.00 3600.00 0.00 Purchase ID: 6194 - 18.000 Kg of Ice Cubes From Restaurant Cash 2024-06-27 10:28:14 1
8 6195 7 0.00 6000.00 0.00 Purchase ID: 6195 - 240.000 Kg of Wood Pending 2024-06-27 10:30:12 1
9 6195 7 2000.00 0.00 4000.00 From Restaurant Cash 2024-06-27 10:30:49 1 1719466249
10 6195 7 4000.00 0.00 0.00 From Restaurant Cash 2024-06-27 10:31:12 1 1719466272
11 6196 8 4609.00 4609.00 0.00 Purchase ID: 6196 - 1.000 Pcs of Pomelo (Bottle) From Restaurant Cash 2024-06-27 10:34:36 1
12 6197 4 1600.00 1600.00 0.00 Purchase ID: 6197 - 500.000 Gram of Dried Figs From Restaurant Cash 2024-06-27 10:35:12 1
13 6198 9 5442.00 5442.00 0.00 Purchase ID: 6198 - 4.000 Pack of Oppa fries From Restaurant Cash 2024-06-27 10:37:06 1
14 6199 4 1050.00 1050.00 0.00 Purchase ID: 6199 - 500.000 Gram of Walnut From Restaurant Cash 2024-06-27 10:37:55 1
15 6200 10 1020.00 1020.00 0.00 Purchase ID: 6200 - 1.000 Pcs of Agar Agar From Restaurant Cash 2024-06-27 10:40:11 1
16 6200 10 1900.00 1900.00 0.00 Purchase ID: 6200 - 5.000 Kg of Puff Pastry From Restaurant Cash 2024-06-27 10:40:11 1
17 6201 12 0.00 47600.00 0.00 Purchase ID: 6201 - 4.000 Pcs of Gas Cylinder (Lar... Pending 2024-06-27 12:11:02 1
18 6202 13 0.00 13500.00 0.00 Purchase ID: 6202 - 1.000 Pcs of Dishwash Liquid (... Pending 2024-06-27 12:13:23 1
19 6203 3 0.00 870.00 0.00 Purchase ID: 6203 - 58.000 Pcs of Roti Pending 2024-06-27 12:14:12 1
20 6204 14 0.00 6750.00 0.00 Purchase ID: 6204 - 3.000 Kg of Red Snapper Fillet Pending 2024-06-27 12:19:01 1
21 6204 14 0.00 11000.00 0.00 Purchase ID: 6204 - 5.000 Kg of Squid Pending 2024-06-27 12:19:01 1
22 6205 4 0.00 1440.00 0.00 Purchase ID: 6205 - 8.000 Pcs of Condensed milk (T... Pending 2024-06-27 12:20:19 1
23 6206 4 0.00 1280.00 0.00 Purchase ID: 6206 - 1.500 Kg of Apple Pending 2024-06-27 12:23:28 1
24 6206 4 0.00 350.00 0.00 Purchase ID: 6206 - 14.000 Pcs of Roti Pending 2024-06-27 12:23:28 1
25 6207 15 0.00 340.00 0.00 Purchase ID: 6207 - 7.000 Pcs of Roti Pending 2024-06-27 12:24:37 1