add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
8.0.27
id status_from status_to logtime refno
1 Let Action 2021-06-01 00:00:00 LP01
2 Action Draft 2021-10-01 00:00:00 LP01
3 Draft Publish 2021-10-02 00:00:00 LP01
4 Action Let 2021-10-06 00:00:00 LP06
id status added_date updated_date refno logstat stat20211001
3 Y 2021-05-02 00:00:00 2021-10-02 00:00:00 LP01 Action Action
4 A 2021-05-01 00:00:00 2021-05-01 00:00:00 LP02 null Action
5 S 2020-10-01 00:00:00 2020-10-01 00:00:00 LP03 null Sold
6 N 2021-05-01 00:00:00 2021-10-06 00:00:00 LP06 Action Action
11 D 2021-01-01 00:00:00 2021-01-01 00:00:00 LP04 null Draft
status COUNT(t2.stat20211001)
Draft 1
Action 3
Publish 0
Sold 1
Let 0