WP_Query Object
(
[query] => Array
(
[post_type] => estates
[post_status] => publish
[posts_per_page] => 17
[paged] => 2
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[key] => offsale
[value] => yes
[compare] => !=
)
[1] => Array
(
[key] => canhavechildren
[value] => 1
[compare] => !=
)
[2] => Array
(
[relation] => OR
[0] => Array
(
[key] => price
[value] => 500
[type] => NUMERIC
[compare] => >=
)
[1] => Array
(
[key] => price
[compare] => NOT EXISTS
)
)
)
[orderby] => date
[order] => DESC
[post_parent] => 0
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => estate_status
[field] => slug
[terms] => Array
(
[0] => voorbereiding-lijfrente_ary
)
)
)
)
[query_vars] => Array
(
[post_type] => estates
[post_status] => publish
[posts_per_page] => 17
[paged] => 2
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[key] => offsale
[value] => yes
[compare] => !=
)
[1] => Array
(
[key] => canhavechildren
[value] => 1
[compare] => !=
)
[2] => Array
(
[relation] => OR
[0] => Array
(
[key] => price
[value] => 500
[type] => NUMERIC
[compare] => >=
)
[1] => Array
(
[key] => price
[compare] => NOT EXISTS
)
)
[3] => Array
(
[key] => offsale
[value] => yes
[compare] => !=
)
)
[orderby] => date
[order] => DESC
[post_parent] => 0
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => estate_status
[field] => slug
[terms] => Array
(
[0] => voorbereiding-lijfrente_ary
)
)
)
[error] =>
[m] =>
[p] => 0
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[search_columns] => Array
(
)
[update_post_term_cache] => 1
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_menu_item_cache] =>
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => estate_status
[term] => voorbereiding-lijfrente_ary
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => estate_status
[terms] => Array
(
[0] => voorbereiding-lijfrente_ary
)
[field] => slug
[operator] => IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wpstbys_term_relationships
)
[queried_terms] => Array
(
[estate_status] => Array
(
[terms] => Array
(
[0] => voorbereiding-lijfrente_ary
)
[field] => slug
)
)
[primary_table] => wpstbys_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => offsale
[value] => yes
[compare] => !=
)
[1] => Array
(
[key] => canhavechildren
[value] => 1
[compare] => !=
)
[2] => Array
(
[0] => Array
(
[key] => price
[value] => 500
[type] => NUMERIC
[compare] => >=
)
[1] => Array
(
[key] => price
[compare] => NOT EXISTS
)
[relation] => OR
)
[3] => Array
(
[key] => offsale
[value] => yes
[compare] => !=
)
[relation] => AND
)
[relation] => AND
[meta_table] => wpstbys_postmeta
[meta_id_column] => post_id
[primary_table] => wpstbys_posts
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => wpstbys_postmeta
[1] => mt1
[2] => mt2
[3] => mt3
)
[clauses:protected] => Array
(
[wpstbys_postmeta] => Array
(
[key] => offsale
[value] => yes
[compare] => !=
[compare_key] => =
[alias] => wpstbys_postmeta
[cast] => CHAR
)
[mt1] => Array
(
[key] => canhavechildren
[value] => 1
[compare] => !=
[compare_key] => =
[alias] => mt1
[cast] => CHAR
)
[mt2] => Array
(
[key] => price
[value] => 500
[type] => NUMERIC
[compare] => >=
[compare_key] => =
[alias] => mt2
[cast] => SIGNED
)
[mt3] => Array
(
[key] => price
[compare] => NOT EXISTS
[compare_key] => =
[alias] => mt3
[cast] => CHAR
)
[wpstbys_postmeta-1] => Array
(
[key] => offsale
[value] => yes
[compare] => !=
[compare_key] => =
[alias] => wpstbys_postmeta
[cast] => CHAR
)
)
[has_or_relation:protected] => 1
)
[date_query] =>
[request] => SELECT SQL_CALC_FOUND_ROWS wpstbys_posts.ID
FROM wpstbys_posts LEFT JOIN wpstbys_term_relationships ON (wpstbys_posts.ID = wpstbys_term_relationships.object_id) LEFT JOIN wpstbys_postmeta ON ( wpstbys_posts.ID = wpstbys_postmeta.post_id ) LEFT JOIN wpstbys_postmeta AS mt1 ON ( wpstbys_posts.ID = mt1.post_id ) LEFT JOIN wpstbys_postmeta AS mt2 ON ( wpstbys_posts.ID = mt2.post_id ) LEFT JOIN wpstbys_postmeta AS mt3 ON ( wpstbys_posts.ID = mt3.post_id AND mt3.meta_key = 'price' ) INNER JOIN wpstbys_term_relationships AS pll_tr ON pll_tr.object_id = wpstbys_posts.ID
WHERE 1=1 AND wpstbys_posts.post_parent = 0 AND (
wpstbys_term_relationships.term_taxonomy_id IN (3732379)
) AND (
( wpstbys_postmeta.meta_key = 'offsale' AND wpstbys_postmeta.meta_value != 'yes' )
AND
( mt1.meta_key = 'canhavechildren' AND mt1.meta_value != '1' )
AND
(
( mt2.meta_key = 'price' AND CAST(mt2.meta_value AS SIGNED) >= '500' )
OR
mt3.post_id IS NULL
)
AND
( wpstbys_postmeta.meta_key = 'offsale' AND wpstbys_postmeta.meta_value != 'yes' )
) AND wpstbys_posts.post_type = 'estates' AND ((wpstbys_posts.post_status = 'publish')) AND pll_tr.term_taxonomy_id IN ( 357958 )
GROUP BY wpstbys_posts.ID
ORDER BY wpstbys_posts.menu_order, wpstbys_posts.post_date DESC
LIMIT 17, 17
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 22133
[post_author] => 0
[post_date] => 2024-02-12 13:38:00
[post_date_gmt] => 2024-02-12 12:38:00
[post_content] =>
[post_title] => Marrakech I Route De Ouarzazate
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5846810-marrakech-i-route-de-ouarzazate
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:04:09
[post_modified_gmt] => 2025-01-18 08:04:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5846810-marrakech-i-route-de-ouarzazate-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 22127
[post_author] => 0
[post_date] => 2024-02-07 15:25:19
[post_date_gmt] => 2024-02-07 14:25:19
[post_content] =>
[post_title] => Marrakech I Palmeraie
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5755712-marrakech-i-palmeraie
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:04:27
[post_modified_gmt] => 2025-01-18 08:04:27
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5755712-marrakech-i-bab-atlas-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 22130
[post_author] => 0
[post_date] => 2024-02-07 15:22:49
[post_date_gmt] => 2024-02-07 14:22:49
[post_content] =>
[post_title] => Marrakech I Route d 'Amizmiz
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5756242-marrakech-i-route-d-amizmiz
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:04:29
[post_modified_gmt] => 2025-01-18 08:04:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5756242-marrakech-i-route-damizmiz-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 22104
[post_author] => 0
[post_date] => 2024-02-02 10:30:44
[post_date_gmt] => 2024-02-02 09:30:44
[post_content] =>
[post_title] => المدينة I مراكش
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5822564-marrakech-i-medina
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:52
[post_modified_gmt] => 2025-01-18 08:03:52
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5822564-marrakech-i-medina-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 22091
[post_author] => 0
[post_date] => 2024-01-26 16:06:56
[post_date_gmt] => 2024-01-26 15:06:56
[post_content] =>
[post_title] => Marrakech I Majorelle
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5826546-marrakech-i-majorelle
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:55
[post_modified_gmt] => 2025-01-18 08:03:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5826546-marrakech-i-majorelle-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 22088
[post_author] => 0
[post_date] => 2024-01-26 12:57:09
[post_date_gmt] => 2024-01-26 11:57:09
[post_content] =>
[post_title] => Marrakech I Majorelle
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5822607-marrakech-i-majorelle
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:53
[post_modified_gmt] => 2025-01-18 08:03:53
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5822607-marrakech-i-majorelle-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 22048
[post_author] => 0
[post_date] => 2023-12-13 16:28:59
[post_date_gmt] => 2023-12-13 15:28:59
[post_content] =>
[post_title] => Marrakech I Route d'Ourika
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5643785-marrakech-i-route-dourika
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:04:55
[post_modified_gmt] => 2025-01-18 08:04:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5643785-marrakech-i-route-dourika-i-belle-etoile-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 22051
[post_author] => 0
[post_date] => 2023-12-13 16:28:50
[post_date_gmt] => 2023-12-13 15:28:50
[post_content] =>
[post_title] => طريق أمزميز I مراكش
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5643861-marrakech-i-route-damizmiz
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:50
[post_modified_gmt] => 2025-01-18 08:03:50
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5643861-marrakech-i-route-damezmiz-i-vallet-verte-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 22036
[post_author] => 0
[post_date] => 2023-12-11 15:42:48
[post_date_gmt] => 2023-12-11 14:42:48
[post_content] =>
[post_title] => مراكش I طريق فيز I حديقة سرية
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5638916-marrakech-i-route-de-fes
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:48
[post_modified_gmt] => 2025-01-18 08:03:48
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5638916-marrakech-i-route-de-fes-i-za-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 22024
[post_author] => 0
[post_date] => 2023-12-01 15:12:28
[post_date_gmt] => 2023-12-01 14:12:28
[post_content] =>
[post_title] => مراكش I المدينة العتيقة
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5627488-marrakech-i-medina
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:44
[post_modified_gmt] => 2025-01-18 08:03:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5627488-marrakech-i-medina-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[10] => WP_Post Object
(
[ID] => 22021
[post_author] => 0
[post_date] => 2023-11-24 14:48:45
[post_date_gmt] => 2023-11-24 13:48:45
[post_content] =>
[post_title] => مراكش I المدينة العتيقة
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5619967-marrakech-i-medina
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:42
[post_modified_gmt] => 2025-01-18 08:03:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5619967-marrakech-i-medina-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[11] => WP_Post Object
(
[ID] => 22009
[post_author] => 0
[post_date] => 2023-11-23 07:56:08
[post_date_gmt] => 2023-11-23 06:56:08
[post_content] =>
[post_title] => مراكش I البالميراي I حديقة الشرق
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5618054-marrakech-i-palmeraie
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:02:13
[post_modified_gmt] => 2025-01-18 08:02:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5618054-marrakech-i-palmeraie-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[12] => WP_Post Object
(
[ID] => 22005
[post_author] => 0
[post_date] => 2023-11-20 13:44:41
[post_date_gmt] => 2023-11-20 12:44:41
[post_content] =>
[post_title] => Marrakech I Palmeraie
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5612234-marrakech-i-palmeraie
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:40
[post_modified_gmt] => 2025-01-18 08:03:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5612234-marrakech-i-palmeraie-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[13] => WP_Post Object
(
[ID] => 21993
[post_author] => 0
[post_date] => 2023-11-17 12:48:52
[post_date_gmt] => 2023-11-17 11:48:52
[post_content] =>
[post_title] => مراكش I سيدي عبد الله غيات I دار الورود
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5611980-marrakech-i-sidi-abdellah-ghiat
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:38
[post_modified_gmt] => 2025-01-18 08:03:38
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5611980-marrakech-i-sidi-abdellah-ghiat-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[14] => WP_Post Object
(
[ID] => 21780
[post_author] => 0
[post_date] => 2023-11-15 14:54:19
[post_date_gmt] => 2023-11-15 13:54:19
[post_content] =>
[post_title] => باب أطلس I مراكش
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5346356-marrakech-i-domaine-bab-atlas
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:05:24
[post_modified_gmt] => 2025-01-18 08:05:24
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5346356-marrakech-i-domaine-bab-atlas-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[15] => WP_Post Object
(
[ID] => 21783
[post_author] => 0
[post_date] => 2023-11-15 14:15:51
[post_date_gmt] => 2023-11-15 13:15:51
[post_content] =>
[post_title] => Marrakech I Route de L'Ourika
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5492512-marrakech-i-route-de-lourika
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:03:34
[post_modified_gmt] => 2025-01-18 08:03:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5492512-marrakech-i-route-de-lourika-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[16] => WP_Post Object
(
[ID] => 21786
[post_author] => 0
[post_date] => 2023-11-15 11:19:24
[post_date_gmt] => 2023-11-15 10:19:24
[post_content] =>
[post_title] => مراكش I بنتهاوس فور سيزونز
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5492527-marrakech-i-penthouse-four-seasons
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:04:44
[post_modified_gmt] => 2025-01-18 08:04:44
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5492527-marrakech-i-penthouse-four-seasons-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 17
[current_post] => -1
[before_loop] => 1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 22133
[post_author] => 0
[post_date] => 2024-02-12 13:38:00
[post_date_gmt] => 2024-02-12 12:38:00
[post_content] =>
[post_title] => Marrakech I Route De Ouarzazate
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 5846810-marrakech-i-route-de-ouarzazate
[to_ping] =>
[pinged] =>
[post_modified] => 2025-01-18 09:04:09
[post_modified_gmt] => 2025-01-18 08:04:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://sothebysrealty.ma/estates/5846810-marrakech-i-route-de-ouarzazate-3/
[menu_order] => 0
[post_type] => estates
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 35
[max_num_pages] => 3
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] => 1
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] => 1
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] =>
[is_post_type_archive] => 1
[query_vars_hash:WP_Query:private] => 4e2be8f3d8c4c05253c0b9b739182ae8
[query_vars_changed:WP_Query:private] => 1
[thumbnails_cached] =>
[allow_query_attachment_by_filename:protected] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
)
