Error writing file '/dh/mysql/tmp/#sql67ce_4a6699_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 user=1190 AND state='public' AND tags.tag IN ('redsunsetmaple') GROUP BY links.id HAVING (COUNT(*)=1)