Advertisement
TheDemystifier

Udemy Courses Filter QUery

Jun 13th, 2019
2,727
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Smarty 0.40 KB | None | 0 0
  1. SELECT url, title, rating, votes, length, lastUpdated, language
  2. FROM courses
  3. WHERE title LIKE '%%' OR headline LIKE '%%'
  4. ORDER BY rating DESC, votes DESC
  5.  
  6.  
  7. ORDER BY 5*rating/10+5*(1-EXP(-votes/25)) DESC
  8.  
  9.  
  10. ORDER BY (1 + votes * rating)/((1 + votes * rating)+(1 + votes))-1.65*sqrt(((1 + votes * rating)*(1 + votes))/(POWER((1 + votes * rating)+(1 + votes), 2)*((1 + votes * rating)+(1 + votes)+1))) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement