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
목록
