SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tbl(text TEXT, ind INTEGER, sentid INTEGER)
✓
BEGIN TRANSACTION;INSERT INTO tbl VALUES ('b','0','0');INSERT INTO tbl VALUES ('e','1','0');INSERT INTO tbl VALUES ('c','2','0');INSERT INTO tbl VALUES ('c','3','0');INSERT INTO tbl VALUES ('a','4','0');INSERT INTO tbl VALUES ('a','5','0');INSERT INTO tbl VALUES ('d','6','0');INSERT INTO tbl VALUES ('b','0','1');INSERT INTO tbl VALUES ('d','1','1');INSERT INTO tbl VALUES ('c','2','1');INSERT INTO tbl VALUES ('e','3','1');INSERT INTO tbl VALUES ('a','4','1');INSERT INTO tbl VALUES ('c','5','1');INSERT INTO tbl VALUES ('a','6','1');INSERT INTO tbl VALUES ('c','0','2');INSERT INTO tbl VALUES ('a','1','2');INSERT INTO tbl VALUES ('b','2','2');INSERT INTO tbl VALUES ('a','3','2');INSERT INTO tbl VALUES ('e','4','2');INSERT INTO tbl VALUES ('d','5','2');INSERT INTO tbl VALUES ('c','6','2');INSERT INTO tbl VALUES ('d','0','3');INSERT INTO tbl VALUES ('c','1','3');INSERT INTO tbl VALUES ('a','2','3');INSERT INTO tbl VALUES ('c','3','3');INSERT INTO tbl VALUES ('a','4','3');INSERT INTO tbl VALUES ('e','5','3');INSERT INTO tbl VALUES ('b','6','3');INSERT INTO tbl VALUES ('c','0','4');INSERT INTO tbl VALUES ('a','1','4');INSERT INTO tbl VALUES ('d','2','4');INSERT INTO tbl VALUES ('c','3','4');INSERT INTO tbl VALUES ('a','4','4');INSERT INTO tbl VALUES ('b','5','4');INSERT INTO tbl VALUES ('e','6','4');INSERT INTO tbl VALUES ('c','0','5');INSERT INTO tbl VALUES ('b','1','5');INSERT INTO tbl VALUES ('c','2','5');INSERT INTO tbl VALUES ('e','3','5');INSERT INTO tbl VALUES ('d','4','5');INSERT INTO tbl VALUES ('a','5','5');INSERT INTO tbl VALUES ('a','6','5');INSERT INTO tbl VALUES ('d','0','6');INSERT INTO tbl VALUES ('a','1','6');INSERT INTO tbl VALUES ('c','2','6');INSERT INTO tbl VALUES ('c','3','6');INSERT INTO tbl VALUES ('b','4','6');INSERT INTO tbl VALUES ('a','5','6');INSERT INTO tbl VALUES ('e','6','6');INSERT INTO tbl VALUES ('d','0','7');INSERT INTO tbl VALUES ('c','1','7');INSERT INTO tbl VALUES ('a','2','7');INSERT INTO tbl VALUES ('a','3','7');INSERT INTO tbl VALUES ('e','4','7');INSERT INTO tbl VALUES ('c','5','7');INSERT INTO tbl VALUES ('b','6','7');INSERT INTO tbl VALUES ('e','0','8');INSERT INTO tbl VALUES ('c','1','8');INSERT INTO tbl VALUES ('b','2','8');INSERT INTO tbl VALUES ('d','3','8');INSERT INTO tbl VALUES ('a','4','8');INSERT INTO tbl VALUES ('c','5','8');INSERT INTO tbl VALUES ('a','6','8');INSERT INTO tbl VALUES ('a','0','9');INSERT INTO tbl VALUES ('c','1','9');INSERT INTO tbl VALUES ('a','2','9');INSERT INTO tbl VALUES ('e','3','9');INSERT INTO tbl VALUES ('b','4','9');INSERT INTO tbl VALUES ('c','5','9');INSERT INTO tbl VALUES ('d','6','9');INSERT INTO tbl VALUES ('d','0','10');INSERT INTO tbl VALUES ('a','1','10');INSERT INTO tbl VALUES ('e','2','10');INSERT INTO tbl VALUES ('a','3','10');INSERT INTO tbl VALUES ('c','4','10');INSERT INTO tbl VALUES ('b','5','10');INSERT INTO tbl VALUES ('c','6','10');INSERT INTO tbl VALUES ('c','0','11');INSERT INTO tbl VALUES ('b','1','11');INSERT INTO tbl VALUES ('a','2','11');INSERT INTO tbl VALUES ('d','3','11');INSERT INTO tbl VALUES ('c','4','11');INSERT INTO tbl VALUES ('e','5','11');INSERT INTO tbl VALUES ('a','6','11');INSERT INTO tbl VALUES ('d','0','12');INSERT INTO tbl VALUES ('b','1','12');INSERT INTO tbl VALUES ('a','2','12');INSERT INTO tbl VALUES ('e','3','12');INSERT INTO tbl VALUES ('c','4','12');INSERT INTO tbl VALUES ('c','5','12');INSERT INTO tbl VALUES ('a','6','12');INSERT INTO tbl VALUES ('a','0','13');INSERT INTO tbl VALUES ('d','1','13');INSERT INTO tbl VALUES ('e','2','13');INSERT INTO tbl VALUES ('c','3','13');INSERT INTO tbl VALUES ('a','4','13');INSERT INTO tbl VALUES ('c','5','13');INSERT INTO tbl VALUES ('b','6','13');INSERT INTO tbl VALUES ('e','0','14');INSERT INTO tbl VALUES ('d','1','14');INSERT INTO tbl VALUES ('c','2','14');INSERT INTO tbl VALUES ('a','3','14');INSERT INTO tbl VALUES ('a','4','14');INSERT INTO tbl VALUES ('b','5','14');INSERT INTO tbl VALUES ('c','6','14');INSERT INTO tbl VALUES ('d','0','15');INSERT INTO tbl VALUES ('a','1','15');INSERT INTO tbl VALUES ('b','2','15');INSERT INTO tbl VALUES ('c','3','15');INSERT INTO tbl VALUES ('c','4','15');INSERT INTO tbl VALUES ('e','5','15');INSERT INTO tbl VALUES ('a','6','15');INSERT INTO tbl VALUES ('a','0','16');INSERT INTO tbl VALUES ('e','1','16');INSERT INTO tbl VALUES ('c','2','16');INSERT INTO tbl VALUES ('c','3','16');INSERT INTO tbl VALUES ('a','4','16');INSERT INTO tbl VALUES ('b','5','16');INSERT INTO tbl VALUES ('d','6','16');INSERT INTO tbl VALUES ('a','0','17');INSERT INTO tbl VALUES ('e','1','17');INSERT INTO tbl VALUES ('c','2','17');INSERT INTO tbl VALUES ('d','3','17');INSERT INTO tbl VALUES ('b','4','17');INSERT INTO tbl VALUES ('c','5','17');INSERT INTO tbl VALUES ('a','6','17');INSERT INTO tbl VALUES ('c','0','18');INSERT INTO tbl VALUES ('a','1','18');INSERT INTO tbl VALUES ('e','2','18');INSERT INTO tbl VALUES ('a','3','18');INSERT INTO tbl VALUES ('c','4','18');INSERT INTO tbl VALUES ('b','5','18');INSERT INTO tbl VALUES ('d','6','18');INSERT INTO tbl VALUES ('a','0','19');INSERT INTO tbl VALUES ('c','1','19');INSERT INTO tbl VALUES ('c','2','19');INSERT INTO tbl VALUES ('e','3','19');INSERT INTO tbl VALUES ('a','4','19');INSERT INTO tbl VALUES ('d','5','19');INSERT INTO tbl VALUES ('b','6','19');COMMIT;
✓
SELECT w0.ind as a_idx, w1.ind as b_idx, w2.ind as c_idx, w0.sentid
FROM tbl AS w0
JOIN tbl AS w1 USING (sentid)
JOIN tbl AS w2 USING (sentid)
WHERE w0.text = 'a'
    AND w1.text = 'b'
    AND w2.text = 'c'
    AND ((w1.ind = w0.ind + 1 AND w2.ind = w1.ind + 1) OR (w2.ind = w0.ind + 1 AND w1.ind = w2.ind + 1) OR (w0.ind = w1.ind + 1 AND w2.ind = w0.ind + 1) OR (w2.ind = w1.ind + 1 AND w0.ind = w2.ind + 1) OR (w0.ind = w2.ind + 1 AND w1.ind = w0.ind + 1) OR (w1.ind = w2.ind + 1 AND w0.ind = w1.ind + 1))


a_idx
b_idx
c_idx
sentid


1
2
0
2

4
5
3
4

5
4
3
6

3
5
4
10

2
1
0
11

4
6
5
13

4
5
6
14

1
2
3
15

4
5
3
16

6
4
5
17

3
5
4
18
`a_idx`	`b_idx`	`c_idx`	`sentid`
`1`	`2`	`0`	`2`
`4`	`5`	`3`	`4`
`5`	`4`	`3`	`6`
`3`	`5`	`4`	`10`
`2`	`1`	`0`	`11`
`4`	`6`	`5`	`13`
`4`	`5`	`6`	`14`
`1`	`2`	`3`	`15`
`4`	`5`	`3`	`16`
`6`	`4`	`5`	`17`
`3`	`5`	`4`	`18`