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>