ببخشید که خاک خوردیم! داریم روی یه چیز فوقالعاده کار میکنیم — زود برمیگردیم!
خطای پایگاهدادهٔ وردپرس : [Table 'ishlandi_famozon.wp_dokan_seller_badge_level' doesn't exist]SELECT sb.*, coalesce(vc.total_vendors,0) AS vendor_count, coalesce(vc.acquired_level_count,0) AS acquired_level_count, coalesce(acquired_data, 0) AS acquired_data FROM (
SELECT badge_id, count(vendor_id) AS total_vendors, acquired_level_count, acquired_data
FROM (
SELECT bl.badge_id, ba.vendor_id, count(ba.level_id) as acquired_level_count, MAX(ba.acquired_data) as acquired_data
FROM wp_dokan_seller_badge_level AS bl
INNER JOIN wp_dokan_seller_badge_acquired AS ba ON ba.level_id = bl.id
WHERE 1=1
GROUP BY bl.badge_id, ba.vendor_id
) AS vendor_count
GROUP BY badge_id
) AS vc RIGHT JOIN wp_dokan_seller_badge AS sb ON sb.id = vc.badge_id WHERE 1=1 ORDER BY sb.id ASC
خطای پایگاهدادهٔ وردپرس : [Table 'ishlandi_famozon.wp_dokan_advertised_products' doesn't exist]SELECT post.id FROM wp_dokan_advertised_products as featured LEFT JOIN wp_posts AS post ON featured.product_id = post.ID WHERE 1=1 AND featured.status = 1 ORDER BY featured.added DESC, featured.id DESC