SQL>'FIELDS=OFF' SQL>'SELECT dict.word,dict.intag,url.crc32,last_mod_time,url.url FROM dict, url WHERE url.rec_id=dict.url_id ORDER BY url.crc32,dict.intag' ttt 66048 -2012936693 1187948785 http://site/test1.html ttt 131584 -2012936693 1187948785 http://site/test1.html ttt 197120 -2012936693 1187948785 http://site/test1.html ttt 262656 -2012936693 1187948785 http://site/test1.html ddd 328704 -2012936693 1187948785 http://site/test1.html ddd 394240 -2012936693 1187948785 http://site/test1.html ddd 459776 -2012936693 1187948785 http://site/test1.html ddd 525312 -2012936693 1187948785 http://site/test1.html kkk 590592 -2012936693 1187948785 http://site/test1.html kkk 656128 -2012936693 1187948785 http://site/test1.html kkk 721664 -2012936693 1187948785 http://site/test1.html kkk 787200 -2012936693 1187948785 http://site/test1.html bbb 852224 -2012936693 1187948785 http://site/test1.html bbb 917760 -2012936693 1187948785 http://site/test1.html bbb 983296 -2012936693 1187948785 http://site/test1.html bbb 1048832 -2012936693 1187948785 http://site/test1.html second 1114368 -2012936693 1187948785 http://site/test1.html phone 1179904 -2012936693 1187948785 http://site/test1.html +7 1245440 -2012936693 1187948785 http://site/test1.html 495 1310976 -2012936693 1187948785 http://site/test1.html 123 1376512 -2012936693 1187948785 http://site/test1.html 45 1442048 -2012936693 1187948785 http://site/test1.html 67 1507584 -2012936693 1187948785 http://site/test1.html http 1575168 -2012936693 1187948785 http://site/test1.html site 1640448 -2012936693 1187948785 http://site/test1.html test1 1705472 -2012936693 1187948785 http://site/test1.html html 1771008 -2012936693 1187948785 http://site/test1.html 1 65792 -785231961 1190615189 http://site/test.xml 0 131328 -785231961 1190615189 http://site/test.xml utf 196864 -785231961 1190615189 http://site/test.xml 8 262400 -785231961 1190615189 http://site/test.xml 25638033 327936 -785231961 1190615189 http://site/test.xml 0 393472 -785231961 1190615189 http://site/test.xml raw 459008 -785231961 1190615189 http://site/test.xml content 524544 -785231961 1190615189 http://site/test.xml watermark 590080 -785231961 1190615189 http://site/test.xml 20040101000791 655616 -785231961 1190615189 http://site/test.xml beijing 724224 -785231961 1190615189 http://site/test.xml dow 789760 -785231961 1190615189 http://site/test.xml jones 855296 -785231961 1190615189 http://site/test.xml china 920832 -785231961 1190615189 http://site/test.xml netcom 986368 -785231961 1190615189 http://site/test.xml group 1051904 -785231961 1190615189 http://site/test.xml has 1117440 -785231961 1190615189 http://site/test.xml asked 1182976 -785231961 1190615189 http://site/test.xml advisers 1248512 -785231961 1190615189 http://site/test.xml to 1314048 -785231961 1190615189 http://site/test.xml decide 1379584 -785231961 1190615189 http://site/test.xml on 1445120 -785231961 1190615189 http://site/test.xml the 1510656 -785231961 1190615189 http://site/test.xml price 1576192 -785231961 1190615189 http://site/test.xml of 1641728 -785231961 1190615189 http://site/test.xml its 1707264 -785231961 1190615189 http://site/test.xml initial 1772800 -785231961 1190615189 http://site/test.xml public 1838336 -785231961 1190615189 http://site/test.xml offering 1903872 -785231961 1190615189 http://site/test.xml shares 1969408 -785231961 1190615189 http://site/test.xml during 2034944 -785231961 1190615189 http://site/test.xml the 2100480 -785231961 1190615189 http://site/test.xml week 2166016 -785231961 1190615189 http://site/test.xml of 2231552 -785231961 1190615189 http://site/test.xml jan 2297088 -785231961 1190615189 http://site/test.xml 15 2362624 -785231961 1190615189 http://site/test.xml with 2428160 -785231961 1190615189 http://site/test.xml a 2493696 -785231961 1190615189 http://site/test.xml final 2559232 -785231961 1190615189 http://site/test.xml decision 2624768 -785231961 1190615189 http://site/test.xml expected 2690304 -785231961 1190615189 http://site/test.xml by 2755840 -785231961 1190615189 http://site/test.xml jan 2821376 -785231961 1190615189 http://site/test.xml 22 2886912 -785231961 1190615189 http://site/test.xml the 2952448 -785231961 1190615189 http://site/test.xml beijing 3017984 -785231961 1190615189 http://site/test.xml morning 3083520 -785231961 1190615189 http://site/test.xml post 3149056 -785231961 1190615189 http://site/test.xml reports 3214592 -785231961 1190615189 http://site/test.xml the 3280128 -785231961 1190615189 http://site/test.xml country's 3345664 -785231961 1190615189 http://site/test.xml second 3411200 -785231961 1190615189 http://site/test.xml largest 3476736 -785231961 1190615189 http://site/test.xml fixed 3542272 -785231961 1190615189 http://site/test.xml line 3607808 -785231961 1190615189 http://site/test.xml operator 3673344 -785231961 1190615189 http://site/test.xml is 3738880 -785231961 1190615189 http://site/test.xml likely 3804416 -785231961 1190615189 http://site/test.xml to 3869952 -785231961 1190615189 http://site/test.xml list 3935488 -785231961 1190615189 http://site/test.xml no 4001024 -785231961 1190615189 http://site/test.xml later 4066560 -785231961 1190615189 http://site/test.xml than 4132096 -785231961 1190615189 http://site/test.xml the 4197632 -785231961 1190615189 http://site/test.xml summer 4263168 -785231961 1190615189 http://site/test.xml of 4328704 -785231961 1190615189 http://site/test.xml 2004 4394240 -785231961 1190615189 http://site/test.xml based 4459776 -785231961 1190615189 http://site/test.xml on 4525312 -785231961 1190615189 http://site/test.xml the 4590848 -785231961 1190615189 http://site/test.xml group's 4656384 -785231961 1190615189 http://site/test.xml current 4721920 -785231961 1190615189 http://site/test.xml restructuring 4787456 -785231961 1190615189 http://site/test.xml schedule 4852992 -785231961 1190615189 http://site/test.xml industry 4918528 -785231961 1190615189 http://site/test.xml sources 4984064 -785231961 1190615189 http://site/test.xml said 5049600 -785231961 1190615189 http://site/test.xml without 5115136 -785231961 1190615189 http://site/test.xml elaborating 5180672 -785231961 1190615189 http://site/test.xml according 5246208 -785231961 1190615189 http://site/test.xml to 5311744 -785231961 1190615189 http://site/test.xml the 5377280 -785231961 1190615189 http://site/test.xml paper 5442816 -785231961 1190615189 http://site/test.xml earlier 5508352 -785231961 1190615189 http://site/test.xml reports 5573888 -785231961 1190615189 http://site/test.xml have 5639424 -785231961 1190615189 http://site/test.xml said 5704960 -785231961 1190615189 http://site/test.xml netcom 5770496 -785231961 1190615189 http://site/test.xml intends 5836032 -785231961 1190615189 http://site/test.xml to 5901568 -785231961 1190615189 http://site/test.xml list 5967104 -785231961 1190615189 http://site/test.xml shares 6032640 -785231961 1190615189 http://site/test.xml in 6098176 -785231961 1190615189 http://site/test.xml hong 6163712 -785231961 1190615189 http://site/test.xml kong 6229248 -785231961 1190615189 http://site/test.xml and 6294784 -785231961 1190615189 http://site/test.xml new 6360320 -785231961 1190615189 http://site/test.xml york 6425856 -785231961 1190615189 http://site/test.xml it 6491392 -785231961 1190615189 http://site/test.xml is 6556928 -785231961 1190615189 http://site/test.xml the 6622464 -785231961 1190615189 http://site/test.xml only 6688000 -785231961 1190615189 http://site/test.xml entity 6753536 -785231961 1190615189 http://site/test.xml among 6819072 -785231961 1190615189 http://site/test.xml china's 6884608 -785231961 1190615189 http://site/test.xml four 6950144 -785231961 1190615189 http://site/test.xml large 7015680 -785231961 1190615189 http://site/test.xml state 7081216 -785231961 1190615189 http://site/test.xml run 7146752 -785231961 1190615189 http://site/test.xml telecom 7212288 -785231961 1190615189 http://site/test.xml companies 7277824 -785231961 1190615189 http://site/test.xml that 7343360 -785231961 1190615189 http://site/test.xml remains 7408896 -785231961 1190615189 http://site/test.xml unlisted 7474432 -785231961 1190615189 http://site/test.xml dominant 7539968 -785231961 1190615189 http://site/test.xml fixed 7605504 -785231961 1190615189 http://site/test.xml line 7671040 -785231961 1190615189 http://site/test.xml operator 7736576 -785231961 1190615189 http://site/test.xml china 7802112 -785231961 1190615189 http://site/test.xml telecom 7867648 -785231961 1190615189 http://site/test.xml group 7933184 -785231961 1190615189 http://site/test.xml lists 7998720 -785231961 1190615189 http://site/test.xml part 8064256 -785231961 1190615189 http://site/test.xml of 8129792 -785231961 1190615189 http://site/test.xml its 8195328 -785231961 1190615189 http://site/test.xml assets 8260864 -785231961 1190615189 http://site/test.xml as 8326400 -785231961 1190615189 http://site/test.xml china 8391936 -785231961 1190615189 http://site/test.xml telecom 8457472 -785231961 1190615189 http://site/test.xml corp 8523008 -785231961 1190615189 http://site/test.xml cha 8588544 -785231961 1190615189 http://site/test.xml while 8654080 -785231961 1190615189 http://site/test.xml mobile 8719616 -785231961 1190615189 http://site/test.xml phone 8785152 -785231961 1190615189 http://site/test.xml network 8850688 -785231961 1190615189 http://site/test.xml duopoly 8916224 -785231961 1190615189 http://site/test.xml china 8981760 -785231961 1190615189 http://site/test.xml mobile 9047296 -785231961 1190615189 http://site/test.xml communications 9112832 -785231961 1190615189 http://site/test.xml corp 9178368 -785231961 1190615189 http://site/test.xml and 9243904 -785231961 1190615189 http://site/test.xml china 9309440 -785231961 1190615189 http://site/test.xml united 9374976 -785231961 1190615189 http://site/test.xml telecommunications 9440512 -785231961 1190615189 http://site/test.xml corp 9506048 -785231961 1190615189 http://site/test.xml list 9571584 -785231961 1190615189 http://site/test.xml a 9637120 -785231961 1190615189 http://site/test.xml portion 9702656 -785231961 1190615189 http://site/test.xml of 9768192 -785231961 1190615189 http://site/test.xml their 9833728 -785231961 1190615189 http://site/test.xml assets 9899264 -785231961 1190615189 http://site/test.xml as 9964800 -785231961 1190615189 http://site/test.xml china 10030336 -785231961 1190615189 http://site/test.xml mobile 10095872 -785231961 1190615189 http://site/test.xml ltd 10161408 -785231961 1190615189 http://site/test.xml chl 10226944 -785231961 1190615189 http://site/test.xml and 10292480 -785231961 1190615189 http://site/test.xml china 10358016 -785231961 1190615189 http://site/test.xml unicom 10423552 -785231961 1190615189 http://site/test.xml ltd 10489088 -785231961 1190615189 http://site/test.xml chu 10554624 -785231961 1190615189 http://site/test.xml respectively 10620160 -785231961 1190615189 http://site/test.xml newspaper 10685696 -785231961 1190615189 http://site/test.xml web 10751232 -785231961 1190615189 http://site/test.xml site 10816768 -785231961 1190615189 http://site/test.xml http 10882304 -785231961 1190615189 http://site/test.xml www 10947840 -785231961 1190615189 http://site/test.xml morningpost 11013376 -785231961 1190615189 http://site/test.xml com 11078912 -785231961 1190615189 http://site/test.xml cn 11144448 -785231961 1190615189 http://site/test.xml by 11209984 -785231961 1190615189 http://site/test.xml china 11275520 -785231961 1190615189 http://site/test.xml bureau 11341056 -785231961 1190615189 http://site/test.xml dow 11406592 -785231961 1190615189 http://site/test.xml jones 11472128 -785231961 1190615189 http://site/test.xml newswires 11537664 -785231961 1190615189 http://site/test.xml 8610 11603200 -785231961 1190615189 http://site/test.xml 6588 11668736 -785231961 1190615189 http://site/test.xml 5848 11734272 -785231961 1190615189 http://site/test.xml djnews 11799808 -785231961 1190615189 http://site/test.xml beijing 11865344 -785231961 1190615189 http://site/test.xml dowjones 11930880 -785231961 1190615189 http://site/test.xml com 11996416 -785231961 1190615189 http://site/test.xml end 12061952 -785231961 1190615189 http://site/test.xml dow 12127488 -785231961 1190615189 http://site/test.xml jones 12193024 -785231961 1190615189 http://site/test.xml newswires 12258560 -785231961 1190615189 http://site/test.xml 01 12324096 -785231961 1190615189 http://site/test.xml 01 12389632 -785231961 1190615189 http://site/test.xml 04 12455168 -785231961 1190615189 http://site/test.xml 2341et 12520704 -785231961 1190615189 http://site/test.xml 11 12586240 -785231961 1190615189 http://site/test.xml 41 12651776 -785231961 1190615189 http://site/test.xml pm 12717312 -785231961 1190615189 http://site/test.xml est 12782848 -785231961 1190615189 http://site/test.xml 01 12848384 -785231961 1190615189 http://site/test.xml 01 12913920 -785231961 1190615189 http://site/test.xml 04 12979456 -785231961 1190615189 http://site/test.xml footnote 13041920 -785231961 1190615189 http://site/test.xml this 13110528 -785231961 1190615189 http://site/test.xml is 13176064 -785231961 1190615189 http://site/test.xml a 13241600 -785231961 1190615189 http://site/test.xml real 13307136 -785231961 1190615189 http://site/test.xml time 13372672 -785231961 1190615189 http://site/test.xml news 13438208 -785231961 1190615189 http://site/test.xml story 13503744 -785231961 1190615189 http://site/test.xml and 13569280 -785231961 1190615189 http://site/test.xml may 13634816 -785231961 1190615189 http://site/test.xml be 13700352 -785231961 1190615189 http://site/test.xml updated 13765888 -785231961 1190615189 http://site/test.xml in 13831424 -785231961 1190615189 http://site/test.xml the 13896960 -785231961 1190615189 http://site/test.xml near 13962496 -785231961 1190615189 http://site/test.xml future 14028032 -785231961 1190615189 http://site/test.xml dow 14093312 -785231961 1190615189 http://site/test.xml jones 14158848 -785231961 1190615189 http://site/test.xml international 14224384 -785231961 1190615189 http://site/test.xml newswires 14289920 -785231961 1190615189 http://site/test.xml 2004 14355200 -785231961 1190615189 http://site/test.xml 01 14420736 -785231961 1190615189 http://site/test.xml 01 14486272 -785231961 1190615189 http://site/test.xml 23 14551808 -785231961 1190615189 http://site/test.xml 41 14617344 -785231961 1190615189 http://site/test.xml 00 14682880 -785231961 1190615189 http://site/test.xml http 14747904 -785231961 1190615189 http://site/test.xml site 14813184 -785231961 1190615189 http://site/test.xml test 14878208 -785231961 1190615189 http://site/test.xml xml 14943744 -785231961 1190615189 http://site/test.xml http 67840 0 0 http://site/ site 133120 0 0 http://site/ test2 66048 1769283719 21623364 http://site/test2.html phone 131328 1769283719 21623364 http://site/test2.html 8622 196864 1769283719 21623364 http://site/test2.html 62 262400 1769283719 21623364 http://site/test2.html 12 327936 1769283719 21623364 http://site/test2.html 12 393472 1769283719 21623364 http://site/test2.html http 461056 1769283719 21623364 http://site/test2.html site 526336 1769283719 21623364 http://site/test2.html test2 591360 1769283719 21623364 http://site/test2.html html 656896 1769283719 21623364 http://site/test2.html SQL>'SELECT dict.word,dict.intag,url.crc32,url.url FROM crossdict dict, url WHERE url.rec_id=dict.url_id ORDER BY url.crc32,dict.intag' second 68096 1769283719 http://site/test2.html SQL>'SELECT status, docsize, hops, crc32, url FROM url ORDER BY status, crc32' 200 460 1 -2012936693 http://site/test1.html 200 2893 1 -785231961 http://site/test.xml 200 120 0 0 http://site/ 200 170 1 1769283719 http://site/test2.html 404 0 2 0 http://site/img/djlogobluesm.gif 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 -2012936693 http://site/test1.html body BBB BBB BBB BBB Second Phone: +7 495 123 45 67 200 -2012936693 http://site/test1.html Content-Type text/html 200 -2012936693 http://site/test1.html meta.description DDD DDD DDD DDD 200 -2012936693 http://site/test1.html meta.keywords KKK KKK KKK KKK 200 -2012936693 http://site/test1.html Phone +7 495 123 45 67  200 -2012936693 http://site/test1.html title TTT TTT TTT TTT 200 -785231961 http://site/test.xml body 1.0 UTF-8 25638033 0 RAW_CONTENT watermark 20040101000791 footnote 200 -785231961 http://site/test.xml content-provider Dow Jones International Newswires 200 -785231961 http://site/test.xml Content-Type text/xml 200 -785231961 http://site/test.xml publication-date 2004-01-01 23:41:00 200 0 http://site/ Content-type text/html 200 1769283719 http://site/test2.html body Phone: (8622) 62-12-12 200 1769283719 http://site/test2.html Content-Type text/html 200 1769283719 http://site/test2.html Phone (8622) 62-12-12  200 1769283719 http://site/test2.html title Test2 SQL>SQL>'SELECT url FROM url WHERE url='http://site/'' http://site/ SQL>