Taiwan's Beaches

SELECT locations.ID, locations.type, locations.location_level, v.name AS name FROM wp_mb_relationships rels JOIN wp_locations locations ON rels.to = locations.ID Join wp_locations_virtual v on v.post_id = locations.ID WHERE rels.type = 'beach-to-location' AND (locations.ignore_location != 1 OR locations.ignore_location IS NULL) AND rels.from = 217955;

老梅沙灘

SELECT locations.ID, locations.type, locations.location_level, v.name AS name FROM wp_mb_relationships rels JOIN wp_locations locations ON rels.to = locations.ID Join wp_locations_virtual v on v.post_id = locations.ID WHERE rels.type = 'beach-to-location' AND (locations.ignore_location != 1 OR locations.ignore_location IS NULL) AND rels.from = 215031;

龍門沙灘

SELECT locations.ID, locations.type, locations.location_level, v.name AS name FROM wp_mb_relationships rels JOIN wp_locations locations ON rels.to = locations.ID Join wp_locations_virtual v on v.post_id = locations.ID WHERE rels.type = 'beach-to-location' AND (locations.ignore_location != 1 OR locations.ignore_location IS NULL) AND rels.from = 218150;

沙灘

SELECT locations.ID, locations.type, locations.location_level, v.name AS name FROM wp_mb_relationships rels JOIN wp_locations locations ON rels.to = locations.ID Join wp_locations_virtual v on v.post_id = locations.ID WHERE rels.type = 'beach-to-location' AND (locations.ignore_location != 1 OR locations.ignore_location IS NULL) AND rels.from = 214789;

Shanshui Beach

SELECT locations.ID, locations.type, locations.location_level, v.name AS name FROM wp_mb_relationships rels JOIN wp_locations locations ON rels.to = locations.ID Join wp_locations_virtual v on v.post_id = locations.ID WHERE rels.type = 'beach-to-location' AND (locations.ignore_location != 1 OR locations.ignore_location IS NULL) AND rels.from = 217897;

Cijin Beach

SELECT locations.ID, locations.type, locations.location_level, v.name AS name FROM wp_mb_relationships rels JOIN wp_locations locations ON rels.to = locations.ID Join wp_locations_virtual v on v.post_id = locations.ID WHERE rels.type = 'beach-to-location' AND (locations.ignore_location != 1 OR locations.ignore_location IS NULL) AND rels.from = 214787;

隘門沙灘