SQL>'FIELDS=OFF'
SQL>'SELECT dict.word,dict.intag,url.crc32,url.url FROM dict, url WHERE url.rec_id=dict.url_id ORDER BY url.crc32,dict.intag'
this	65792	-1514374635	http://site/test1.txt
is	131328	-1514374635	http://site/test1.txt
a	196864	-1514374635	http://site/test1.txt
text	262400	-1514374635	http://site/test1.txt
file	327936	-1514374635	http://site/test1.txt
no	393472	-1514374635	http://site/test1.txt
title	459008	-1514374635	http://site/test1.txt
available	524544	-1514374635	http://site/test1.txt
http	592128	-1514374635	http://site/test1.txt
site	657408	-1514374635	http://site/test1.txt
test1	722432	-1514374635	http://site/test1.txt
txt	787968	-1514374635	http://site/test1.txt
http	67840	0	http://site/
site	133120	0	http://site/
test	66048	74385794	http://site/test4.html
4	131584	74385794	http://site/test4.html
title	197120	74385794	http://site/test4.html
now	262400	74385794	http://site/test4.html
the	327936	74385794	http://site/test4.html
fourth	393472	74385794	http://site/test4.html
test	459008	74385794	http://site/test4.html
here	524544	74385794	http://site/test4.html
the	590080	74385794	http://site/test4.html
page	655616	74385794	http://site/test4.html
contains	721152	74385794	http://site/test4.html
some	786688	74385794	http://site/test4.html
magic	852224	74385794	http://site/test4.html
word	917760	74385794	http://site/test4.html
and	983296	74385794	http://site/test4.html
it	1048832	74385794	http://site/test4.html
is	1114368	74385794	http://site/test4.html
in	1179904	74385794	http://site/test4.html
the	1245440	74385794	http://site/test4.html
end	1310976	74385794	http://site/test4.html
of	1376512	74385794	http://site/test4.html
the	1442048	74385794	http://site/test4.html
body	1507584	74385794	http://site/test4.html
the	1573120	74385794	http://site/test4.html
word	1638656	74385794	http://site/test4.html
is	1704192	74385794	http://site/test4.html
this	1769728	74385794	http://site/test4.html
http	1837312	74385794	http://site/test4.html
site	1902592	74385794	http://site/test4.html
test4	1967616	74385794	http://site/test4.html
html	2033152	74385794	http://site/test4.html
test	66048	1293339722	http://site/test2.html
2	131584	1293339722	http://site/test2.html
title	197120	1293339722	http://site/test2.html
this	262400	1293339722	http://site/test2.html
is	327936	1293339722	http://site/test2.html
the	393472	1293339722	http://site/test2.html
second	459008	1293339722	http://site/test2.html
test	524544	1293339722	http://site/test2.html
page	590080	1293339722	http://site/test2.html
here	655616	1293339722	http://site/test2.html
is	721152	1293339722	http://site/test2.html
the	786688	1293339722	http://site/test2.html
third	852224	1293339722	http://site/test2.html
one	917760	1293339722	http://site/test2.html
http	985344	1293339722	http://site/test2.html
site	1050624	1293339722	http://site/test2.html
test2	1115648	1293339722	http://site/test2.html
html	1181184	1293339722	http://site/test2.html
test	66048	1305968173	http://site/test3.html
3	131584	1305968173	http://site/test3.html
title	197120	1305968173	http://site/test3.html
this	262400	1305968173	http://site/test3.html
is	327936	1305968173	http://site/test3.html
the	393472	1305968173	http://site/test3.html
third	459008	1305968173	http://site/test3.html
test	524544	1305968173	http://site/test3.html
no	590080	1305968173	http://site/test3.html
more	655616	1305968173	http://site/test3.html
tests	721152	1305968173	http://site/test3.html
available	786688	1305968173	http://site/test3.html
http	854272	1305968173	http://site/test3.html
site	919552	1305968173	http://site/test3.html
test3	984576	1305968173	http://site/test3.html
html	1050112	1305968173	http://site/test3.html
test	66048	1585506248	http://site/test1.html
1	131584	1585506248	http://site/test1.html
title	197120	1585506248	http://site/test1.html
this	262400	1585506248	http://site/test1.html
is	327936	1585506248	http://site/test1.html
the	393472	1585506248	http://site/test1.html
first	459008	1585506248	http://site/test1.html
test	524544	1585506248	http://site/test1.html
page	590080	1585506248	http://site/test1.html
here	655616	1585506248	http://site/test1.html
is	721152	1585506248	http://site/test1.html
the	786688	1585506248	http://site/test1.html
second	852224	1585506248	http://site/test1.html
one	917760	1585506248	http://site/test1.html
http	985344	1585506248	http://site/test1.html
site	1050624	1585506248	http://site/test1.html
test1	1115648	1585506248	http://site/test1.html
html	1181184	1585506248	http://site/test1.html
SQL>'SELECT status, docsize, hops, crc32, pop_rank, url FROM url ORDER BY status, crc32'
200	41	1	-1514374635	0.25	http://site/test1.txt
200	214	0	0	0.25	http://site/
200	225	1	74385794	0.17	http://site/test4.html
200	158	1	1293339722	0.25	http://site/test2.html
200	122	1	1305968173	0.25	http://site/test3.html
200	168	1	1585506248	0.25	http://site/test1.html
2200	41	1	-1514374635	0.25	http://site/z-clone1.txt
2200	158	1	1293339722	0.25	http://site/z-clone2.html
SQL>'SELECT url.status,url.crc32,url.url,urlinfo.sname,urlinfo.sval FROM url,urlinfo WHERE url.rec_id=urlinfo.url_id ORDER BY url.status,url.crc32,lower(urlinfo.sname)'
200	-1514374635	http://site/test1.txt	body	This is a text file. No title available.
200	-1514374635	http://site/test1.txt	Content-Type	text/plain
200	0	http://site/	Content-type	text/html
200	74385794	http://site/test4.html	body	Now the fourth test here. The page contains some magic word and it is in the end of the body. The word is THIS.
200	74385794	http://site/test4.html	Content-Type	text/html
200	74385794	http://site/test4.html	title	Test 4 title
200	1293339722	http://site/test2.html	body	This is the second test page. Here is the third one.
200	1293339722	http://site/test2.html	Content-Type	text/html
200	1293339722	http://site/test2.html	title	Test 2 title
200	1305968173	http://site/test3.html	body	This is the third test. No more tests available.
200	1305968173	http://site/test3.html	Content-Type	text/html
200	1305968173	http://site/test3.html	title	Test 3 title
200	1585506248	http://site/test1.html	body	This is the first test page. & Here is the second one.
200	1585506248	http://site/test1.html	Content-Type	text/html
200	1585506248	http://site/test1.html	title	Test 1 title
SQL>'SELECT u1.docsize,u2.docsize,u1.url,u2.url FROM url u1,url u2, links l WHERE u1.rec_id=l.ot AND u2.rec_id=l.k ORDER BY u1.docsize,u2.docsize'
41	41	http://site/test1.txt	http://site/test1.txt
41	41	http://site/z-clone1.txt	http://site/z-clone1.txt
122	122	http://site/test3.html	http://site/test3.html
158	122	http://site/z-clone2.html	http://site/test3.html
158	122	http://site/test2.html	http://site/test3.html
158	158	http://site/z-clone2.html	http://site/z-clone2.html
158	158	http://site/test2.html	http://site/test2.html
168	158	http://site/test1.html	http://site/test2.html
168	168	http://site/test1.html	http://site/test1.html
214	41	http://site/	http://site/z-clone1.txt
214	41	http://site/	http://site/test1.txt
214	122	http://site/	http://site/test3.html
214	158	http://site/	http://site/z-clone2.html
214	158	http://site/	http://site/test2.html
214	168	http://site/	http://site/test1.html
214	225	http://site/	http://site/test4.html
225	225	http://site/test4.html	http://site/test4.html
SQL>'SELECT url FROM url WHERE url='http://site/''
http://site/
SQL>