|
|
|
|
|
|
|
|
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.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
|
|
|
|
À̺¥Æ®»óǰ
|
|
|
±âºìÁ¸¿©ÇàŬ·´¿¡¼ ÁøÇàÇÏ´Â °¢Á¾ À̺¥Æ®ÀÔ´Ï´Ù.
°èÀýº° Å׸¶º°·Î ÁøÇàµÇ´Â À̺¥Æ® ÆäÀÌÁö¾È¿¡¼ ±¸¹Ì¿¡ ¸Â´Â ¿©ÇàÁö¸¦ ¼±ÅÃÇÏ¿©,
È£ÅÚ, Äܵµ ,Ææ¼Ç µîÀ» º¸´Ù Àú·ÅÇÑ °¡°ÝÀ¸·Î ¿¹¾àÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|