Reply To: How can I query only repeater fields as if they were posts?

• kuhada

• January 9, 2017 at 6:07 am

yes… I was afraid of that. Anyway, I made a following sql query which should return “flat” list of all repeater galleries along with their name and post id to which they belong (for generating links and such on the frontend). So, just for the future reference :

		select
			  pm.post_id as post_id
			, pm2.meta_value as gallery
			, pm.meta_value as images
		from
			wp_postmeta as pm
		inner join
			wp_postmeta as pm2
			on
			((pm.post_id = pm2.post_id) and (pm.meta_key + '_name' = pm2.meta_key))
		where
			pm.meta_key like 'post_photo_galleries_%_post_photo_gallery'
			and
			pm2.meta_key like 'post_photo_galleries_%_post_photo_gallery_name';