Database changed
mysql> SELECT name,transportid,networkid,serviceid FROM channel as c, dtv_multiplex as d WHERE
-> c.mplexid = d.mplexid AND name LIKE "RTL Shop";
+----------+-------------+-----------+-----------+
| name | transportid | networkid | serviceid |
+----------+-------------+-----------+-----------+
| RTL Shop | 10001 | 61441 | 53514 |
+----------+-------------+-----------+-----------+
1 row in set (0.07 sec)
mysql> SELECT name,transportid,networkid,serviceid FROM channel as c, dtv_multiplex as d WHERE c.mplexid = d.mplexid AND name LIKE "SR Fernsehen";
+--------------+-------------+-----------+-----------+
| name | transportid | networkid | serviceid |
+--------------+-------------+-----------+-----------+
| SR Fernsehen | 10003 | 61441 | 52000 |
+--------------+-------------+-----------+-----------+
1 row in set (0.00 sec)
mysql>