1892 页面推荐
SQL架构
Create table If Not Exists Friendship_1892 (user1_id int, user2_id int);
Create table If Not Exists Likes_1892 (user_id int, page_id int);
Truncate table Friendship_1892;
insert into Friendship_1892 (user1_id, user2_id) values ('1', '2');
insert into Friendship_1892 (user1_id, user2_id) values ('1', '3');
insert into Friendship_1892 (user1_id, user2_id) values ('1', '4');
insert into Friendship_1892 (user1_id, user2_id) values ('2', '3');
insert into Friendship_1892 (user1_id, user2_id) values ('2', '4');
insert into Friendship_1892 (user1_id, user2_id) values ('2', '5');
insert into Friendship_1892 (user1_id, user2_id) values ('6', '1');
Truncate table Likes_1892;
insert into Likes_1892 (user_id, page_id) values ('1', '88');
insert into Likes_1892 (user_id, page_id) values ('2', '