rendered paste bodymysql> select name, useonairguide as EIT, visible as vis, xmltvid from channel;
+-----------------------+------+-----+---------+
| name | EIT | vis | xmltvid |
+-----------------------+------+-----+---------+
| Barcelona tv | 1 | 1 | |
| TV3 | 0 | 0 | |
| 3/24 | 1 | 0 | |
| CATALUNYA RÀDIO | 1 | 1 | |
| CATALUNYA INFORMACIÓ | 1 | 1 | |
| CATALUNYA MÚSICA | 1 | 1 | |
| iCat fm | 1 | 1 | |
| TVC HD | 1 | 0 | |
| TV3 | 0 | 1 | |
| 33 | 0 | 1 | |
| 3/24 | 1 | 1 | |
| K3/300 | 0 | 1 | |
| ANTENA 3 | 0 | 1 | |
| ANTENA.NEOX | 1 | 1 | |
| ANTENA.NOVA | 1 | 1 | |
| tvtv DIGITAL | 1 | 1 | |
| ONDA CERO | 1 | 1 | |
| EUROPA FM | 1 | 1 | |
| ONDA MELODIA | 1 | 1 | |
| Telehit | 1 | 1 | |
| 8tv | 1 | 1 | |
| EDC 2 | 1 | 0 | |
| EDC 3 | 1 | 0 | |
| EDC 4 | 1 | 0 | |
| RAC1 | 1 | 1 | |
| RAC105 | 1 | 1 | |
| TVE 1 | 0 | 1 | |
| TVE 2 | 0 | 1 | |
| 24H TVE | 1 | 1 | |
| CLAN TVE | 1 | 1 | |
| RNE 1 | 0 | 1 | |
| RNEC | 0 | 1 | |
| RNE3 | 0 | 1 | |
| TELEDEPORTE | 1 | 1 | |
| Canal Ingenieria | 1 | 1 | |
| VEO | 1 | 1 | |
| SETenVEO | 1 | 1 | |
| Tienda en VEO | 1 | 1 | |
| NET TV | 1 | 1 | |
| Radio Intereconomia | 1 | 1 | |
| CUATRO | 0 | 1 | |
| CNN+ | 1 | 1 | |
| 40 LATINO | 1 | 1 | |
| laSexta | 0 | 1 | |
| Telecinco | 0 | 1 | |
| T5 Estrellas | 1 | 1 | |
| T5 Sport | 1 | 1 | |
| FLYMUSIC | 1 | 1 | |
| PUNTO RADIO | 1 | 1 | |
+-----------------------+------+-----+---------+
49 rows in set (0.00 sec)