<head/><div style='color:red; border:1px solid red; padding:10px;'>MySQL 에러: Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")<br>실행 쿼리: 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
LEFT 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 JSON_CONTAINS(atc.tags, '\"listing\"', '$')
AND atc.parent_category NOT IN ('technical_issues', 'access_restricted', 'unavailable')
ORDER BY COALESCE(ts.estimated_monthly_visits, 0) DESC
LIMIT 30 OFFSET 0<br></div>