/*SELECT hotel_id, reservation_id, COUNT(hotel_id)FROM staywhere reservation_id is not nullGROUP BY hotel_id, reservation_idHAVING COUNT(hotel_id) > 1*/select distinct s.hotel_id , t.* from stay sright join ( select hotel_id, reservation_id, count(*) as qty from staywhere reservation_id !=1 group by hotel_id, reservation_id having count(*) > 1) t on s.hotel_id = t.hotel_id and s.reservation_id = t.reservation_id