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 (295)
) 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: 1208 — title: Kaja — meta: ['16900']
ID: 1207 — title: Dali — meta: ['5580']
ID: 1203 — title: Altea — meta: ['4080']
ID: 1200 — title: Art Vandelay — meta: ['4912.3076923077']
ID: 1193 — title: Salona 45 Performance — meta: ['4338.6']
ID: 1187 — title: Zora — meta: ['1102.4']
ID: 1184 — title: Sun — meta: ['5030.8']
ID: 1179 — title: JADRANKO — meta: ['17800']
ID: 1171 — title: Manu test — meta: ['6486']
ID: 1163 — title: Majandra — meta: ['5304.6']
ID: 1158 — title: Lotus 2111 — meta: ['3580']
ID: 1155 — title: KRISTINA I — meta: ['3516.8']
ID: 1153 — title: Klementina — meta: ['3700']
ID: 1152 — title: Zanzibar — meta: ['7377.2']
ID: 1148 — title: Roza — meta: ['6314.4']
ID: 1147 — title: Albe — meta: ['6155.4']
ID: 1142 — title: Riki2 — meta: ['1360']
ID: 1130 — title: Kriza — meta: ['2040']
ID: 1125 — title: Moonlight — meta: ['1118']
ID: 1122 — title: Whispper — meta: ['712']