MySQL 에러: Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")
실행 쿼리: SELECT
country.*,
COUNT(DISTINCT p.product_code) as product_count
FROM destinations country
JOIN destination_hierarchy h ON h.country_name = country.destination_name
JOIN destinations d ON d.destination_ref = h.destination_ref
LEFT JOIN viator_popular_products p ON p.destination_id = d.id
WHERE country.continent_id = 6
AND country.destination_type = 'COUNTRY'
GROUP BY country.id
HAVING product_count > 0
ORDER BY product_count DESC, country.destination_name ASC