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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
item_id varchar(50) utf8mb4_general_ci
item_name varchar(255) utf8mb4_general_ci
unit varchar(20) utf8mb4_general_ci
department varchar(100) utf8mb4_general_ci
category varchar(150) utf8mb4_general_ci
sub_category varchar(150) utf8mb4_general_ci
brand varchar(150) utf8mb4_general_ci
buyer varchar(100) utf8mb4_general_ci
supplier_id varchar(50) utf8mb4_general_ci
supplier_name varchar(255) utf8mb4_general_ci
last_grn_date date
last_intercompany_date date
avg_cost decimal(14,4)
selling_price decimal(14,4)
loc_retail_plastic decimal(14,3)
loc_showroom decimal(14,3)
loc_wholesale_plastic decimal(14,3)
loc_warehouse_1 decimal(14,3)
loc_warehouse_2 decimal(14,3)
loc_warehouse_3 decimal(14,3)
loc_central_warehouse decimal(14,3)
loc_shaharzad_warehouse decimal(14,3)
loc_global_star decimal(14,3)
loc_meena_port decimal(14,3)
loc_delivery_warehouse_bounty decimal(14,3)
loc_tr_in_progress decimal(14,3)
stock_qty decimal(14,3)
stock_value decimal(16,2)
dmg_loc_s_plastic decimal(14,3)
dmg_loc_shop decimal(14,3)
dmg_loc_w1 decimal(14,3)
dmg_loc_w2 decimal(14,3)
dmg_loc_w3 decimal(14,3)
dmg_loc_w4 decimal(14,3)
dmg_stock_qty decimal(14,3)
avg_sale_day decimal(10,3)
opening_qty_3m decimal(14,3)
three_month_sales decimal(14,3)
intercompany_issue_3m decimal(14,3)
adj_prctn_phycnt_3m decimal(14,3)
purchase_3m decimal(14,3)
opening_qty_2m decimal(14,3)
two_month_sales decimal(14,3)
intercompany_issue_2m decimal(14,3)
adj_prctn_phycnt_2m decimal(14,3)
purchase_2m decimal(14,3)
lead_time int(11)
lead_time_avg decimal(14,3)
balance_stock decimal(14,3)
excess_short_qty decimal(14,3)
excess_short_value decimal(16,2)
slow_qty_3m decimal(14,3)
slow_val_3m decimal(24,2)
slow_qty_2m decimal(14,3)
slow_val_2m decimal(24,2)
is_zero_sale int(1)
recent_30 int(1)
is_oos int(1)
is_excess int(1)
is_shortage int(1)
is_damage int(1)
is_slow_3m int(1)
is_slow_2m int(1)
wh_total_qty decimal(22,3)
dmg_calc_total_qty decimal(19,3)