select distinct nombre, numero, substring(url_remoto,14,37) from versionador_db v inner join sala s on v.sala_destino=s.numero where date(v.fecha_hora_deploy) = date(current_timestamp) and v.autor='fernando' and v.fecha_hora_implementacion is null order by v.id_deploy desc limit 100;
+-------------------------+--------+---------------------------------------+
| nombre                  | numero | substring(url_remoto,14,37)           |
+-------------------------+--------+---------------------------------------+
| Taller                  |     90 | crucidc.crucijuegos.com:3306/crucibas |
| Carlos Paz              |     42 | sala42.crucijuegos.com:3306/crucibase |
| Laberinto[ex-Martinoli] |     40 | xy29.crucijuegos.com:3306/crucibase?z |
| Pergamino               |     38 | vps.crucijuegos.com:13806/crucibase?z |
| Paso del Bosque         |     32 | vps.crucijuegos.com:13206/crucibase?z |
| La Reina                |     29 | sala29.crucijuegos.com:3306/crucibase |
| Resistencia             |     18 | xy18.crucijuegos.com:3306/crucibase?z |
| Posadas 2               |     14 | sala14.crucijuegos.com:3306/crucibase |
| Rosario 1               |     10 | vps.crucijuegos.com:13906/crucibase?z |
| San Juan                |      9 | vps.crucijuegos.com:14306/crucibase?z |
| Corrientes              |      8 | xy08.crucijuegos.com:3306/crucibase?z |
| Jacinto Rios            |      6 | sala6.crucijuegos.com:3306/crucibase? |
| Santiago                |      5 | vps.crucijuegos.com:14206/crucibase?z |
| Salta                   |      3 | sala3.crucijuegos.com:3306/crucibase? |
| Posadas 1               |      1 | xy01.crucijuegos.com:3306/crucibase?z |
| Tucuman 2               |     11 | sala11.crucijuegos.com:3306/crucibase |
| Tucuman 1               |      7 | sala7.crucijuegos.com:3306/crucibase? |
+-------------------------+--------+---------------------------------------+