Advertisement
Guest User

Untitled

a guest
May 26th, 2018
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. SELECT dm.Document as DocumentName, sum(tf_idf) as tf_idf FROM inverted i LEFT JOIN document_mappings dm ON dm.DocumentKey = i.DocumentKey WHERE i.TermKey = "3bea05c33d4296691acfe5a518fe82ce19b430b3cd939ae8bb8e4aa34a9271cb377d39c5883a6993d81c6d34f1acc9a7d7eae9246d4190e29fcadcd6fe8fae3b" OR i.TermKey = "0bd58612e25579c03d5a44aa1730640c5f97b218d9c6e484d887e5cd043a57c332e8106660c27d4cf994fe7fb15bd7f1355c662091a8dbf9820cb7ad3d87441e" OR i.TermKey = "0edbece127f09482db280ddf986bdab7f0ce46306ad560a1046c36f7f66243a42db3a23466bf29b377f4ffd676b029c6ff0f9930e41fc4017ba9b3abd241263e" OR i.TermKey = "59ec01d7155cef6361395c2aa1c9816a73b5f935b966bc0ff21120202830ea9a4368be94a2c2c988392fe2ed8ddafa016a5d6f06fa6e0d2d0dc8b5df95f5209e" GROUP BY tf_idf, dm.Document
  2. ORDER BY sum(tf_idf) DESC LIMIT 20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement