SHOW:
|
|
- or go back to the newest paste.
| 1 | order | |
| 2 | id model amount preprint void | |
| 3 | 1 20 20 0 0 | |
| 4 | 2 21 30 0 0 | |
| 5 | ||
| 6 | model | |
| 7 | no partno | |
| 8 | 20 testmodel20 | |
| 9 | 21 testmodel21 | |
| 10 | ||
| 11 | serials | |
| 12 | sn order user | |
| 13 | test1 1 1 | |
| 14 | test2 1 1 | |
| 15 | test3 1 1 | |
| 16 | test4 2 1 | |
| 17 | - | test5 2 1 |
| 17 | + | test5 2 0 |
| 18 | ||
| 19 | ||
| 20 | ||
| 21 | alles | |
| 22 | id partno count amount preprint void | |
| 23 | 1 testmodel20 3 20 0 0 | |
| 24 | - | 2 testmodel21 2 30 0 0 |
| 24 | + | 2 testmodel21 1 30 0 0 |
| 25 | ||
| 26 | count: serials.order = order.id AND serials.user <> 0 |
