Search Luxury Real Estate Agencies
and Brokerages - Italy

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_posts.post_title REGEXP '\\bItaly\\b'
						OR EXISTS (
							SELECT 1 FROM wp_postmeta
							WHERE wp_postmeta.post_id = wp_posts.ID
							AND (
								(wp_postmeta.meta_key = 'keywords' AND wp_postmeta.meta_value REGEXP '\\bItaly\\b')
								OR (wp_postmeta.meta_key = 'member_location' AND wp_postmeta.meta_value REGEXP '\\bItaly\\b')
							)
						)
					) 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 0, 12Array
(
    [post_type] => members
    [post_status] => publish
    [posts_per_page] => 12
    [paged] => 1
    [order] => desc
    [orderby] => Array
        (
            [country_meta] => ASC
            [state_meta] => ASC
            [title] => ASC
        )

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

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

        )

)