php - 如何从查询中获取总计数？

Question

这是我的问题

SELECT  a.id,
        a.venue_id, 
        a.user_id, 
        m1.profilenam AS user_profilename,
        m1.photo_thumb AS user_photo_thumb,
        m2.profilenam AS venue_profilename, 
        m2.photo_thumb AS venue_photo_thumb 
FROM announce_arrival AS a 
    INNER JOIN members AS m1 
        ON a.user_id = m1.mem_id
    INNER JOIN members AS m2 
        ON a.venue_id = m2.mem_id
GROUP BY a.venue_id, a.user_id
LIMIT 0,10 
ORDER BY date DESC,
         time DESC

我如何在这个查询中使用 count(*)，我这样使用

SELECT DISTINCT COUNT(*) 
 FROM announce_arrival AS a       
 INNER JOIN members as m1 ON (a.user_id = m1.mem_id)
 INNER JOIN members as m2 ON (a.venue_id= m2.mem_id)
 GROUP BY a.venue_id, a.user_id LIMIT 0,10  ORDER BY date DESC,time DESC;

但它的显示数数(*)73个1

我想要总数。

Answer 1

您可以将查询包装到 select count(*) 中，如下所示:

SELECT COUNT(*) FROM
  (SELECT a.id,a.venue_id, a.user_id, m1.profilenam as
    user_profilename,m1.photo_thumb AS user_photo_thumb,m2.profilenam AS
    venue_profilename, m2.photo_thumb AS venue_photo_thumb FROM announce_arrival
    AS a INNER JOIN members as m1 ON (a.user_id = m1.mem_id) INNER JOIN members
    as m2 ON (a.venue_id= m2.mem_id) GROUP BY a.venue_id, a.user_id)