WordPress.org
Get WordPress

Make WordPress Core

Opened 11 years ago

Last modified 5 years ago

#25180 new enhancement

Make it possible to select only posts with comment_count > 0

Reported by: wonderboymusic's profile wonderboymusic Owned by:
Milestone: Priority: normal
Severity: normal Version: 3.6
Component: Query Keywords: needs-patch
Focuses: Cc:

Description

May need this when #11398 goes in.

Change History (5)

#1 @nacin
11 years ago

Specifically this IRC discussion: ​http://irclogs.wordpress.org/chanlog.php?channel=wordpress-dev&day=2013-08-29&sort=asc#m677727

For #11398, you can order by comment_date. The problem being, any posts without comments are fetched and stuck at the bottom.

That ORDER BY plus WHERE comment_count > 0 means we get only posts with comments. Though at that point it would be cheaper to convert to the LEFT JOIN to an INNER JOIN.

#2 @DrewAPicture
11 years ago

This seems more like an enhancement. @wonderboymusic: Any plans to proceed with this?

#3 @johnbillion
11 years ago

  • Milestone changed from 3.7 to Future Release
  • Type changed from defect (bug) to enhancement

Dependent on #11398.

#4 @SergeyBiryukov
11 years ago

  • Version changed from trunk to 3.6

#5 @chriscct7
9 years ago

  • Keywords needs-patch added
Note: See TracTickets for help on using tickets.