SQL запроса:

SELECT   wp67_posts.*
					 FROM wp67_posts  LEFT JOIN wp67_term_relationships ON (wp67_posts.ID = wp67_term_relationships.object_id) INNER JOIN wp67_postmeta ON ( wp67_posts.ID = wp67_postmeta.post_id )
					 WHERE 1=1  AND ( 
  wp67_term_relationships.term_taxonomy_id IN (296)
) AND ( 
  wp67_postmeta.meta_key = 'average_price_week'
) AND wp67_posts.post_type = 'boats' AND ((wp67_posts.post_status = 'publish'))
					 GROUP BY wp67_posts.ID
					 ORDER BY wp67_postmeta.meta_value+0 DESC
					 

Первые 20 постов и meta:

ID: 1186 — title: TOMISLAV — meta: ['4886']
ID: 1166 — title: Scorpio — meta: ['4849.8']
ID: 1145 — title: Moha Vela — meta: ['1760']
ID: 1138 — title: Maria's Pleasure — meta: ['2500']
ID: 1136 — title: Hanna — meta: ['3758']
ID: 1128 — title: Koki — meta: ['1420']
ID: 1104 — title: Maria's Pleasure — meta: ['2500']