Advertisement
Guest User

Untitled

a guest
Feb 26th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT u.*, c.lft, c.rgt
  2. FROM
  3. (SELECT a. * , b.catID, b.main, b.sort bsort, a.sort asort
  4. FROM `foto_cats` b
  5. LEFT JOIN foto a ON b.photoID = a.id
  6. WHERE a.user = ".(int)$user['id'].") u
  7. LEFT JOIN cats c ON u.catID = c.id
  8. WHERE delRequest =0
  9. ORDER BY `main` DESC, lft ASC, bsort ASC, asort ASC LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement