No entries found
WordPress database error: [The used table type doesn't support FULLTEXT indexes]
SELECT
DISTINCT posts.*,
CASE
WHEN posts.post_title REGEXP 'http|www|google-analytics|com|http|www|google-analytics|com|urchin|js'
THEN 1
ELSE 0
END AS keyword_in_title,
MATCH ( posts.post_title, posts.post_content )
AGAINST ( 'http www google-analytics com http www google-analytics com urchin js' ) 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 18:23: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 'http|www|google-analytics|com|http|www|google-analytics|com|urchin|js' OR posts.post_content REGEXP 'http|www|google-analytics|com|http|www|google-analytics|com|urchin|js' )
GROUP BY
posts.ID
ORDER BY
keyword_in_title DESC, mysql_score DESC, posts.post_date DESC
LIMIT 0, 5
