pivotando post meta data no wordpress

gistfile1.sql

SELECT  p.*,
        pm1.meta_value AS lat,
        pm2.meta_value AS lgn
    FROM    wp_posts p LEFT JOIN wp_postmeta pm1 ON (
            pm1.post_id = p.ID  AND
            pm1.meta_key    = 'geo_latitude'
        ) LEFT JOIN wp_postmeta pm2 ON (
            pm2.post_id = p.ID  AND
            pm2.meta_key    = 'geo_longitude'
        )
    WHERE   p.post_status = 'publish'
	and p.post_type = 'property'
	and p.ID in (select 
            tr.object_id
        from
            wp_term_relationships tr
                join
            wp_term_taxonomy t ON t.term_taxonomy_id = tr.term_taxonomy_id
        where
            t.term_id IN (17 , 18,
                19,
                20,
                22,
                23,
                24,
                26,
                27,
                28,
                29,
                34,
                46,
                55,
                159))