質問編集履歴
1
AS w をfeに修正しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -17,7 +17,7 @@
|
|
|
17
17
|
FROM user AS u JOIN follow AS fo ON fo.followUserId = u.userId
|
|
18
18
|
LEFT OUTER JOIN whisperCntView AS w ON u.userId = w.userId
|
|
19
19
|
LEFT OUTER JOIN followCntView AS f ON u.userId = f.userId
|
|
20
|
-
LEFT OUTER JOIN followerCntView AS
|
|
20
|
+
LEFT OUTER JOIN followerCntView AS fe ON u.userId = fe.followUseId
|
|
21
21
|
WHERE fo.userId = ?";
|
|
22
22
|
|
|
23
23
|
$stmt = mysqli_prepare($mysqli, $query);
|