1SQL>'FIELDS=OFF' 2SQL>'SELECT dict.word,dict.coord,url.seed,url.crc32,url.url FROM dict, url WHERE url.rec_id=dict.url_id ORDER BY url.seed,url.crc32,dict.coord' 3title1 234881025 217 -1475374444 http://site/test.mp3 4title2 234881026 217 -1475374444 http://site/test.mp3 5title3 234881027 217 -1475374444 http://site/test.mp3 6title1 234881028 217 -1475374444 http://site/test.mp3 7title2 234881029 217 -1475374444 http://site/test.mp3 8title3 234881030 217 -1475374444 http://site/test.mp3 9album1 251658241 217 -1475374444 http://site/test.mp3 10album2 251658242 217 -1475374444 http://site/test.mp3 11album3 251658243 217 -1475374444 http://site/test.mp3 12album1 251658244 217 -1475374444 http://site/test.mp3 13album2 251658245 217 -1475374444 http://site/test.mp3 14album3 251658246 217 -1475374444 http://site/test.mp3 15artist1 268435457 217 -1475374444 http://site/test.mp3 16artist2 268435458 217 -1475374444 http://site/test.mp3 17artist3 268435459 217 -1475374444 http://site/test.mp3 18artist1 268435460 217 -1475374444 http://site/test.mp3 19artist2 268435461 217 -1475374444 http://site/test.mp3 20artist3 268435462 217 -1475374444 http://site/test.mp3 212012 285212673 217 -1475374444 http://site/test.mp3 22SQL>'SELECT status, docsize, hops, seed, crc32, url FROM url ORDER BY status, seed, crc32' 23200 14943 0 217 -1475374444 http://site/test.mp3 24SQL>'SELECT url.status,url.seed,url.crc32,url.url,urlinfo.sname,urlinfo.sval FROM url,urlinfo WHERE url.rec_id=urlinfo.url_id ORDER BY url.status,url.seed,url.crc32,urlinfo.sname' 25200 217 -1475374444 http://site/test.mp3 MP3.Album Album1 Album2 Album3 Album1 Album2 Album3 26200 217 -1475374444 http://site/test.mp3 MP3.Artist Artist1 Artist2 Artist3 Artist1 Artist2 Artist3 27200 217 -1475374444 http://site/test.mp3 MP3.Song Title1 Title2 Title3 Title1 Title2 Title3 28200 217 -1475374444 http://site/test.mp3 MP3.Year 2012 29SQL> 30