Title: SQL query trouble
Last modified: August 18, 2016

---

# SQL query trouble

 *  [esky](https://wordpress.org/support/users/esky/)
 * (@esky)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/sql-query-trouble/)
 * I made my problem into a picture to better illustrate what’s happening:
 * [http://dodnation.net/problem.png](http://dodnation.net/problem.png)
 * I want to show recent posts in this format:
    month/day: post title (comment count)
 * However my attempts either filter out uncommented posts or don’t count the comments
   correctly…

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [esky](https://wordpress.org/support/users/esky/)
 * (@esky)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/sql-query-trouble/#post-271613)
 * Here is my full code… like I said, all I want is a little box that has my latest
   posts and their comment count (or 0 if no comments)…
 * [http://dodnation.net/get_newsposts.txt](http://dodnation.net/get_newsposts.txt)
 *  [jaseone](https://wordpress.org/support/users/jaseone/)
 * (@jaseone)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/sql-query-trouble/#post-271614)
 * Do some Googling on MySQL outer joins as you want to do an outer join to the 
   comments table.
 *  Thread Starter [esky](https://wordpress.org/support/users/esky/)
 * (@esky)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/sql-query-trouble/#post-271809)
 * Could you please be more specific? I’m rather new to SQL… also, I can’t be the
   first person to attempt to display posts with their comment counts next to them
   like that.. but I failed to find anything pointing me how to do this 🙁

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL query trouble’ is closed to new replies.

## Tags

 * [count](https://wordpress.org/support/topic-tag/count/)
 * [recent](https://wordpress.org/support/topic-tag/recent/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [esky](https://wordpress.org/support/users/esky/)
 * Last activity: [20 years, 7 months ago](https://wordpress.org/support/topic/sql-query-trouble/#post-271809)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics