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
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 (14628 total, Query took 0.0780 seconds.) [bill_id: 11463... - 11452...]
SELECT * FROM `tbl_sup_payments` ORDER BY `bill_id`  DESC 
Full texts idbill_id Descending Ascending 1supplier_iddrcrbalancedescriptionMethodPaidBypost_datepost_timestatuslast_updated
14693 11463 6 3000.00 3000.00 0.00 Purchase ID: 11463 - 5.000 Kg of Ice Cubes From Restaurant Cash 2025-03-15 02:42:35 1
14692 11462 4 1200.00 1200.00 0.00 Purchase ID: 11462 - 1.000 1 of Fruits From Restaurant Cash 2025-03-15 02:42:23 1
14691 11461 22 0.00 23760.00 0.00 Purchase ID: 11461 - 24.000 Pcs of Golden Cooking ... Pending 2025-03-15 02:42:00 1
14689 11460 35 0.00 2800.00 0.00 Purchase ID: 11460 - 1.000 Kg of Prawns Pending 2025-03-15 02:41:39 1
14690 11460 35 0.00 14400.00 0.00 Purchase ID: 11460 - 1.600 1 of Pink Salmon Pending 2025-03-15 02:41:39 1
14688 11459 27 0.00 28327.00 0.00 Purchase ID: 11459 - 4.884 Pcs of Parmesan Cheese ... Pending 2025-03-15 02:39:35 1
14687 11458 1 0.00 3300.00 0.00 Purchase ID: 11458 - 3.000 Kg of Chicken thigh Pending 2025-03-15 02:38:55 1
14686 11457 85 0.00 440.00 0.00 Purchase ID: 11457 - 4.000 Ltr of Water Pending 2025-03-15 02:38:38 1
14684 11456 68 0.00 600.00 0.00 Purchase ID: 11456 - 3.000 Kg of Yogurt Pending 2025-03-15 02:38:23 1
14685 11456 68 0.00 1490.00 0.00 Purchase ID: 11456 - 8.000 Ltr of Milk Pending 2025-03-15 02:38:23 1
14683 11455 68 0.00 450.00 0.00 Purchase ID: 11455 - 2.500 Ltr of Milk Pending 2025-03-15 02:37:33 1
14682 11454 68 0.00 810.00 0.00 Purchase ID: 11454 - 4.500 Ltr of Milk Pending 2025-03-15 02:37:10 1
14679 11453 94 0.00 1550.00 0.00 Purchase ID: 11453 - 1.000 Pcs of Harpic Blue Pending 2025-03-15 02:36:43 1
14678 11453 94 0.00 450.00 0.00 Purchase ID: 11453 - 1.000 Pcs of Kiwi Wood Polish Pending 2025-03-15 02:36:43 1
14680 11453 94 0.00 250.00 0.00 Purchase ID: 11453 - 1.000 Pcs of Aluminium File Pending 2025-03-15 02:36:43 1
14681 11453 94 0.00 400.00 0.00 Purchase ID: 11453 - 2.000 Pack of Hair Net Pending 2025-03-15 02:36:43 1
14672 11452 9 0.00 2640.00 0.00 Purchase ID: 11452 - 12.000 P of Milk Pack Cream Pending 2025-03-15 02:35:44 1
14668 11452 9 0.00 1100.00 0.00 Purchase ID: 11452 - 1.000 Pcs of Soy sauce (Bottl... Pending 2025-03-15 02:35:44 1
14666 11452 9 0.00 1800.00 0.00 Purchase ID: 11452 - 4.000 1 of Dates Pending 2025-03-15 02:35:44 1
14671 11452 9 0.00 380.00 0.00 Purchase ID: 11452 - 1.000 Pack of Brown sugar (Mo... Pending 2025-03-15 02:35:44 1
14667 11452 9 0.00 650.00 0.00 Purchase ID: 11452 - 1.000 Pcs of A.G Apple Cider ... Pending 2025-03-15 02:35:44 1
14675 11452 9 0.00 210.00 0.00 Purchase ID: 11452 - 3.000 Kg of Salt Pending 2025-03-15 02:35:44 1
14674 11452 9 0.00 2250.00 0.00 Purchase ID: 11452 - 5.000 Pack of Penny Pasta Pending 2025-03-15 02:35:44 1
14670 11452 9 0.00 1120.00 0.00 Purchase ID: 11452 - 2.000 Ltr of Cooking Oil Pending 2025-03-15 02:35:44 1
14673 11452 9 0.00 1700.00 0.00 Purchase ID: 11452 - 5.000 Kg of Green Peas Pending 2025-03-15 02:35:44 1