mysql> 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)