Support

Account

Home Forums General Issues Export data / database issue Reply To: Export data / database issue

  • 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