Wordpress database query running slow - one of the columns doesn't exist!

Posted by Pavel on Stack Overflow See other posts from Stack Overflow or by Pavel
Published on 2010-06-10T09:10:57Z Indexed on 2010/06/10 9:12 UTC
Read the original article Hit count: 237

Filed under:
|

Hi there. I'm having some problems with the query that wordpress runs. That's the one:

SELECT DISTINCT ID,post_title,post_date,post_content,MATCH(post_title,post_content) AGAINST ('S') AS score FROM wp_posts WHERE MATCH (post_title,post_content) AGAINST ('S') AND post_date <= 'S' AND post_status = 'S' AND id != N AND post_type = 'S' ORDER BY score DESC

When I'm running this query in phpmyadmin it says that N column doesn't exist so clause "AND id != N" si not making any sense. I ran the query again without this clause and db behaved like fully optimized one. Please can someone give me a hint on that? My questions are: What this clause is used for? What wordpress is trying to find by running this and Can I modify core wordpress files to get rid of this clause? Any response or help greatly appreciated!!

© Stack Overflow or respective owner

Related posts about database

Related posts about Wordpress