Tommy Booking Support WordPress posts accommodation ID's.

tbs-posts-accommodation-ids.sql

SELECT
	wp_posts.ID,
	wp_posts.post_title,
	wp_postmeta.meta_value
FROM
	wp_posts
		LEFT JOIN
	wp_postmeta
			ON (
				wp_posts.ID = wp_postmeta.post_id
					AND
				wp_postmeta.meta_key = '_tbs_accommodation_id'
			)
WHERE
	wp_posts.post_type = 'camping'
		AND
	wp_posts.post_status = 'publish'
;