select no, name, discount, area, address, picture1, comment, p_picture1, p_name1, point1, point2, point3, pcount, reveal, recommend1, recommend2, recommend3, recommend4, recommend5, search_banner, main_banner, if(picture1 = '', 0, 1) as exist, point1 + point2 + point3 as point, (point1 + point2 + point3) / pcount as score from consulting where no != '' order by exist desc, no desc limit 0, 5
Á¦ÀÌÆä¾î :: ´ëÇѹα¹ ¿þµùÆ÷Å»-¿¹½ÄÀå,»ó°ß·Ê,¿þµùµå·¹½º,½ºÆ©µð¿À,Çã´Ï¹®,¿¹¹°,ûøÀå,µîµî
|
|
|
|

|
¾÷ü¸í: Æ÷À¯¿þµù
|

|
Áö¿ª: ±¤ÁÖ±¤¿ª½Ã µ¿±¸ ±¤»êµ¿ 1
|

|
À̸§: Ç÷¡³Ê
|
|
|
|
|

|
¾÷ü¸í: ÀÌÁê¿þµù
|

|
Áö¿ª: ºÎ»ê±¤¿ª½Ã ¼ö¿µ±¸ ±¤¾È2
|

|
À̸§: Ç÷¡³Ê
|
|
|
|
|
|

|
Àüü¸®½ºÆ®
|
|
|
|
Çì¶óÀÇ ¿þµùÄɾî
°³²±¸ ¿ª»ïµ¿ 708-26
¹ÚÈ¿µ ¿øÀå Ç÷¡³Ê
|
|
½ÅºÎŬ·´ÄÁ¼³ÆÃ»ç¾÷ºÎ
°³²±¸ ³íÇöµ¿ 131-13
½ÅºÎŬ·´¸ÅÀå Ç÷¡³Ê
|
|
¸¶ÀÌ¿þµùÇ÷¡³Ê
´ëÀü½Ã Áß±¸ ÀºÇൿ 3
Ç÷¡³Ê
|
|
¿þµùÄð
´ë±¸½Ã Áß±¸ µ¿ÀÎ4°¡
¹Ú¹Ì³ª Ç÷¡³Ê
|
|
ÀÌÁê¿þµù
ºÎ»ê±¤¿ª½Ã ¼ö¿µ±¸
Ç÷¡³Ê
|
|
|
|
|
|
|