=== FINDING IMAGE-RELATED TABLES ===

Found: property_images
Found: room_amenities
Found: room_hostel_options
Found: room_images
Found: room_popularity_metrics
Found: room_rules
Found: room_videos
Found: room_views
Found: rooms

=== CHECKING ROOM-RELATED TABLES ===

TABLE: property_images
Columns: id, property_id, image_path, is_primary, created_at, 

TABLE: room_amenities
Columns: id, room_id, amenity, 

TABLE: room_hostel_options
Columns: id, room_id, occupancy, price, created_at, 

TABLE: room_images
Columns: id, room_id, image_path, is_primary, created_at, 

TABLE: room_popularity_metrics
Columns: id, room_id, views_count, wishlist_count, booking_count, contact_count, share_count, popularity_score, last_updated, 

TABLE: room_rules
Columns: id, room_id, rule, 

TABLE: room_videos
Columns: id, room_id, video_path, is_primary, created_at, 

TABLE: room_views
Columns: id, room_id, user_id, ip_address, user_agent, viewed_at, 

TABLE: rooms
Columns: id, property_id, room_number, title, description, room_type, price, security_deposit, room_size, max_occupants, furnishing, bathroom_type, kitchen_type, amenities, floor, available_from, min_stay, status, is_featured, for_sale, sale_price, views, created_at, updated_at, land_size, boundary_type, zoning, legal_status, 

=== SOLUTION ===
The rooms table does NOT have an 'images' column.
We need to either:
1. Remove r.images from the SELECT statement, OR
2. Join with a room_images table if it exists, OR
3. Use NULL as images if no separate table exists