Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. Table #1 channels:
  2. +-----+--------+---------------------------+------------------+------+
  3. | uid | name | url | epg | last |
  4. +-----+--------+---------------------------+------------------+------+
  5. | 2 | ARD | rtp://@239.35.10.1:10000 | ard | 0 |
  6. | 3 | ZDF | rtp://@239.35.10.2:10000 | zdf | 0 |
  7. | 4 | Sat1 | rtp://@239.35.20.20:10000 | sat1_deutschland | 0 |
  8. | 5 | RTL | rtp://@239.35.20.10:10000 | rtl_deutschland | 0 |
  9. | 6 | RTL II | rtp://@239.35.20.22:10000 | rtl2_deutschland | 0 |
  10. +-----+--------+---------------------------+------------------+------+
  11.  
  12. Table #2 settings:
  13. +-----+---------------+----------+------------+-----------+
  14. | uid | favorites | channels | recprepend | recappend |
  15. +-----+---------------+----------+------------+-----------+
  16. | 1 | 2,3,5,4,13,14 | fav | 0 | 0 |
  17. +-----+---------------+----------+------------+-----------+
  18.  
  19. SELECT c.uid, c.name, c.url, c.epg, c.last, s.favorites FROM `channels` c CROSS JOIN `settings` s WHERE FIND_IN_SET (c.uid, s.favorites)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement