WordPress database error: [Table 'u156066740_7LryK.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
