WordPress database error: [Table 'u169885079_db5.ab_ml_djs' doesn't exist]
SELECT d.*, COUNT(b.id) as total_bookings, SUM(CASE WHEN b.status = 'completed' THEN b.total_cost ELSE 0 END) as total_revenue, AVG(CASE WHEN b.rating IS NOT NULL THEN b.rating ELSE NULL END) as avg_rating FROM ab_ml_djs d LEFT JOIN ab_ml_bookings b ON d.id = b.dj_id GROUP BY d.id ORDER BY d.first_name, d.last_name