Guest User

Untitled

a guest
Jan 21st, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. SELECT news.*
  2. FROM (
  3. SELECT id
  4. FROM news
  5. WHERE cat_id= x
  6. ORDER BY
  7. id DESC
  8. LIMIT m, n
  9. ) o
  10. JOIN news
  11. ON news.id = o.id
  12.  
  13. from u in news
  14. join n in
  15. (
  16. from x in news
  17. where x.cat_id = 10
  18. orderby x.Id descending
  19. select x
  20. ).Skip(10).Take(20) on u.Id equals n.Id
  21. select u
Add Comment
Please, Sign In to add comment