Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT o.orgId, o.name, o.phone_number, cv.catId
- FROM (organizations o JOIN category_values cv
- on cv.orgId = o.orgId) JOIN users_categories uc
- on uc.catId = cv.catId WHERE (uc.uid = '3' AND cv.catId='163')
- ORDER BY o.name ASC
Add Comment
Please, Sign In to add comment