Query ¼öÇàÀ» ÇÒ ¼ö ¾ø½À´Ï´Ù.
Query ³»¿ë : Can't create/write to file '/tmp/#sql_586_0.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.condo_area = '5' AND G.condo_type = 'Ææ¼Ç' AND is_use = 'Y'
GROUP BY G.no
ORDER BY G.idx ASC
LIMIT 0,50
|
Àü±¹ ¼÷¹Ú»óǰ ã±â
|
|||||||||
Query ³»¿ë : Can't create/write to file '/tmp/#sql_586_0.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.condo_area = '5' AND G.condo_type = 'Ææ¼Ç' AND is_use = 'Y' GROUP BY G.no ORDER BY G.idx ASC LIMIT 0,100 |
|
||||||||
|
|||||||||