SELECT m.*, CONCAT(nd1.addr, ' ', nd2.addr, ' ', nd3.addr) mb_addr FROM (SELECT * FROM g4_member WHERE mb_level=4 or mb_level=5 and member_flag='2') m LEFT JOIN a4_addr nd3 ON (nd3.idx = m.mb_area3) LEFT JOIN a4_addr nd2 ON (nd3.parent = nd2.idx) LEFT JOIN a4_addr nd1 ON (nd2.parent = nd1.idx) ORDER BY rand() LIMIT 0, 12

1 : Can't create/write to file '/tmp/#sql_7f5d_0.MYD' (Errcode: 17)

error file : /plugin/attendance/index.php