Lines Matching refs:fid
281 WITH flat(fid, fpath) AS (
284 SELECT id, fpath || '/' || name FROM f, flat WHERE parentid=fid
301 WITH flat(fid, fpath) AS (
304 SELECT id, fpath || '/' || name FROM f, flat WHERE parentid=fid
522 WITH flat(fid, p) AS (
525 SELECT id, p || '/' || payload FROM flat, tree WHERE parentid=fid
548 WITH flat(fid, depth, p) AS (
551 SELECT id, depth+1, p||'/'||payload FROM flat, tree WHERE parentid=fid
646 WITH flat(fid, depth, p) AS (
649 SELECT id, depth+1, p||'/'||payload FROM flat, tree WHERE parentid=fid
658 WITH flat(fid, depth, p) AS (
663 FROM flat, tree WHERE parentid=fid
673 WITH flat(fid, depth, p) AS (
678 FROM flat, tree WHERE parentid=fid