Lines Matching refs:cx

30   CREATE VIRTUAL TABLE cx 
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
91   SELECT id, depth, root, tablename, idcolumn, parentcolumn FROM cx
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;
200 # cx as c2up
202   SELECT id FROM cx
234     SELECT id FROM cx
245     SELECT id FROM cx
256     SELECT id FROM cx