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 `item_daily_movement_dirty`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id branch_id finance_year_id item_id godown_id item_cat_id valuation_method_used earliest_affected_date reason marked_at
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3742
3742 1 13 553 0 0 DEFAULT 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3743
3743 1 13 553 0 0 FIFO 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3744
3744 1 13 553 0 0 LIFO 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3745
3745 1 13 553 0 0 WAC 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3746
3746 1 13 553 0 0 SIMPLE_AVG 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3747
3747 1 13 553 0 0 STANDARD 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3748
3748 1 13 553 0 0 SPECIFIC 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3749
3749 1 13 553 0 0 RETAIL 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3750
3750 1 13 553 0 0 LOWER_NRV 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3889
3889 1 13 553 2 0 DEFAULT 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3890
3890 1 13 553 2 0 FIFO 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3891
3891 1 13 553 2 0 LIFO 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3892
3892 1 13 553 2 0 WAC 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3893
3893 1 13 553 2 0 SIMPLE_AVG 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3894
3894 1 13 553 2 0 STANDARD 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3895
3895 1 13 553 2 0 SPECIFIC 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3896
3896 1 13 553 2 0 RETAIL 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 3897
3897 1 13 553 2 0 LOWER_NRV 2026-04-01 opening_stock_update 2026-09-19 11:09:23
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 4015
4015 1 13 556 0 0 DEFAULT 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 4016
4016 1 13 556 0 0 FIFO 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 4017
4017 1 13 556 0 0 LIFO 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 4018
4018 1 13 556 0 0 WAC 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 4019
4019 1 13 556 0 0 SIMPLE_AVG 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 4020
4020 1 13 556 0 0 STANDARD 2026-04-01 item_configuration 2026-09-22 18:30:44
Edit Edit Copy Copy Delete Delete
DELETE FROM item_daily_movement_dirty WHERE `item_daily_movement_dirty`.`id` = 4021
4021 1 13 556 0 0 SPECIFIC 2026-04-01 item_configuration 2026-09-22 18:30:44
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