WordPress databasefejl: [Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")]
SELECT DISTINCT p.id, p.name, p.slug, p.verified, p.phone, p.website, p.logo_url, p.description, p.hours, p.response_time, COUNT(u.id) AS total_units, SUM(CASE WHEN u.available=1 THEN 1 ELSE 0 END) AS available_units, MIN(u.price_monthly) AS min_price FROM zhju_fdr_providers p JOIN zhju_fdr_units u ON u.provider_id = p.id WHERE u.city LIKE '%Aarhus C%' GROUP BY p.id ORDER BY p.verified DESC, available_units DESC, p.name ASC