Related Entries
WordPress database error: [The used table type doesn't support FULLTEXT indexes]
SELECT
DISTINCT posts.*,
MATCH ( posts.post_title, posts.post_content )
AGAINST ( 'cult of celebrity white smile tissue irritation latest innovations soft tissues cosmetic dentistry tooth sensitivity bleaching agent mild irritation physical perfection remedial work cleanings digital cameras dental surgery mouthpiece cavities gums contact lens toothpaste sparkle' ) 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 <= '2009-07-04 07:54:00'
AND posts.ID <> 58
AND ( posts.post_password = '' )
AND ( post_status = 'publish' AND ( post_type = 'post' OR ( post_type = 'page' AND postmeta.meta_value = 'article.php' ) ) )
GROUP BY
posts.ID
ORDER BY
mysql_score DESC
LIMIT 5