Search Luxury Real Estate Agencies
and Brokerages Worldwide

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )
					 WHERE 1=1  AND wp_posts.ID NOT IN (120337,120337,120337) AND ( 
  wp_postmeta.meta_key = 'stateprovince' 
  AND 
  mt1.meta_key = 'country'
) AND wp_posts.post_type = 'members' AND ((wp_posts.post_status = 'publish'))
					 GROUP BY wp_posts.ID
					 ORDER BY CAST(mt1.meta_value AS CHAR) ASC, CAST(wp_postmeta.meta_value AS CHAR) ASC, wp_posts.post_title ASC
					 LIMIT 24, 12Array
(
    [post_type] => members
    [post_status] => publish
    [posts_per_page] => 12
    [paged] => 3
    [order] => desc
    [orderby] => Array
        (
            [country_meta] => ASC
            [state_meta] => ASC
            [title] => ASC
        )

    [memberandagent_query] => members
    [meta_query] => Array
        (
            [state_meta] => Array
                (
                    [key] => stateprovince
                    [compare] => EXISTS
                )

            [country_meta] => Array
                (
                    [key] => country
                    [compare] => EXISTS
                )

        )

)