train: blocker: 8 rows where train

8 rows where train_id = 148

descending

id ▼	train_id	blocked	unblocked	blocker	unblocker	removed	resolved	task	url	status	group_blocked	group_unblocked
51	148 148	1620953783	1620962229	AntiCompositeNumber	James D. Forrester	0	1	282844	https://phabricator.wikimedia.org/T282844	resolved	1	1
52	148 148	1620941677	1620962797	Ahmon Dancy	James D. Forrester	0	1	282833	https://phabricator.wikimedia.org/T282833	resolved	1	1
53	148 148	1620941947	1620962178	Ahmon Dancy	James D. Forrester	0	1	282834	https://phabricator.wikimedia.org/T282834	resolved	1	1
54	148 148	1620846666	1620941300	Ahmon Dancy	Ahmon Dancy	0	1	282735	https://phabricator.wikimedia.org/T282735	resolved	0	1
55	148 148	1620797785	1620845274	Legoktm	Jon Robson	1	0	282646	https://phabricator.wikimedia.org/T282646	resolved	0	0
56	148 148	1620666571	1620692677	Urbanecm	Ahmon Dancy	0	1	282206	https://phabricator.wikimedia.org/T282206	resolved	-1	-1
57	148 148	1620359734	1620688237	Timo Tijhof	James D. Forrester	0	1	282207	https://phabricator.wikimedia.org/T282207	resolved	-1	-1
58	148 148	1620239172	1620341549	Eric Gardner	Timo Tijhof	1	1	282038	https://phabricator.wikimedia.org/T282038	resolved	-1	-1

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE blocker (
            id INTEGER PRIMARY KEY,
            train_id INTEGER NOT NULL,
            blocked INTEGER NOT NULL,
            unblocked INTEGER,
            blocker TEXT NOT NULL,
            unblocker TEXT,
            removed INTEGER NOT NULL,
            resolved INTEGER NOT NULL,
            task INTEGER NOT NULL,
            url TEXT NOT NULL,
            status TEXT NOT NULL,
            group_blocked INTEGER NOT NULL,
            group_unblocked INTEGER,
            CHECK (removed IN (0, 1))
            CHECK (resolved IN (0, 1))
            UNIQUE(train_id,blocked,task)
            FOREIGN KEY(train_id) REFERENCES train(id)
        );