Query 수행을 할 수 없습니다. Query 내용 : Can't create/write to file '/tmp/#sql_4fc_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 AS price2,
P.price_6 AS price3
FROM
goods G JOIN goods_pyung P
ON G.no = P.goods_no
WHERE G.condo_type != '펜션' AND G.condo_type != '콘도' AND G.recom > 0 AND is_use = 'Y' AND P.price_1 > 1000
GROUP BY G.no
ORDER BY G.main ASC
LIMIT 0,5
Query 수행을 할 수 없습니다. Query 내용 : Can't create/write to file '/tmp/#sql_4fc_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 AS price2,
P.price_6 AS price3
FROM
goods G JOIN goods_pyung P
ON G.no = P.goods_no
WHERE G.condo_type != '펜션' AND G.condo_type != '콘도' AND is_use = 'Y' AND P.price_1 > 1000
GROUP BY G.no
ORDER BY G.main ASC
LIMIT 60,10
1박2일 여행사
