select * from tbcomentario b inner join tbhotel h on h.idhotel = b.cdhotel inner join tbreservafinal rf on rf.idreserva = b.cdreserva inner join tbcliente c on c.idcliente = rf.cdcliente inner join tbpuntuacion tp on tp.idtipopuntuacion = b.cdpuntuacion where b.estatus =1 order by fecharegistro ASC