Lines Matching refs:root

36   SELECT count(*), depth FROM cx WHERE root=1 GROUP BY depth ORDER BY 1;
51   SELECT * FROM cx WHERE root=32768 ORDER BY id;
67   SELECT * FROM cx WHERE root=16384 AND depth<=2 ORDER BY id;
83   SELECT id, depth, root, tablename, idcolumn, parentcolumn FROM cx
84    WHERE root=16384
91   SELECT id, depth, root, tablename, idcolumn, parentcolumn FROM cx
92    WHERE root=16384
111   SELECT count(*), depth FROM cx WHERE root=1 AND depth<5
128   SELECT count(*), depth FROM cx WHERE root=1 AND depth<=5
134   SELECT count(*), depth FROM cx WHERE root=1 AND depth=5
140   SELECT count(*), depth FROM cx WHERE root=1 AND depth BETWEEN 3 AND 5
146   SELECT count(*), min(id), max(id) FROM cx WHERE root=1 AND depth=5;
171   SELECT count(*), min(id), max(id) FROM c2 WHERE root=1;
173 # t2 root=10
175   SELECT id FROM c2 WHERE root=10;
177 # t2 root=11
179   SELECT id FROM c2 WHERE root=12;
181 # t2 root IN [10,12]
183   SELECT id FROM c2 WHERE root IN (10,12) ORDER BY id;
185 # t2 root IN [10,12] (sorted)
187   SELECT id FROM c2 WHERE root IN (10,12) ORDER BY +id;
197   SELECT id FROM c2up WHERE root=20;
203    WHERE root=20
212    WHERE root IN (SELECT id FROM c2up
213                    WHERE root=20 AND depth<=2)
220    WHERE root=(SELECT id FROM c2up
221                WHERE root=20 AND depth=2)
225    WHERE root=(SELECT id FROM c2up
226                WHERE root=20 AND depth=1)
235      WHERE root=20
246      WHERE root=20
257      WHERE root=20
268    WHERE root=1
292   SELECT * FROM t4, vt4 WHERE t4.id = vt4.root AND vt4.id=4 AND vt4.depth=2;