اگر میخواهی بنویس:
**نسخه Auto‑Integrate**
posts} p
LEFT JOIN {$wpdb->postmeta} price
ON price.post_id=p.ID AND price.meta_key='_price'
LEFT JOIN {$wpdb->postmeta} stock
ON stock.post_id=p.ID AND stock.meta_key='_stock_status'
LEFT JOIN {$wpdb->postmeta} sales
ON sales.post_id=p.ID AND sales.meta_key='total_sales'
LEFT JOIN {$wpdb->postmeta} thumb
ON thumb.post_id=p.ID AND thumb.meta_key='_thumbnail_id'
WHERE p.post_type='product'
AND p.post_status='publish'
AND stock.meta_value='instock'
ORDER BY CAST(sales.meta_value AS UNSIGNED) DESC
";
$results = $wpdb->get_results($query, ARRAY_A);
if($type == 'json'){
echo '[';
$first = true;
foreach($results as $r){
if(!$first) echo ',';
$first = false;
$img = $r['image_id'] ? wp_get_attachment
