SELECT DATE_FORMAT(g.wtime,'%Y-%m-%d %h:%i'), IF(g.write_id!='',m.member_nick,g.write_name), g.contents, g.write_id, g.no FROM dash_guestbook g LEFT OUTER JOIN dash_member m ON g.write_id=m.member_id WHERE g.make_id='ko3232' ORDER BY no DESC LIMIT 0,10