お店情報

select a.hall as hall, a.hall_name as hall_name, b.area as area, b.area_name as area_name, a.picurl as picurl from hall a, area b where a.status = 1 and a.hall > 0 and a.area=b.area and a.hall = 2