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 'reilly of o'reilly media, has published a draft proposal for a <a href="http://r' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('tim o'reilly of o'reilly media, has published a draft proposal for a <a href="http://radar.oreilly.com/archives/2007/04/draft_bloggers_1.html" title="draft blogging code of conduct" target="_blank">blogging code of conduct</a> based on the <a href="http://blogher.org/community-guidelines">blogher community guidelines</a>. this has come about after the kathy sierra episode. full draft below: <!--more--> <blockquote> we celebrate the blogosphere because it embraces frank and open conversation. but frankness does not have to mean lack of civility. we present this blogger code of conduct in hopes that it helps create a culture that encourages both personal expression and constructive conversation.1. we take responsibility for our own words and for the comments we allow on our blog. we are committed to the "civility enforced" standard: we will not post unacceptable content, and we'll delete comments that contain it. we define unacceptable content as anything included or linked to that: - is being used to abuse, harass, stalk, or threaten others - is libelous, knowingly false, ad-hominem, or misrepresents another person, - infringes upon a copyright or trademark - violates an obligation of confidentiality - violates the privacy of others we define and determine what is "unacceptable content" on a case-by-case basis, and our definitions are not limited to this list. if we delete a comment or link, we will say so and explain why. [we reserve the right to change these standards at any time with no notice.] 2. we won't say anything online that we wouldn't say in person. 3. we connect privately before we respond publicly. when we encounter conflicts and misrepresentation in the blogosphere, we make every effort to talk privately and directly to the person(s) involved--or find an intermediary who can do so--before we publish any posts or comments about the issue. 4. when we believe someone is unfairly attacking another, we take action. when someone who is publishing comments or blog postings that are offensive, we'll tell them so (privately, if possible--see above) and ask them to publicly make amends. if those published comments could be construed as a threat, and the perpetrator doesn't withdraw them and apologize, we will cooperate with law enforcement to protect the target of the threat. 5. we do not allow anonymous comments. we require commenters to supply a valid email address before they can post, though we allow commenters to identify themselves with an alias, rather than their real name. 6. we ignore the trolls. we prefer not to respond to nasty comments about us or our blog, as long as they don't veer into abuse or libel. we believe that feeding the trolls only encourages them--"never wrestle with a pig. you both get dirty, but the pig likes it." ignoring public attacks is often the best way to contain them.</blockquote> it's rare that i agree with what <a href="http://scobleizer.com/2007/04/08/code-of-conduct-or-not/" title="scoble" target="_blank">scoble writes</a>, but i think he is right that rules 3, 5 and 6 are unnecessary. one of the reasons i blog is i like to hear the views of many other people. it's one of the reasons i started the <a href="http://www.connectedinternet.co.uk/forum/" title="forum" target="_blank">connected internet forum </a>for discussion that doesn't live within a particular post.  i also don't have a problem with anonymous comments and trolls. at the moment i let anything through as long as it's not in breach of rule 1. i wish there was some way to enforce rule 2. i think one of the main problems with the web is it allows people to say things they wouldn't dare to someone's face. it would definitely deal with a lot of the comments you get from a typical 'digg' user.')) as bodyscore, (MATCH (post_title) AGAINST ('do you think the bloggers code of conduct will be useful?')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('tim o'reilly of o'reilly media, has published a draft proposal for a <a href="http://radar.oreilly.com/archives/2007/04/draft_bloggers_1.html" title="draft blogging code of conduct" target="_blank">blogging code of conduct</a> based on the <a href="http://blogher.org/community-guidelines">blogher community guidelines</a>. this has come about after the kathy sierra episode. full draft below: <!--more--> <blockquote> we celebrate the blogosphere because it embraces frank and open conversation. but frankness does not have to mean lack of civility. we present this blogger code of conduct in hopes that it helps create a culture that encourages both personal expression and constructive conversation.1. we take responsibility for our own words and for the comments we allow on our blog. we are committed to the "civility enforced" standard: we will not post unacceptable content, and we'll delete comments that contain it. we define unacceptable content as anything included or linked to that: - is being used to abuse, harass, stalk, or threaten others - is libelous, knowingly false, ad-hominem, or misrepresents another person, - infringes upon a copyright or trademark - violates an obligation of confidentiality - violates the privacy of others we define and determine what is "unacceptable content" on a case-by-case basis, and our definitions are not limited to this list. if we delete a comment or link, we will say so and explain why. [we reserve the right to change these standards at any time with no notice.] 2. we won't say anything online that we wouldn't say in person. 3. we connect privately before we respond publicly. when we encounter conflicts and misrepresentation in the blogosphere, we make every effort to talk privately and directly to the person(s) involved--or find an intermediary who can do so--before we publish any posts or comments about the issue. 4. when we believe someone is unfairly attacking another, we take action. when someone who is publishing comments or blog postings that are offensive, we'll tell them so (privately, if possible--see above) and ask them to publicly make amends. if those published comments could be construed as a threat, and the perpetrator doesn't withdraw them and apologize, we will cooperate with law enforcement to protect the target of the threat. 5. we do not allow anonymous comments. we require commenters to supply a valid email address before they can post, though we allow commenters to identify themselves with an alias, rather than their real name. 6. we ignore the trolls. we prefer not to respond to nasty comments about us or our blog, as long as they don't veer into abuse or libel. we believe that feeding the trolls only encourages them--"never wrestle with a pig. you both get dirty, but the pig likes it." ignoring public attacks is often the best way to contain them.</blockquote> it's rare that i agree with what <a href="http://scobleizer.com/2007/04/08/code-of-conduct-or-not/" title="scoble" target="_blank">scoble writes</a>, but i think he is right that rules 3, 5 and 6 are unnecessary. one of the reasons i blog is i like to hear the views of many other people. it's one of the reasons i started the <a href="http://www.connectedinternet.co.uk/forum/" title="forum" target="_blank">connected internet forum </a>for discussion that doesn't live within a particular post.  i also don't have a problem with anonymous comments and trolls. at the moment i let anything through as long as it's not in breach of rule 1. i wish there was some way to enforce rule 2. i think one of the main problems with the web is it allows people to say things they wouldn't dare to someone's face. it would definitely deal with a lot of the comments you get from a typical 'digg' user.')) * 1+ (MATCH (post_title) AGAINST ('do you think the bloggers code of conduct will be useful?')) * 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 = 1898 ) 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 = 1898 ) 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 != '1898') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7