Query ¼öÇàÀ» ÇÒ ¼ö ¾ø½À´Ï´Ù. Query ³»¿ë : Can't create/write to file '/tmp/#sql_5fa4_0.MYI' (Errcode: 28)=>
SELECT
G.no,
G.is_use,
G.recom,
G.main,
G.name,
G.chain,
G.d_address,
G.condo_type,
G.condo_area,
G.hotel_area,
G.pyung_cnt,
G.thema,
G.d_tel,
G.d_tel2,
G.file1,
G.guide,
G.local,
G.search,
G.area_code,
G.hit,
P.pyung,
P.price_1 AS price,
P.price_2 AS price2,
P.price_3 AS price3
FROM
goods G JOIN goods_pyung P
ON G.no = P.goods_no
WHERE G.is_use = 'Y' AND G.condo_area = '1' AND condo_type='Ææ¼Ç' AND P.idx_view = 1
GROUP BY G.no
ORDER BY main ASC, price_1 ASC
LIMIT 0,50
Query ¼öÇàÀ» ÇÒ ¼ö ¾ø½À´Ï´Ù. Query ³»¿ë : Can't create/write to file '/tmp/#sql_5fa4_0.MYI' (Errcode: 28)=>
SELECT
G.no,
G.is_use,
G.recom,
G.main,
G.name,
G.chain,
G.d_address,
G.condo_type,
G.condo_area,
G.hotel_area,
G.pyung_cnt,
G.thema,
G.d_tel,
G.d_tel2,
G.file1,
G.guide,
G.local,
G.search,
G.area_code,
G.hit,
P.pyung,
P.price_1 AS price,
P.price_2 AS price2,
P.price_3 AS price3
FROM
goods G JOIN goods_pyung P
ON G.no = P.goods_no
WHERE G.is_use = 'Y' AND G.condo_area = '1' AND condo_type='Ææ¼Ç' AND P.idx_view = 1
GROUP BY G.no
ORDER BY G.hit DESC
LIMIT 0,15
Query ¼öÇàÀ» ÇÒ ¼ö ¾ø½À´Ï´Ù. Query ³»¿ë : Can't create/write to file '/tmp/#sql_5fa4_0.MYI' (Errcode: 28)=>
SELECT
G.no,
G.is_use,
G.recom,
G.main,
G.name,
G.chain,
G.d_address,
G.condo_type,
G.condo_area,
G.hotel_area,
G.pyung_cnt,
G.thema,
G.d_tel,
G.d_tel2,
G.file1,
G.guide,
G.local,
G.search,
G.area_code,
G.hit,
P.pyung,
P.price_1 AS price,
P.price_2 AS price2,
P.price_3 AS price3
FROM
goods G JOIN goods_pyung P
ON G.no = P.goods_no
WHERE G.is_use = 'Y' AND P.price_1 > 0 AND recom > 0 AND P.idx_view = 1
GROUP BY G.no
ORDER BY main ASC
LIMIT 0,10