Reply To: Export data / database issue

• Galtieri

• July 4, 2014 at 4:46 am

Well i solved this problem partly.

You can export posts with Phimind Excel Export plugin (it’s very easy out there). But it can’t export data arrays. And i reached maximum of posts quantity (it’s about of 40-50 fields).

Other way of export is SQL SELECT. Here is my query.

SELECT DISTINCT
post_title
,(SELECT meta_value FROM kr_postmeta WHERE kr_postmeta.meta_key = 'birth_day' AND kr_postmeta.post_id = kr_posts.ID) as "birth_day"
,(SELECT meta_value FROM kr_postmeta WHERE kr_postmeta.meta_key = 'birth_month' AND kr_postmeta.post_id = kr_posts.ID) as "birth_month"
,(SELECT meta_value FROM kr_postmeta WHERE kr_postmeta.meta_key = 'birth_year' AND kr_postmeta.post_id = kr_posts.ID) as "birth_year"
FROM kr_posts
WHERE post_type = 'post' 
GROUP BY post_title
ORDER BY post_title DESC