Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. id | name | fav
  2. 1 | abc | 11,2,3,4,5,11,2
  3. 2 |
  4. 3 |
  5. .
  6. .
  7. .
  8.  
  9. select id, name, group_concat(distinct uf.favid order by uf.id) as favs
  10. from table t join
  11. UserFav uf
  12. on t.id = uf.userid
  13. group by t.id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement