MySQL 에러: Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")
실행 쿼리: SELECT
atu.id,
atu.url,
atc.parent_category,
atc.sub_category,
atc.short_name,
atc.long_name,
atc.description,
atc.tags,
atc.pricing_model,
atc.starting_price,
ac.display_name_ko as category_name_ko,
ac.display_name_en as category_name_en
FROM ai_tool_urls atu
INNER JOIN ai_tool_categorizations atc ON atu.id = atc.tool_id
INNER JOIN ai_tool_categories ac ON atc.sub_category = ac.sub_category
LEFT JOIN traffic_stats ts ON atu.id = ts.tool_id
AND ts.created_at = (
SELECT MAX(created_at)
FROM traffic_stats ts2
WHERE ts2.tool_id = atu.id
)
WHERE atc.parent_category NOT IN ('technical_issues', 'access_restricted', 'unavailable') AND (atc.parent_category = 'text_ai' OR
atu.id IN (SELECT tool_id FROM ai_tool_additional_categories
WHERE parent_category = 'text_ai'))
ORDER BY COALESCE(ts.estimated_monthly_visits, 0) DESC, atc.categorized_at DESC
LIMIT 20 OFFSET 180