No entries found
WordPress database error: [The used table type doesn't support FULLTEXT indexes]
SELECT
DISTINCT posts.*,
CASE
WHEN posts.post_title REGEXP 'teeth|whitening|products'
THEN 1
ELSE 0
END AS keyword_in_title,
MATCH ( posts.post_title, posts.post_content )
AGAINST ( 'teeth whitening products' ) 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-08-08 00:24: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 'teeth|whitening|products' OR posts.post_content REGEXP 'teeth|whitening|products' )
GROUP BY
posts.ID
ORDER BY
keyword_in_title DESC, mysql_score DESC, posts.post_date DESC
LIMIT 0, 5
