please remeber, we have working tables properties, properties_order, room_details and propsid. Some have stamped created/queried date query_date and for room_details we have created_at. Please fetch some sample data by these fields to understand which fields have values, what type of values and how these three tables link each other. Some of the tables fields are empty or not used. With the fields what have value, we need at first 
1. to understand how many hotels and rooms are available and how many are unavailable for each day.
2. have an overview of pricing so we can position our property corectly,pls make sure to take into account the number of persons 
3. detect how many booking were done at which hotel between two dates, so ex between query_date/created_at what difference we have for each hotel as available rooms.
4.any report you may propose with the available data or data we can fetch to serve the purpose of this project.