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 `brand` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id item_id item_name unit department category sub_category brand Descending Ascending 1 buyer supplier_id supplier_name last_grn_date last_intercompany_date avg_cost selling_price loc_retail_plastic loc_showroom loc_wholesale_plastic loc_warehouse_1 loc_warehouse_2 loc_warehouse_3 loc_central_warehouse loc_shaharzad_warehouse loc_global_star loc_meena_port loc_delivery_warehouse_bounty loc_tr_in_progress stock_qty stock_value dmg_loc_s_plastic dmg_loc_shop dmg_loc_w1 dmg_loc_w2 dmg_loc_w3 dmg_loc_w4 dmg_stock_qty avg_sale_day opening_qty_3m three_month_sales intercompany_issue_3m adj_prctn_phycnt_3m purchase_3m opening_qty_2m two_month_sales intercompany_issue_2m adj_prctn_phycnt_2m purchase_2m lead_time lead_time_avg balance_stock excess_short_qty excess_short_value slow_qty_3m slow_val_3m slow_qty_2m slow_val_2m
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200512
200512 FRA723 CARDAMOM POWDER UMM MARIYAM 24*250GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CARDAMOM UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-01-19 860.0000 926.0000 0.000 0.708 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.708 608.88 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 0.875 0.167 0.000 0.000 0.000 0.833 0.125 0.000 0.000 0.000 12 0.022 0.708 0.686 589.77 0.708 608.88 0.708 608.88
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200513
200513 FRA725 CHICKEN MASALA UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CHICKEN MASALA UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-10-01 179.0000 187.0000 0.000 1.208 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.208 216.23 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.008 0.958 0.750 0.000 0.000 1.000 0.625 0.417 0.000 0.000 1.000 12 0.100 1.208 1.108 198.33 0.208 37.23 0.208 37.23
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200514
200514 FRA726 CHILLI POWDER UMM MARIYAM 24*300 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CHILLY POWDER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2025-08-03 191.0594 198.0000 0.000 -0.208 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 -0.208 -39.74 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 -0.083 0.125 0.000 0.000 0.000 -0.166 0.042 0.000 0.000 0.000 12 0.017 -0.208 -0.225 -42.92 0.000 0.00 0.000 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200515
200515 FRA728 CINNAMON SLIM UMM MARIYAM 24*150 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CINNAMON UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-04-13 171.0000 178.0000 0.000 0.150 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.150 25.65 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 0.392 0.208 0.000 -0.033 0.000 0.317 0.167 0.000 0.000 0.000 12 0.028 0.150 0.122 20.90 0.150 25.65 0.150 25.65
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200516
200516 FRA729 CLOVES UMM MARIYAM 24*200 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CLOVES UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 323.0364 330.0000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.00 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.005 0.458 0.458 0.000 0.000 0.000 0.333 0.333 0.000 0.000 0.000 12 0.061 0.000 -0.061 -19.74 0.000 0.00 0.000 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200518
200518 FRA731 CORIANDER POWDER UMM MARIYAM 24*200 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CORIANDER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-04-13 104.9456 112.0000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.00 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.013 1.125 1.125 0.000 0.000 0.000 0.708 0.708 0.000 0.000 0.000 12 0.150 0.000 -0.150 -15.74 0.000 0.00 0.000 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200519
200519 FRA732 CORIANDER WHOLE UMM MARIYAM 24*150 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CORIANDER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-10-01 105.0000 116.0000 0.000 1.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.000 105.00 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.000 0.000 0.000 0.000 0.000 1.000 12 0.000 1.000 1.000 105.00 0.000 0.00 0.000 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200520
200520 FRA734 CUMMIN SEED UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CUMMIN UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 207.1200 214.0000 0.000 0.083 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.083 17.26 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.005 0.959 0.458 0.000 0.000 0.000 0.834 0.333 0.000 0.000 0.000 12 0.061 0.083 0.022 4.60 0.083 17.19 0.083 17.19
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200521
200521 FRA736 BLACK LEMON POWDER UMM MARIYAM 24*225 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES BLACK LEMON UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 186.9600 194.0000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.00 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 0.333 0.333 0.000 0.000 0.000 0.125 0.125 0.000 0.000 0.000 12 0.044 0.000 -0.044 -8.31 0.000 0.00 0.000 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200522
200522 FRA737 FENNEL SEED UMM MARIYAM 24*200GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES FENNEL SEED UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 102.7135 110.0000 0.000 0.292 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.292 29.99 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 0.667 0.125 0.000 0.000 0.000 0.667 0.125 0.000 0.000 0.000 12 0.017 0.292 0.275 28.28 0.292 29.99 0.292 29.99
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200523
200523 FRA738 FENUGREEK UMM MARIYAM 24*400 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES GARAM MASALA UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-04-13 122.8649 130.0000 0.000 0.917 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.917 112.67 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 1.209 0.292 0.000 0.000 0.000 1.084 0.167 0.000 0.000 0.000 12 0.039 0.917 0.878 107.89 0.917 112.67 0.917 112.67
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200524
200524 FRA739 FISH MASALA UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES FISH MASALA UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-04-13 159.9992 170.0000 0.000 0.041 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.041 6.61 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.008 0.792 0.750 0.000 0.000 0.000 0.250 0.208 0.000 0.000 0.000 12 0.100 0.041 -0.059 -9.39 0.041 6.56 0.041 6.56
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200525
200525 FRA740 GARAM MASALA POWDER UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES GARAM MASALA UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 202.0000 210.0000 0.000 0.833 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.833 168.33 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.007 1.458 0.625 0.000 0.000 0.000 1.333 0.500 0.000 0.000 0.000 12 0.083 0.833 0.750 151.50 0.833 168.27 0.833 168.27
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200526
200526 FRA742 GARLIC POWDER UMM MARIYAM 24*350GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES GARLIC POWDER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 157.9201 163.0000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.00 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 0.334 0.333 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 12 0.044 0.000 -0.044 -7.02 0.000 0.00 0.000 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200527
200527 FRA744 KASHMIRI CHILLI POWDER UMM MARIYAM 24*270 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES CHILLY POWDER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-04-13 263.0000 290.0000 0.000 1.083 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.083 284.83 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 1.541 0.375 0.000 0.000 0.000 1.416 0.250 0.000 0.000 0.000 12 0.050 1.083 1.033 271.68 1.083 284.83 1.083 284.83
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200528
200528 FRA747 BAHRAINI MIX MASALA UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES BIRIYANI MASALA UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-04-13 168.0000 175.0000 0.000 0.083 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.083 13.94 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.083 0.000 0.000 0.000 0.000 0.083 0.000 0.000 0.000 0.000 12 0.000 0.083 0.083 13.94 0.083 13.94 0.083 13.94
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200529
200529 FRA749 MUTTON MASALA UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES MUTTON MASALA UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 173.0270 180.0000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.00 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 0.455 0.125 0.000 0.000 0.000 0.330 0.000 0.000 0.000 0.000 12 0.017 0.000 -0.017 -2.88 0.000 0.00 0.000 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200530
200530 FRA750 PAPRIKA POWDER UMM MARIYAM 24*225 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES PAPRIKA POWDER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 169.9713 178.0000 0.000 0.875 0.000 0.000 0.042 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.917 155.81 0.000 0.000 0.000 0.167 0.000 0.000 0.167 0.000 1.042 0.000 0.000 0.042 0.000 1.083 0.000 0.000 0.000 0.000 12 0.000 0.917 0.917 155.81 0.917 155.86 0.917 155.86
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200531
200531 FRA753 SUMAC UMM MARIYAM 24*300 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES SEASONING & SPICE POWDER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 277.9200 288.0000 0.000 0.750 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.750 208.35 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 0.917 0.167 0.000 0.000 0.000 0.917 0.167 0.000 0.000 0.000 12 0.022 0.750 0.727 202.17 0.750 208.44 0.750 208.44
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200532
200532 FRA754 TANDOORI MASALA UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES TANDOORI MASALA UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 163.6878 170.0000 0.000 0.667 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.667 109.13 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.011 1.666 1.000 0.000 0.000 0.000 1.208 0.542 0.000 0.000 0.000 12 0.133 0.667 0.533 87.30 0.666 109.02 0.666 109.02
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200533
200533 FRA755 THYME POWDER UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES SEASONING & SPICE POWDER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 157.7097 163.0000 0.000 0.833 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.833 131.37 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 1.041 0.208 0.000 0.000 0.000 1.041 0.208 0.000 0.000 0.000 12 0.028 0.833 0.805 126.99 0.833 131.37 0.833 131.37
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200534
200534 FRA756 TURMERIC POWDER UMM MARIYAM 24*250 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES TURMERIC UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-04-13 141.0000 146.0000 0.000 0.041 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.041 5.83 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.375 0.042 0.000 0.000 0.000 0.333 0.000 0.000 0.000 0.000 12 0.006 0.041 0.036 5.04 0.041 5.78 0.041 5.78
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200535
200535 FRA757 WHITE PEPPER POWDER UMM MARIYAM 24*330 GM CTN GROCERY FOOD FOOD SPICES & ADDITIVES WHITE PEPPER UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-10-01 302.0000 312.0000 0.000 1.458 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.458 440.42 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.008 1.500 0.708 0.000 0.000 1.000 1.208 0.417 0.000 0.000 1.000 12 0.094 1.458 1.364 411.89 0.792 239.18 0.792 239.18
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 200536
200536 FRA758 ZAATAR LEAF UMM MARIYAM 24*60 GM CTN GROCERY FOOD PULSES,SEEDS & LEAVES ZATHAR UMM MARIYAM BUYER 3 A11293 MASHRIQ AL DAHBIYA NULL 2026-07-12 235.8517 248.0000 0.000 1.333 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.333 314.47 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 1.667 0.333 0.000 0.000 0.000 1.375 0.042 0.000 0.000 0.000 12 0.044 1.333 1.289 303.99 1.333 314.39 1.333 314.39
Edit Edit Copy Copy Delete Delete
DELETE FROM items WHERE `items`.`id` = 198542
198542 AS701 THYME LEAVES FRESHLY 6* 200-GM (7oz) CTN GROCERY FOOD FOOD SPICES & ADDITIVES SEASONING & SPICE POWDER UMM MARIYAM BUYER 3 A118 ORIENT PROVISION&TRADING CO.,LTD(OPTC) 2026-08-29 NULL 115.0000 125.0000 0.000 4.500 0.000 0.000 8.167 0.000 0.000 0.000 0.000 0.000 0.000 0.000 12.667 1456.67 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.148 0.000 13.333 0.000 0.000 26.000 8.333 11.667 0.000 0.000 16.000 12 1.778 12.667 10.889 1252.22 0.000 0.00 0.000 0.00
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