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 "gulf cartel"and "traffickers based in the western state of sinaloa" headed by' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('two rival mexican drug gangs ar taunting each other by posting videos on youtube of their bloody victims on youtube, according to reuters. the war between the north eastern mexico's "gulf cartel"and "traffickers based in the western state of sinaloa" headed by joaquin 'el chapo' guzman - last year claimed more than 2,000 victims. <!--more--><a href="http://www.connectedinternet.co.uk/wp-content/uploads/drug_war_victim.jpg" title="gang war victim"><img src="http://www.connectedinternet.co.uk/wp-content/uploads/drug_war_victim.thumbnail.jpg" title="gang war victim" alt="gang war victim" align="left" /></a> in one youtube post, a user "offers about $4,500 to anyone who can show proof of having killed members of the zetas, 'via photo, video or presenting the body'. i'm surprised that youtube haven't been removing the videos. one video shows a man being shot in the head, and another a series of photos showing "an execution victim, his missing face a mangled mess of flesh". i guess as long as there are no copyright issues, youtube doesn't care.')) as bodyscore, (MATCH (post_title) AGAINST ('nsfw: mexican drug gangs taunt each other on youtube by showing dead rivals')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('two rival mexican drug gangs ar taunting each other by posting videos on youtube of their bloody victims on youtube, according to reuters. the war between the north eastern mexico's "gulf cartel"and "traffickers based in the western state of sinaloa" headed by joaquin 'el chapo' guzman - last year claimed more than 2,000 victims. <!--more--><a href="http://www.connectedinternet.co.uk/wp-content/uploads/drug_war_victim.jpg" title="gang war victim"><img src="http://www.connectedinternet.co.uk/wp-content/uploads/drug_war_victim.thumbnail.jpg" title="gang war victim" alt="gang war victim" align="left" /></a> in one youtube post, a user "offers about $4,500 to anyone who can show proof of having killed members of the zetas, 'via photo, video or presenting the body'. i'm surprised that youtube haven't been removing the videos. one video shows a man being shot in the head, and another a series of photos showing "an execution victim, his missing face a mangled mess of flesh". i guess as long as there are no copyright issues, youtube doesn't care.')) * 1+ (MATCH (post_title) AGAINST ('nsfw: mexican drug gangs taunt each other on youtube by showing dead rivals')) * 1+ 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 = 1538 ) 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 = 1538 ) 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 != '1538') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7