Error writing file '/dh/mysql/tmp/#sql67ce_4a6c70_0.frm' (Errcode: 28 - No space left on device) - CREATE TEMPORARY TABLE IF NOT EXISTS links_temp(INDEX(id)) SELECT links.id AS id FROM tags LEFT JOIN links ON links.id=tags.link LEFT JOIN users ON users.id=links.user WHERE state='public' AND tags.tag IN ('twitch','Lhivia') GROUP BY links.id HAVING (COUNT(*)=2)