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.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,
G.room_tot,
G.star,
MIN(LEAST((CASE WHEN price_1 > 0 THEN price_1 END), (CASE WHEN price_2 > 0 THEN price_2 END), (CASE WHEN price_3 > 0 THEN price_3 END), (CASE WHEN price_4 > 0 THEN price_4 END), (CASE WHEN price_5 > 0 THEN price_5 END), (CASE WHEN price_6 > 0 THEN price_6 END))) AS min_price,
pro.title,
pro.prom_type,
pro.sale_type,
pro.sale_value,
(CASE WHEN pro.sdate <= NOW() AND NOW() <= pro.edate THEN 1 ELSE 0 END) AS prom_flag,
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
LEFT JOIN promotion pro
ON G.no = pro.goods_no
WHERE ( condo_type LIKE '%ܵ%' AND is_use = 'Y' AND G.cpurl_N NOT LIKE '%,WEB,%' AND G.cpurl_C = 'Y') OR (G.cpurl_C = 'N' AND G.cpurl_Y LIKE '%,WEB,%' AND condo_type LIKE '%ܵ%' AND is_use = 'Y')
GROUP BY G.no
ORDER BY G.main ASC
LIMIT 0,8
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.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,
G.room_tot,
G.star,
MIN(LEAST((CASE WHEN price_1 > 0 THEN price_1 END), (CASE WHEN price_2 > 0 THEN price_2 END), (CASE WHEN price_3 > 0 THEN price_3 END), (CASE WHEN price_4 > 0 THEN price_4 END), (CASE WHEN price_5 > 0 THEN price_5 END), (CASE WHEN price_6 > 0 THEN price_6 END))) AS min_price,
pro.title,
pro.prom_type,
pro.sale_type,
pro.sale_value,
(CASE WHEN pro.sdate <= NOW() AND NOW() <= pro.edate THEN 1 ELSE 0 END) AS prom_flag,
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
LEFT JOIN promotion pro
ON G.no = pro.goods_no
WHERE ( condo_type LIKE '%ܵ%' AND is_use = 'Y' AND G.cpurl_N NOT LIKE '%,WEB,%' AND G.cpurl_C = 'Y') OR (G.cpurl_C = 'N' AND G.cpurl_Y LIKE '%,WEB,%' AND condo_type LIKE '%ܵ%' AND is_use = 'Y')
GROUP BY G.no
ORDER BY G.no DESC
LIMIT 0,12
예약날짜
날짜를 선택해주세요.
인원, 객실
대인1, 소인0, 객실1
인원, 객실
총 182개의 숙소가 있어요!
전체
서울/경기
강원도
충청도
경상도
전라도
제주도
인기순
높은 가격순
낮은 가격순
성급 높은순
성급 낮은순
지역, 숙소명
