Jiwon-JJW / airbnb

그룹프로젝트 #4
0 stars 1 forks source link

[BE] search api 생성 #15

Closed Jiwon-JJW closed 3 years ago

Jiwon-JJW commented 3 years ago
Jiwon-JJW commented 3 years ago

현재 최종 쿼리:

SELECT * FROM property, property_detail, image, wish_list 
                RIGHT JOIN property p on wish_list.property_id = p.id 
                WHERE property.id = property_detail.property_id and 
                property.id = image.property_id and 
                property.location_id = ? and 
                property_detail.max_occupancy >= ? and 
                property.price >= ? and property.price <= ?