Lines Matching refs:id

40     below(id,depth) AS (
44         FROM t1 JOIN below on t1.y=below.id
51   SELECT * FROM cx WHERE root=32768 ORDER BY id;
55     below(id,depth) AS (
59         FROM t1 JOIN below on t1.y=below.id
62   SELECT id, depth FROM below ORDER BY id;
67   SELECT * FROM cx WHERE root=16384 AND depth<=2 ORDER BY id;
71     below(id,depth) AS (
75         FROM t1 JOIN below on t1.y=below.id
78   SELECT id, depth FROM below ORDER BY id;
83   SELECT id, depth, root, tablename, idcolumn, parentcolumn FROM cx
86    ORDER BY id;
91   SELECT id, depth, root, tablename, idcolumn, parentcolumn FROM cx
99     above(id,depth) AS (
103         FROM t1 JOIN above ON t1.x=above.id
106   SELECT id FROM above WHERE depth=3;
116     below(id,depth) AS (
120         FROM t1 JOIN below ON t1.y=below.id
146   SELECT count(*), min(id), max(id) FROM cx WHERE root=1 AND depth=5;
150     below(id,depth) AS (
154         FROM t1 JOIN below ON t1.y=below.id
157   SELECT count(*), min(id), max(id) FROM below WHERE depth=5;
171   SELECT count(*), min(id), max(id) FROM c2 WHERE root=1;
175   SELECT id FROM c2 WHERE root=10;
179   SELECT id FROM c2 WHERE root=12;
183   SELECT id FROM c2 WHERE root IN (10,12) ORDER BY id;
187   SELECT id FROM c2 WHERE root IN (10,12) ORDER BY +id;
197   SELECT id FROM c2up WHERE root=20;
202   SELECT id FROM cx
211   SELECT DISTINCT id FROM c2
212    WHERE root IN (SELECT id FROM c2up
214    ORDER BY id;
219   SELECT id FROM c2
220    WHERE root=(SELECT id FROM c2up
224   SELECT id FROM c2
225    WHERE root=(SELECT id FROM c2up
228    ORDER BY id;
234     SELECT id FROM cx
245     SELECT id FROM cx
256     SELECT id FROM cx
267   SELECT id FROM closure
273   ORDER BY id;
282     id INTEGER PRIMARY KEY, 
287     idcolumn=id, parentcolumn=parent_id, tablename=t4
292   SELECT * FROM t4, vt4 WHERE t4.id = vt4.root AND vt4.id=4 AND vt4.depth=2;