56,678
社区成员
发帖
与我相关
我的任务
分享
mysql> select * from table_log_site;
+--------+------------+-----------+---------+---------+
| m_date | m_requests | m_accepts | site_id | user_id |
+--------+------------+-----------+---------+---------+
| 123456 | 4 | 3 | 1 | 1 |
| 123456 | 5 | 4 | 2 | 1 |
| 123456 | 6 | 5 | 1 | 2 |
| 123456 | 7 | 6 | 2 | 2 |
+--------+------------+-----------+---------+---------+
4 rows in set (0.00 sec)
mysql> select * from table_sites_type_urls;
+---------+---------------+
| site_id | sites_type_id |
+---------+---------------+
| 1 | 2 |
| 1 | 3 |
| 2 | 4 |
| 2 | 5 |
+---------+---------------+
4 rows in set (0.00 sec)
mysql> select user_id,sum(m_requests) as total_request,
-> (select count(*)
-> from table_sites_type_urls a inner join table_log_site b using(site_id)
-> where b.user_id=t.user_id
-> ) as total_sites_type
-> from table_log_site t
-> group by user_id;
+---------+---------------+------------------+
| user_id | total_request | total_sites_type |
+---------+---------------+------------------+
| 1 | 9 | 4 |
| 2 | 13 | 4 |
+---------+---------------+------------------+
2 rows in set (0.00 sec)
mysql>