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