![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png){kind=logo}
Opened 13 years ago
Last modified 7 years ago
#25180 new enhancement
Make it possible to select only posts with comment_count > 0
| Reported by: | wonderboymusic | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | Query | Version: | 3.6 |
| Severity: | normal | Keywords: | needs-patch |
| Cc: | Focuses: |
Description
May need this when #11398 goes in.
Change History (5)
Note:
See TracTickets
for help on using tickets.
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.