WordPress database error: [Got error 28 from storage engine]
SELECT ID, post_title, post_date, post_content, post_excerpt, (MATCH (post_content) AGAINST ('mce_jquery resp var msg mce value index fields function response result else input_id f html parts moz show parent fnames')) as bodyscore, (MATCH (post_title) AGAINST ('live video breakdown century 21st')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('mce_jquery resp var msg mce value index fields function response result else input_id f html parts moz show parent fnames')) * 3+ (MATCH (post_title) AGAINST ('live video breakdown century 21st')) * 3+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_s6fbmd_posts
left JOIN wp_s6fbmd_term_relationships AS thistag ON (thistag.object_id = 252 )
left JOIN wp_s6fbmd_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_s6fbmd_posts.ID)
left JOIN wp_s6fbmd_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_s6fbmd_term_relationships AS thiscat ON (thiscat.object_id = 252 )
left JOIN wp_s6fbmd_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_s6fbmd_posts.ID)
left JOIN wp_s6fbmd_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '252') and post_date <= '2012-02-06 03:42:25' and post_password ='' and post_type IN ('post', 'page')
group by id
having score >= 5 order by score DESC limit 5
Check out this latest video from Green Day featuring 21st Century Breakdown performed live at the Uptown Club. I’m loving the song and the video. Great preview to what their live show is going to be. Enjoy
No related posts.
WordPress database error: [Got error 28 from storage engine]
SELECT t.*, tt.* FROM wp_s6fbmd_terms AS t INNER JOIN wp_s6fbmd_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_s6fbmd_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('post_tag') AND tr.object_id IN (252) ORDER BY t.name ASC