Help with an SQL query

Question

I have a working generated SQL query, however I can't work out how I can count it! The GROUP BY function stops a normal COUNT(*) from working.. hope someone can help.

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

Thanks

Dan Grossman · Accepted Answer · 2011-08-09 05:25:48Z

4

Remove the GROUP BY and change the SELECT to only COUNT(DISTINCT wposts.post_content) to get the number of rows this query would have returned.

answered Aug 9, 2011 at 5:25

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mythical Fish Over a year ago

Thank you! I spent ages trying to work this out... should have asked earlier :)

Dzoki · Accepted Answer · 2011-08-09 05:29:06Z

1

SELECT COUNT(DISTINCT wposts.post_content)
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' || ........ 
ORDER BY wposts.post_title ASC

answered Aug 9, 2011 at 5:29

Dzoki

7374 silver badges14 bronze badges

Collectives™ on Stack Overflow

Help with an SQL query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related