Query ¼öÇàÀ» ÇÒ ¼ö ¾ø½À´Ï´Ù.
Query ³»¿ë : Can't create/write to file '/tmp/#sql_586_2.MYI' (Errcode: 28)=> SELECT G.no, G.is_use, G.recom, G.main, G.key1, G.key2, G.name, G.sub_guide, G.chain, G.condo_type, G.goods_type, G.condo_area, G.pyung_cnt, G.thema, G.d_tel, G.d_tel2, G.file1, G.file7, G.guide, G.local, G.search, G.area_code, G.hit, G.cpurl_Y, G.d_address, P.pyung, P.no AS p_no, P.price_1 AS price, P.price_5_o AS price4, P.price_5 AS price2, P.price_6 AS price3 FROM goods G JOIN ( select * from goods_pyung order by view_idx ASC) P ON G.no = P.goods_no WHERE ((G.search LIKE '%%B4%EB%B8%ED%B8%AE%C1%B6%C6%AE%') OR (name LIKE '%%B4%EB%B8%ED%B8%AE%C1%B6%C6%AE%') ) AND is_use = 'Y' GROUP BY G.no ORDER BY G.name ASC LIMIT 0,15 ÀÌÂüÁ¶Àº·¹Àú
 
    Query ¼öÇàÀ» ÇÒ ¼ö ¾ø½À´Ï´Ù.
    Query ³»¿ë : Can't create/write to file '/tmp/#sql_586_2.MYI' (Errcode: 28)=> SELECT G.no, G.is_use, G.recom, G.main, G.key1, G.key2, G.name, G.sub_guide, G.chain, G.condo_type, G.goods_type, G.condo_area, G.pyung_cnt, G.thema, G.d_tel, G.d_tel2, G.file1, G.file7, G.guide, G.local, G.search, G.area_code, G.hit, G.cpurl_Y, G.d_address, P.pyung, P.no AS p_no, P.price_1 AS price, P.price_5_o AS price4, P.price_5 AS price2, P.price_6 AS price3 FROM goods G JOIN ( select * from goods_pyung order by view_idx ASC) P ON G.no = P.goods_no WHERE is_use = 'Y' GROUP BY G.no ORDER BY G.no DESC LIMIT 0,100
 

ÃÑ %B4%EB%B8%ED%B8%AE%C1%B6%C6%AEÀÇ Å°¿öµå·Î 0°³ÀÇ ¼÷¹Ú½Ã¼³ÀÌ °Ë»öµÇ¾ú½À´Ï´Ù.