mysql - 帮助进行 SQL 查询

Question

我有一个有效的生成 SQL 查询，但我不知道如何计算它!GROUP BY 函数停止正常的 COUNT(*) 工作。希望有人能提供帮助。

SELECT wposts.* FROM wp_posts wposts, wp_postmeta wpostmeta 
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'phone' 
AND wpostmeta.meta_value = '1542' 
AND wposts.post_status = 'publish' 
AND wposts.post_type = 'tips' || wposts.ID = wpostmeta.post_id 
AND wpostmeta.meta_key = 'phone' 
AND wpostmeta.meta_value = '1541' 
AND wposts.post_status = 'publish' 
AND wposts.post_type = 'tips' || ........ 
GROUP BY wposts.post_content 
ORDER BY wposts.post_title ASC 

谢谢

Answer 1

删除 GROUP BY 并将 SELECT 更改为仅 COUNT(DISTINCT wposts.post_content) 以获取此查询的行数已经回来了。