No entries found
WordPress database error: [The used table type doesn't support FULLTEXT indexes]
SELECT
DISTINCT posts.*,
CASE
WHEN posts.post_title REGEXP 'calcium|carbonate'
THEN 1
ELSE 0
END AS keyword_in_title,
MATCH ( posts.post_title, posts.post_content )
AGAINST ( 'calcium carbonate' ) AS mysql_score
FROM
wp_posts as posts
LEFT JOIN wp_postmeta as postmeta
ON postmeta.post_id = posts.ID
WHERE
posts.post_date_gmt <= '2008-11-23 14:42:00'
AND ( posts.post_password = '' )
AND ( ( post_status = 'publish' AND ( post_type = 'post' OR ( post_type = 'page' AND postmeta.meta_value = 'article.php' ) ) ) )
AND ( posts.post_title REGEXP 'calcium|carbonate' OR posts.post_content REGEXP 'calcium|carbonate' )
GROUP BY
posts.ID
ORDER BY
keyword_in_title DESC, mysql_score DESC, posts.post_date DESC
LIMIT 0, 5
