Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table #1 channels:
- +-----+--------+---------------------------+------------------+------+
- | uid | name | url | epg | last |
- +-----+--------+---------------------------+------------------+------+
- | 2 | ARD | rtp://@239.35.10.1:10000 | ard | 0 |
- | 3 | ZDF | rtp://@239.35.10.2:10000 | zdf | 0 |
- | 4 | Sat1 | rtp://@239.35.20.20:10000 | sat1_deutschland | 0 |
- | 5 | RTL | rtp://@239.35.20.10:10000 | rtl_deutschland | 0 |
- | 6 | RTL II | rtp://@239.35.20.22:10000 | rtl2_deutschland | 0 |
- +-----+--------+---------------------------+------------------+------+
- Table #2 settings:
- +-----+---------------+----------+------------+-----------+
- | uid | favorites | channels | recprepend | recappend |
- +-----+---------------+----------+------------+-----------+
- | 1 | 2,3,5,4,13,14 | fav | 0 | 0 |
- +-----+---------------+----------+------------+-----------+
- 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