네이버
구글에서 마사지알바 를 검색해보세요!
구인등록
카테고리
고객센터
010-4816-4137
-
- 평일
- 평일 12:00 ~ 22:00
-
- 점심시간
- 12:30 ~ 13:30
주말 · 공휴일 휴무
이메일상담moneyajsl@naver.com
계좌번호
209702-04-23797
입금은행
예금주 : 코리아닷컴(임채진)
SELECT DISTINCT
wr_parent,
CASE
WHEN store_gps1 != '' AND store_gps2 != '' THEN
(ACOS(
COS(RADIANS(37.5028778)) * COS(RADIANS(store_gps1)) *
COS(RADIANS(store_gps2) - RADIANS(126.7722687)) +
SIN(RADIANS(37.5028778)) * SIN(RADIANS(store_gps1))
) * 6371)
ELSE 999999
END AS distance_in_km
FROM g5_write_job
WHERE 1 = 1
AND (
store_city_code = '1-156-166'
OR store_city_code LIKE '1-156-166-%'
OR store_city_code LIKE '1-156-166|%'
OR store_city_code LIKE '%|1-156-166'
OR store_city_code LIKE '%|1-156-166-%'
OR store_city_code LIKE '%|1-156-166|%'
)
AND goods_status_admin = 1
AND goods_status = 1
AND (wr_num BETWEEN -3986 AND (-3986 + 1000000))
HAVING distance_in_km <= 1000 OR distance_in_km = 999999
ORDER BY
CASE WHEN goods_date > NOW() THEN 0 ELSE 1 END ASC,
distance_in_km ASC
LIMIT 0, 30;
