select r_idx, name, addr, lat, lng from r_resort INNER JOIN r_category2 ON r_resort.c2_idx = r_category2.c2_idx INNER JOIN r_category1 ON r_category2.c1_idx = r_category1.c1_idx where r_category2.c2_idx = 50 and lat <> '' and lng <> '' and lat is not null and lng is not null