mysql> SELECT chanid, serviceid, channel.mplexid, atscsrcid,        cardinputid, networkid, transportid FROM channel, cardinput, capturecard, dtv_multiplex WHERE channel.mplexid    = dtv_multiplex.mplexid AND       cardinput.sourceid = channel.sourceid      AND       capturecard.cardid = cardinput.cardid      AND       cardinput.cardid   = 4               AND       channel.channum    = '110';
+--------+-----------+---------+-----------+-------------+-----------+-------------+
| chanid | serviceid | mplexid | atscsrcid | cardinputid | networkid | transportid |
+--------+-----------+---------+-----------+-------------+-----------+-------------+
| 3110   | 110       | 52      | 0         | 4           | 4100      | 4           |
+--------+-----------+---------+-----------+-------------+-----------+-------------+
1 row in set (0.00 sec)