Title: My SQL syntax
Last modified: August 21, 2016

---

# My SQL syntax

 *  [Mia1031](https://wordpress.org/support/users/mia1031/)
 * (@mia1031)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/my-sql-syntax/)
 * Hi,
    Can you help me what this error means and how to fix this? I just uploaded
   this plugin but not sure if this is why I’m getting an error now and not before.
 * [You have an error in your SQL syntax; check the manual that corresponds to your
   MySQL server version for the right syntax to use near ‘GROUP BY YEAR(post_date_gmt),
   MONTH(post_date_gmt)’ at line 1]
    SELECT DISTINCT YEAR(post_date_gmt) AS `year`,
   MONTH(post_date_gmt) AS `month`, MAX(post_date_gmt) as last_mod, count(ID) as
   posts FROM `wp_posts` WHERE post_date < ‘2013-04-11 17:15:45’ AND post_status
   = ‘publish’ AND post_type = ‘post’ ORDER BY post_date_gmt DESC GROUP BY YEAR(
   post_date_gmt),MONTH(post_date_gmt)
 * Thanks,
    Mia1031

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

 *  [Andrew Nevins](https://wordpress.org/support/users/anevins/)
 * (@anevins)
 * WCLDN 2018 Contributor | Volunteer support
 * [12 years, 12 months ago](https://wordpress.org/support/topic/my-sql-syntax/#post-3648095)
 * Use this tool for debugging SQL syntax errors
    [http://developer.mimer.se/validator/parser200x/index.tml#parser](http://developer.mimer.se/validator/parser200x/index.tml#parser)
 *  Thread Starter [Mia1031](https://wordpress.org/support/users/mia1031/)
 * (@mia1031)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/my-sql-syntax/#post-3648104)
 * Thanks Andrew,
    Where do I debug and change the SQL in wordpress though? PHP 
   files?
 *  [Andrew Nevins](https://wordpress.org/support/users/anevins/)
 * (@anevins)
 * WCLDN 2018 Contributor | Volunteer support
 * [12 years, 12 months ago](https://wordpress.org/support/topic/my-sql-syntax/#post-3648106)
 * Which plugin is it?

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

The topic ‘My SQL syntax’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Andrew Nevins](https://wordpress.org/support/users/anevins/)
 * Last activity: [12 years, 12 months ago](https://wordpress.org/support/topic/my-sql-syntax/#post-3648106)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics