Drop files here

SQL upload ( 0 ) x -

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.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `items` ORDER BY `valuation_method` ASC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id item_name alias_name item_code packing packing_numbers item_type1 hsn_sac_id ledger_id item_cat_id godown_id uom_id alternative_uom_id brand_id company_id item_type valuation_method Ascending Descending 1 standard_cost price_basis mrp alternative_value profit_logic price_type profit_value price
sale_price
average_price last_purchase_price purchase_price sale_price_delete tax_rate stock_quantity opening_value max_qty min_qty reorder_days low_stock_alert is_subsidy_item is_edit_mrp show_without_stock branch_id_deleted item_name_key name_norm aliases_norm delete_status_deleted created_by modified_by created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 768
768 DHONI P6 SS DHONI P6 SS Number PART 14810 0 7 0 1 0 1 0 GOODS 0.00 BASE 2200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 10000 0 0 N Y Y 0 DHONIP6SS dhonip6ss NULL 0 0 0 2026-07-08 13:33:08 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1024
1024 angle grinder GWS 800 angle grinder GWS 800 PART 18174 0 24 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-03 17:21:37 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 769
769 DHONI P10 SS DHONI P10 SS Number PART 14810 0 33 0 1 0 1 0 GOODS 0.00 BASE 3500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 10000 0 0 N Y Y 0 DHONIP10SS dhonip10ss NULL 0 0 0 2026-07-08 13:36:54 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1025
1025 Cut Off Saw Cut Off Saw PART 18172 0 24 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-03 17:24:03 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 770
770 P8 SCREW P8 SCREW P8SCREW8FFET Number PART 17271 0 24 0 1 0 1 0 GOODS 0.00 BASE 14000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 10000 0 0 N Y Y 0 P8SCREW p8screw NULL 0 0 0 2026-07-08 14:29:11 2026-07-21 13:36:34
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1026
1026 LED 200 Watt Floudin LED 200 Watt Floudin PART 21257 0 8 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 10:33:48 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1027
1027 Leaf 2mm SS Leaf 2mm SS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 12:41:25 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1028
1028 40 Tin Inner Draw 2mm SS 40 Tin Inner Draw 2mm SS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 12:45:46 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 773
773 3" PULLY 1.25" BORE 3" PULLY 1.25" BORE Number PART 18514 0 15 0 1 0 1 0 GOODS 0.00 BASE 525.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 50 0 0 N Y N 0 3PULLY125BORE 3pully125bore NULL 0 0 2 2026-07-10 13:26:30 2026-09-11 12:19:35
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1029
1029 Yashas Spanner 10mm MS Yashas Spanner 10mm MS PART 14725 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 12:49:29 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 774
774 P8 SS DHONI P8 SS DHONI Number PART 15050 0 33 0 1 0 1 0 GOODS 0.00 BASE 4500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 P8SSDHONI p8ssdhoni NULL 0 0 0 2026-07-10 13:46:48 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1030
1030 Grabalu Draw Door 1.5mm GI Grabalu Draw Door 1.5mm GI PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 15:37:04 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 775
775 12" PULLY 1.25" BORE 12" PULLY 1.25" BORE Number PART 18514 0 15 0 1 0 1 0 GOODS 0.00 BASE 1175.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 12PULLY125BORE 12pully125bore NULL 0 0 0 2026-07-10 13:57:02 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1031
1031 Logo Sheet Big 1.5mm SS Logo Sheet Big 1.5mm SS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 15:41:32 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 776
776 P10 SCREW 10 FEET P10 SCREW 10 FEET Number PART 14810 0 33 0 1 0 1 0 GOODS 0.00 BASE 20000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 P10SCREW10FEET p10screw10feet NULL 0 0 0 2026-07-10 14:03:32 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1032
1032 Gear Box Plate 6MM MS Gear Box Plate 6MM MS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 15:46:45 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1033
1033 Round Plate 6mm MS Round Plate 6mm MS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 15:49:20 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 778
778 J MALE CONNECTOR 10X1/4 WP211061 J MALE CONNECTOR 10X1/4 WP211061 PART 18556 0 19 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N N N 0 JMALECONNECTOR10X14WP211061 jmaleconnector10x14wp211061 NULL 0 0 0 2026-07-11 13:29:09 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1034
1034 Conveyor Pipe Ring Plate Conveyor Pipe Ring Plate PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 15:52:28 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1035
1035 40x40 Dummy Piece 2mm MS 40x40 Dummy Piece 2mm MS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N N N 0 0 2 0 2026-09-04 15:55:55 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 780
780 P4 SS DHONI P4 SS DHONI Number PART 14810 0 33 0 1 0 1 0 GOODS 0.00 BASE 4000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 P4SSDHONI p4ssdhoni NULL 0 0 0 2026-07-13 11:00:23 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1036
1036 Sippy Conveyor Inner Front 2mm MS Sippy Conveyor Inner Front 2mm MS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 17:25:56 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1037
1037 Sippy Conveyor Back 2mm MS Sippy Conveyor Back 2mm MS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 2 2026-09-04 17:27:37 2026-09-04 17:28:25
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1038
1038 Sippy Conveyor outer Back 2mm MS Sippy Conveyor outer Back 2mm MS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 17:30:01 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 1039
1039 Sippy Conveyor outer front 2mm MS Sippy Conveyor outer front 2mm MS PART 14808 0 7 0 1 0 0 0 GOODS 0.00 BASE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 N Y N 0 0 2 0 2026-09-04 17:31:17 NULL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query