SQL_STRING: SELECT O.*, C.FECHA_INICIO, C.FECHA_FIN, C.FECHA, C.HORARIO, C.ENTRADAS, C.CICLO, C.GIRA, C.ID_TEMPORADA FROM obras AS O LEFT JOIN calendario AS C ON C.ID_OBRA=O.ID_OBRA WHERE O.ID_OBRA=730 ORDER BY C.GIRA ASC