WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's a quick way to do it:</p> <ol> <li>open window media player</li> <li>then g' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('<p>whatever you may think about microsoft, they do make some good software. one of their best is windows media player which is free and is installed on all windows pcs. capturing screenshots from your favorite videos can be difficult, but here's a quick way to do it:</p> <ol> <li>open window media player</li> <li>then go to 'tools | options'</li> <li>in options, select the performance tab</li> <li>click the advanced button</li> <li>untick 'use overlays'</li> <li>click 'ok'</li> </ol> <p>once you've finished these steps all you have to do to capture a screenshot is to pause your video, and press the 'print screen' key on your keyboard. then go to your favorite image program and paste the image or press 'ctrl' and 'v' together. </p> ')) as bodyscore, (MATCH (post_title) AGAINST ('how to capture screenshots from windows media player')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('<p>whatever you may think about microsoft, they do make some good software. one of their best is windows media player which is free and is installed on all windows pcs. capturing screenshots from your favorite videos can be difficult, but here's a quick way to do it:</p> <ol> <li>open window media player</li> <li>then go to 'tools | options'</li> <li>in options, select the performance tab</li> <li>click the advanced button</li> <li>untick 'use overlays'</li> <li>click 'ok'</li> </ol> <p>once you've finished these steps all you have to do to capture a screenshot is to pause your video, and press the 'print screen' key on your keyboard. then go to your favorite image program and paste the image or press 'ctrl' and 'v' together. </p> ')) * 3+ (MATCH (post_title) AGAINST ('how to capture screenshots from windows media player')) * 3+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score from wp_posts left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 27 ) left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = 'post_tag') left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 27 ) left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wp_posts.ID) left JOIN wp_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 != '27') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 8 order by score DESC limit 6