Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT u.*, c.lft, c.rgt
- FROM
- (SELECT a. * , b.catID, b.main, b.sort bsort, a.sort asort
- FROM `foto_cats` b
- LEFT JOIN foto a ON b.photoID = a.id
- WHERE a.user = ".(int)$user['id'].") u
- LEFT JOIN cats c ON u.catID = c.id
- WHERE delRequest =0
- ORDER BY `main` DESC, lft ASC, bsort ASC, asort ASC LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement