Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

group lots

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 25, rows affected: 25, absolute service time: 0,16 sec 
edit mode |  history
   id name product_id lot qty parent_id
1 1 Bag 10 1 500 10 5
2 2 Bag 10 1 501 10 5
3 3 Bag 10 1 502 10 6
4 4 Bag 10 1 500 10 6
5 5 Bag 20 1 NULL 20 7
6 6 Bag 20 1 NULL 20 7
7 7 Box 40 1 NULL 40 16
8 8 Bag 10 1 600 10 12
9 9 Bag 10 1 601 10 12
10 10 Bag 10 1 502 10 13
11 11 Bag 10 1 501 10 13
12 12 Bag 20 1 NULL 20 14
13 13 Bag 20 1 NULL 20 14
14 14 Box 40 1 NULL 40 16
15 15 Box 40 1 600 40 16
16 16 Pallet 1 NULL 120 NULL
17 17 Bag 10 2 700 10 19
18 18 Bag 10 2 701 10 19
19 19 Bag 20 2 NULL 20 23
20 20 Bag 10 2 703 10 22
21 21 Bag 10 2 701 10 22
22 22 Bag 20 2 NULL 20 23
23 23 Box 40 2 NULL 40 NULL
   id position container_id
1 1 1 16
2 1 2 23