質問編集履歴
3
文言修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -42,7 +42,7 @@
|
|
|
42
42
|
|
|
43
43
|
|
|
44
44
|
|
|
45
|
-
UNIONを使って以下のようにしてみたけど、
|
|
45
|
+
UNIONを使って以下のようにしてみたけど、正しい値が出力されないです。
|
|
46
46
|
|
|
47
47
|
|
|
48
48
|
|
2
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -48,11 +48,11 @@
|
|
|
48
48
|
|
|
49
49
|
```sql
|
|
50
50
|
|
|
51
|
-
(SELECT *,(6371 * ACOS(COS(RADIANS(35.694003)) * COS(RADIANS(add_lat)) * COS(RADIANS(add_long) - RADIANS(139.753595)) + SIN(RADIANS(35.694003)) * SIN(RADIANS(add_lat)))) AS distance FROM item WHERE state = 1 HAVING distance <= 25 ORDER BY distance)
|
|
51
|
+
(SELECT *,(6371 * ACOS(COS(RADIANS(35.694003)) * COS(RADIANS(add_lat)) * COS(RADIANS(add_long) - RADIANS(139.753595)) + SIN(RADIANS(35.694003)) * SIN(RADIANS(add_lat)))) AS distance FROM item WHERE state = 1 HAVING distance <= 25 ORDER BY distance)
|
|
52
52
|
|
|
53
53
|
UNION
|
|
54
54
|
|
|
55
|
-
(SELECT * FROM item WHERE state = 1 AND add_city = '千代田区');
|
|
55
|
+
(SELECT *,(6371 * ACOS(COS(RADIANS(35.694003)) * COS(RADIANS(add_lat)) * COS(RADIANS(add_long) - RADIANS(139.753595)) + SIN(RADIANS(35.694003)) * SIN(RADIANS(add_lat)))) AS distance FROM item WHERE state = 1 AND add_city = '千代田区');
|
|
56
56
|
|
|
57
57
|
```
|
|
58
58
|
|
1
補足
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -59,3 +59,11 @@
|
|
|
59
59
|
|
|
60
60
|
|
|
61
61
|
難解な処理をしようとしているため、説明が難しく、ツッコミをいただけましたら、補足をくわえさせていただきます。
|
|
62
|
+
|
|
63
|
+
|
|
64
|
+
|
|
65
|
+
## 補足
|
|
66
|
+
|
|
67
|
+
|
|
68
|
+
|
|
69
|
+
Bでは千代田区内のみを抽出するのですが、Aでは基準点から半径25km以内のレコードも取得しているので、その差分をBに加えるという処理を行いたいです
|