Title: SQL query don't work
Last modified: September 2, 2016

---

# SQL query don't work

 *  [Fidesio](https://wordpress.org/support/users/fidesio/)
 * (@fidesio)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/sql-query-dont-work/)
 * Hi,
    I had to change the query to properly operate the module.
 * This is my new query :
 * on plugins/wp-likes/likes.php:506
 * From:
    `SELECT post_id, p.post_title AS title,count(post_id) AS num FROM $wpdb-
   >likes,$wpdb->posts as p WHERE p.id=post_id GROUP BY post_id HAVING num>1 ORDER
   BY num DESC LIMIT 5`
 * –>
    To: `SELECT likes.post_id, post.post_title AS title,count(likes.post_id) 
   AS num FROM $wpdb->likes likes,$wpdb->posts post WHERE post.id=likes.post_id 
   GROUP BY likes.post_id ORDER BY num DESC LIMIT 5`

The topic ‘SQL query don't work’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-likes.svg)
 * [WP likes](https://wordpress.org/plugins/wp-likes/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-likes/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-likes/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-likes/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-likes/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-likes/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [Fidesio](https://wordpress.org/support/users/fidesio/)
 * Last activity: [13 years, 4 months ago](https://wordpress.org/support/topic/sql-query-dont-work/)