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 been a while since i've given details of my favourite wordpress plugins. it's' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('it's been a while since i've given details of my favourite wordpress plugins. it's rare now that i install a new plugin as i've tried so many in the past, as it's not often that a new one appears that i haven't tried a similar variant of in the past. at the moment these are the <strong>ten wordpress plugins i couldn't live without</strong>, as well as the full list of all the wordpress plugins i'm currently using as i seem to be getting a lot of requests for this of late. <!--more--> <ol> <h3> <li><a href="http://www.i-marco.nl/wp/wordpress/" title="visit plugin homepage">wp hardened trackback</a> v1.0 by <a href="http://www.i-marco.nl/weblog/" title="visit author homepage">marco van hylckama vlieg</a></li> </h3> this plugin has been one of the key components of my spam defence and has singlehandedly eliminated trackback spam. what this plugin does is generate a unique trackback url that must be used within 15 minutes. if a site attempts to leave a trackback without a proper key it is rejected. you can see the trackback generation in place under my posts. <h3> <li><a href="http://www.deanlee.cn/wordpress/permalinks-migration-plugin/" title="visit plugin homepage">dean’s permalinks migration</a> v1.0 by <a href="http://www.deanlee.cn/" title="visit author homepage">dean lee</a></li> </h3> i originally started blogging on the blogware platform and i eventually moved to wordpress. what this plugin has allowed me to do is to change the permalinks of all my old posts (around 5 are still in my top 10 for traffic, so this was very important) to something more user-friendly. <h3> <li><a href="http://www.semiologic.com/software/dofollow/" title="visit plugin homepage">dofollow</a> v2.0 by <a href="http://www.semiologic.com" title="visit author homepage">denis de bernardy</a></li> </h3> a new addition to the family. i think that blogging is about sharing and participating, and that adding 'nofollow' by default to wp comments is a mistake. this plugin fixes this mistake and allows other site owners to get credit for their contributions to my site. <h3> <li><a href="http://www.feedburner.com/fb/a/help/wordpress_quickstart" title="visit plugin homepage">feedburner feedsmith</a> v2.2 by <a href="http://www.feedburner.com" title="visit author homepage">feedburner inc.</a></li> </h3> a vital plugin which allows me to use the great feed tools available from feedburner. it also ensures that all readers pick up the feedburner feed, and not the blog's default feed. <h3> <li><a href="http://www.webspaceworks.com/resources/cat/wp-plugins/31/" title="visit plugin homepage">fold category list</a> v1.12 by <a href="http://www.webspaceworks.com/" title="visit author homepage">rob schumann</a></li> </h3> i hate blogs that have huge category lists. i don't see the point as no reader in their right mind is going to scroll a category list that has more than 15 entries, and long lists aren't very user-friendly. what this plugin allows me to do is to hide my second-level categories, which only become visible if a top level category is clicked upon. <h3> <li><a href="http://cavemonkey50.com/code/full-feed/" title="visit plugin homepage">full text feed</a> v1.03 by <a href="http://cavemonkey50.com/" title="visit author homepage">ronald heft, jr.</a></li> </h3> i think that about 90% of my browsing is originated by my feedreader, and i believe that providing a full feed is better than providing a partial feed. this plugin fixes the problem with wordpress where articles are truncated in feeds if you use the 'more' command. <h3> <li><a href="http://www.w-a-s-a-b-i.com/archives/2006/02/02/wordpress-related-entries-20/" title="visit plugin homepage">related posts</a> v2.04 by alexander malov, mike lu &amp; jon bourne</li> </h3> a vital plugin - all bloggers should use this. i can't think of one reason not to! <h3> <li><a href="http://guff.szub.net/post-templates-by-category/" title="visit plugin homepage">post templates by category</a> vr1.3 by <a href="http://szub.net" title="visit author homepage">kaf oseo</a></li> </h3> this plugin has become important to me of late as it allows me to track and reward my guest authors for their work. every team member has a unique category template for their editorial column, and as long as they remember to add this category to their posts, i can track their earnings. <h3> <li><a href="http://simpletagging.herewithme.fr" title="visit plugin homepage">simple tagging</a> v1.6.2 by <a href="http://simpletagging.herewithme.fr" title="visit author homepage">amaury balmer</a></li> </h3> a much improved tagging plugin than utw, which used to be the king. easier to use, and more importantly, not a resource hog. also has some cool features like being able to add tags to feeds and meta tags. <h3> <li><a href="http://unknowngenius.com/blog/wordpress/spam-karma/" title="visit plugin homepage">spam karma 2</a> v2.3 rc1 by <a href="http://unknowngenius.com/blog/" title="visit author homepage">dr dave</a></li> </h3> the best anti-spam plugin, which provides full control. akismet is ok, but the inability to correct false positives makes it a no-go for me.</ol> the next page lists all of the plugins i use. don't forget to share the plugins that you find indispensable with other readers in a comment. <!--nextpage--> <ul> <li><a href="http://blog.taragana.com/index.php/archive/word-press-1-5-plugin-referer-bouncer/" title="visit plugin homepage">angsuman’s referrer bouncer</a> v1.2 by <a href="http://angsuman.taragana.net/" title="visit author homepage">angsuman chakraborty</a></li> <li><a href="http://meidell.dk/archives/category/wordpress/latest-comments/" title="visit plugin homepage">brian’s latest comments</a> v1.5.8 by <a href="http://meidell.dk/" title="visit author homepage">brian meidell</a></li> <li><a href="http://redalt.com/wiki/comment+quicktags" title="visit plugin homepage">comment quicktags</a> v1.9 by <a href="http://www.asymptomatic.net" title="visit author homepage">owen winkler</a></li> <li><a href="http://www.deanlee.cn/wordpress/permalinks-migration-plugin/" title="visit plugin homepage">dean’s permalinks migration</a> v1.0 by <a href="http://www.deanlee.cn/" title="visit author homepage">dean lee</a></li> <li><a href="http://www.aviransplace.com/index.php/digg-this-wordpress-plugin/" title="visit plugin homepage">digg this</a> v1.0.2 by <a href="http://www.aviransplace.com" title="visit author homepage">aviran mordo</a></li> <li><a href="http://www.semiologic.com/software/dofollow/" title="visit plugin homepage">dofollow</a> v2.0 by <a href="http://www.semiologic.com" title="visit author homepage">denis de bernardy</a></li> <li><a href="http://www.sonsofskadi.net/extended-live-archive/" title="visit plugin homepage">extended live archives</a> v0.10beta-r18 by <a href="http://www.sonsofskadi.net/" title="visit author homepage">arnaud froment</a></li> <li><a href="http://www.feedburner.com/fb/a/help/wordpress_quickstart" title="visit plugin homepage">feedburner feedsmith</a> v2.2 by <a href="http://www.feedburner.com" title="visit author homepage">feedburner inc.</a></li> <li><a href="http://www.webspaceworks.com/resources/cat/wp-plugins/31/" title="visit plugin homepage">fold category list</a> v1.12 by <a href="http://www.webspaceworks.com/" title="visit author homepage">rob schumann</a></li> <li><a href="http://cavemonkey50.com/code/full-feed/" title="visit plugin homepage">full text feed</a> v1.03 by <a href="http://cavemonkey50.com/" title="visit author homepage">ronald heft, jr.</a></li> <li><a href="http://www.arnebrachhold.de/redir/sitemap-home/" title="visit plugin homepage">google (xml) sitemaps</a> v3.0b6 by <a href="http://www.arnebrachhold.de/" title="visit author homepage">arne brachhold</a></li> <li><a href="http://www.thunderguy.com/semicolon/wordpress/less-wordpress-plugin/" title="visit plugin homepage">less</a> v1.1 by <a href="http://www.thunderguy.com/semicolon/" title="visit author homepage">bennett mcelwee</a></li> <li><a href="http://www.m3nt0r.de/blog/lightbox-wordpress-plugin/" title="visit plugin homepage">lightbox 2.02 plugin</a> v0.6.4 beta by <a href="http://www.m3nt0r.de/blog/" title="visit author homepage">kjell bublitz</a></li> <li><a href="http://ellisweb.net/2006/03/wp-mint-popular-posts/" title="visit plugin homepage">mint popular posts</a> v0.95 by <a href="http://ellisweb.net/" title="visit author homepage">yaakov ellis</a></li> <li><a href="http://www.napolux.com/projects/myavatars/" title="visit plugin homepage">myavatars</a> v0.2a by <a href="http://miche.netsons.org/">andrea micheloni</a> &amp; <a href="http://www.napolux.com/">napolux</a></li> <li><a href="http://elasticdog.com/2004/09/optimal-title/" title="visit plugin homepage">optimal title</a> v3.0 by <a href="http://elasticdog.com/" title="visit author homepage">aaron schaefer</a></li> <li><a href="http://www.keyvan.net/code/paged-comments/" title="visit plugin homepage">paged comments</a> v2.6.2 (2007-05-04) by <a href="http://www.keyvan.net/" title="visit author homepage">keyvan minoukadeh</a></li> <li><a href="http://guff.szub.net/post-templates-by-category/" title="visit plugin homepage">post templates by category</a> vr1.3 by <a href="http://szub.net" title="visit author homepage">kaf oseo</a></li> <li><a href="http://txfx.net/code/wordpress/redirect-old-slugs/" title="visit plugin homepage">redirect old slugs</a> v0.3 by <a href="http://txfx.net/" title="visit author homepage">mark jaquith</a></li> <li><a href="http://www.w-a-s-a-b-i.com/archives/2006/02/02/wordpress-related-entries-20/" title="visit plugin homepage">related posts</a> v2.04 by alexander malov, mike lu &amp; jon bourne</li> <li><a href="http://www.solo-technology.com/apps.html" title="visit plugin homepage">st add related posts to feed</a> v.02 by <a href="http://www.solo-technology.com/blog/" title="visit author homepage">chris kasten, aka handysolo</a></li> <li><a href="http://alexking.org/projects/wordpress" title="visit plugin homepage">share this</a> v1.4 by <a href="http://alexking.org/" title="visit author homepage">alex king</a></li> <li><a href="http://www.pfadvice.com/wordpress-plugins/show-top-commentators/" title="visit plugin homepage">show top commentators</a> v1.04 by <a href="http://www.savingadvice.com" title="visit author homepage">nate sanden</a></li> <li><a href="http://simpletagging.herewithme.fr" title="visit plugin homepage">simple tagging</a> v1.6.2 by <a href="http://simpletagging.herewithme.fr" title="visit author homepage">amaury balmer</a></li> <li><a href="http://unknowngenius.com/blog/wordpress/spam-karma/" title="visit plugin homepage">spam karma 2</a> v2.3 rc1 by <a href="http://unknowngenius.com/blog/" title="visit author homepage">dr dave</a></li> <li><a href="http://txfx.net/code/wordpress/subscribe-to-comments/" title="visit plugin homepage">subscribe to comments</a> v2.1 by <a href="http://txfx.net/" title="visit author homepage">mark jaquith</a></li> <li><a href="http://www.text-link-ads.com" title="visit plugin homepage">text link ads</a> v3.0.3 by <a href="http://www.text-link-ads.com" title="visit author homepage">justin klemm &amp; matthew drouin &amp; alex king</a></li> <li><a href="http://www.i-marco.nl/wp/wordpress/" title="visit plugin homepage">wp hardened trackback</a> v1.0 by <a href="http://www.i-marco.nl/weblog/" title="visit author homepage">marco van hylckama vlieg</a></li> <li><a href="http://www.skarcha.com/wp-plugins/wpvideo/" title="visit plugin homepage">wpvideo</a> v1.10 by <a href="http://www.skarcha.com" title="visit author homepage">antonio perez</a></li> <li><a href="http://guff.szub.net/the-excerpt-reloaded/" title="visit plugin homepage">the_excerpt reloaded</a> vr1 by <a href="http://szub.net" title="visit author homepage">kaf oseo</a></li> <li><a href="http://mnm.uib.es/gallir/wp-cache-2/" title="visit plugin homepage">wp-cache</a> v2.1.1 by <a href="http://mnm.uib.es/gallir/" title="visit author homepage">ricardo galli granada</a></li> </ul>')) as bodyscore, (MATCH (post_title) AGAINST ('ten wordpress plugins i couldn't live without')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('it's been a while since i've given details of my favourite wordpress plugins. it's rare now that i install a new plugin as i've tried so many in the past, as it's not often that a new one appears that i haven't tried a similar variant of in the past. at the moment these are the <strong>ten wordpress plugins i couldn't live without</strong>, as well as the full list of all the wordpress plugins i'm currently using as i seem to be getting a lot of requests for this of late. <!--more--> <ol> <h3> <li><a href="http://www.i-marco.nl/wp/wordpress/" title="visit plugin homepage">wp hardened trackback</a> v1.0 by <a href="http://www.i-marco.nl/weblog/" title="visit author homepage">marco van hylckama vlieg</a></li> </h3> this plugin has been one of the key components of my spam defence and has singlehandedly eliminated trackback spam. what this plugin does is generate a unique trackback url that must be used within 15 minutes. if a site attempts to leave a trackback without a proper key it is rejected. you can see the trackback generation in place under my posts. <h3> <li><a href="http://www.deanlee.cn/wordpress/permalinks-migration-plugin/" title="visit plugin homepage">dean’s permalinks migration</a> v1.0 by <a href="http://www.deanlee.cn/" title="visit author homepage">dean lee</a></li> </h3> i originally started blogging on the blogware platform and i eventually moved to wordpress. what this plugin has allowed me to do is to change the permalinks of all my old posts (around 5 are still in my top 10 for traffic, so this was very important) to something more user-friendly. <h3> <li><a href="http://www.semiologic.com/software/dofollow/" title="visit plugin homepage">dofollow</a> v2.0 by <a href="http://www.semiologic.com" title="visit author homepage">denis de bernardy</a></li> </h3> a new addition to the family. i think that blogging is about sharing and participating, and that adding 'nofollow' by default to wp comments is a mistake. this plugin fixes this mistake and allows other site owners to get credit for their contributions to my site. <h3> <li><a href="http://www.feedburner.com/fb/a/help/wordpress_quickstart" title="visit plugin homepage">feedburner feedsmith</a> v2.2 by <a href="http://www.feedburner.com" title="visit author homepage">feedburner inc.</a></li> </h3> a vital plugin which allows me to use the great feed tools available from feedburner. it also ensures that all readers pick up the feedburner feed, and not the blog's default feed. <h3> <li><a href="http://www.webspaceworks.com/resources/cat/wp-plugins/31/" title="visit plugin homepage">fold category list</a> v1.12 by <a href="http://www.webspaceworks.com/" title="visit author homepage">rob schumann</a></li> </h3> i hate blogs that have huge category lists. i don't see the point as no reader in their right mind is going to scroll a category list that has more than 15 entries, and long lists aren't very user-friendly. what this plugin allows me to do is to hide my second-level categories, which only become visible if a top level category is clicked upon. <h3> <li><a href="http://cavemonkey50.com/code/full-feed/" title="visit plugin homepage">full text feed</a> v1.03 by <a href="http://cavemonkey50.com/" title="visit author homepage">ronald heft, jr.</a></li> </h3> i think that about 90% of my browsing is originated by my feedreader, and i believe that providing a full feed is better than providing a partial feed. this plugin fixes the problem with wordpress where articles are truncated in feeds if you use the 'more' command. <h3> <li><a href="http://www.w-a-s-a-b-i.com/archives/2006/02/02/wordpress-related-entries-20/" title="visit plugin homepage">related posts</a> v2.04 by alexander malov, mike lu &amp; jon bourne</li> </h3> a vital plugin - all bloggers should use this. i can't think of one reason not to! <h3> <li><a href="http://guff.szub.net/post-templates-by-category/" title="visit plugin homepage">post templates by category</a> vr1.3 by <a href="http://szub.net" title="visit author homepage">kaf oseo</a></li> </h3> this plugin has become important to me of late as it allows me to track and reward my guest authors for their work. every team member has a unique category template for their editorial column, and as long as they remember to add this category to their posts, i can track their earnings. <h3> <li><a href="http://simpletagging.herewithme.fr" title="visit plugin homepage">simple tagging</a> v1.6.2 by <a href="http://simpletagging.herewithme.fr" title="visit author homepage">amaury balmer</a></li> </h3> a much improved tagging plugin than utw, which used to be the king. easier to use, and more importantly, not a resource hog. also has some cool features like being able to add tags to feeds and meta tags. <h3> <li><a href="http://unknowngenius.com/blog/wordpress/spam-karma/" title="visit plugin homepage">spam karma 2</a> v2.3 rc1 by <a href="http://unknowngenius.com/blog/" title="visit author homepage">dr dave</a></li> </h3> the best anti-spam plugin, which provides full control. akismet is ok, but the inability to correct false positives makes it a no-go for me.</ol> the next page lists all of the plugins i use. don't forget to share the plugins that you find indispensable with other readers in a comment. <!--nextpage--> <ul> <li><a href="http://blog.taragana.com/index.php/archive/word-press-1-5-plugin-referer-bouncer/" title="visit plugin homepage">angsuman’s referrer bouncer</a> v1.2 by <a href="http://angsuman.taragana.net/" title="visit author homepage">angsuman chakraborty</a></li> <li><a href="http://meidell.dk/archives/category/wordpress/latest-comments/" title="visit plugin homepage">brian’s latest comments</a> v1.5.8 by <a href="http://meidell.dk/" title="visit author homepage">brian meidell</a></li> <li><a href="http://redalt.com/wiki/comment+quicktags" title="visit plugin homepage">comment quicktags</a> v1.9 by <a href="http://www.asymptomatic.net" title="visit author homepage">owen winkler</a></li> <li><a href="http://www.deanlee.cn/wordpress/permalinks-migration-plugin/" title="visit plugin homepage">dean’s permalinks migration</a> v1.0 by <a href="http://www.deanlee.cn/" title="visit author homepage">dean lee</a></li> <li><a href="http://www.aviransplace.com/index.php/digg-this-wordpress-plugin/" title="visit plugin homepage">digg this</a> v1.0.2 by <a href="http://www.aviransplace.com" title="visit author homepage">aviran mordo</a></li> <li><a href="http://www.semiologic.com/software/dofollow/" title="visit plugin homepage">dofollow</a> v2.0 by <a href="http://www.semiologic.com" title="visit author homepage">denis de bernardy</a></li> <li><a href="http://www.sonsofskadi.net/extended-live-archive/" title="visit plugin homepage">extended live archives</a> v0.10beta-r18 by <a href="http://www.sonsofskadi.net/" title="visit author homepage">arnaud froment</a></li> <li><a href="http://www.feedburner.com/fb/a/help/wordpress_quickstart" title="visit plugin homepage">feedburner feedsmith</a> v2.2 by <a href="http://www.feedburner.com" title="visit author homepage">feedburner inc.</a></li> <li><a href="http://www.webspaceworks.com/resources/cat/wp-plugins/31/" title="visit plugin homepage">fold category list</a> v1.12 by <a href="http://www.webspaceworks.com/" title="visit author homepage">rob schumann</a></li> <li><a href="http://cavemonkey50.com/code/full-feed/" title="visit plugin homepage">full text feed</a> v1.03 by <a href="http://cavemonkey50.com/" title="visit author homepage">ronald heft, jr.</a></li> <li><a href="http://www.arnebrachhold.de/redir/sitemap-home/" title="visit plugin homepage">google (xml) sitemaps</a> v3.0b6 by <a href="http://www.arnebrachhold.de/" title="visit author homepage">arne brachhold</a></li> <li><a href="http://www.thunderguy.com/semicolon/wordpress/less-wordpress-plugin/" title="visit plugin homepage">less</a> v1.1 by <a href="http://www.thunderguy.com/semicolon/" title="visit author homepage">bennett mcelwee</a></li> <li><a href="http://www.m3nt0r.de/blog/lightbox-wordpress-plugin/" title="visit plugin homepage">lightbox 2.02 plugin</a> v0.6.4 beta by <a href="http://www.m3nt0r.de/blog/" title="visit author homepage">kjell bublitz</a></li> <li><a href="http://ellisweb.net/2006/03/wp-mint-popular-posts/" title="visit plugin homepage">mint popular posts</a> v0.95 by <a href="http://ellisweb.net/" title="visit author homepage">yaakov ellis</a></li> <li><a href="http://www.napolux.com/projects/myavatars/" title="visit plugin homepage">myavatars</a> v0.2a by <a href="http://miche.netsons.org/">andrea micheloni</a> &amp; <a href="http://www.napolux.com/">napolux</a></li> <li><a href="http://elasticdog.com/2004/09/optimal-title/" title="visit plugin homepage">optimal title</a> v3.0 by <a href="http://elasticdog.com/" title="visit author homepage">aaron schaefer</a></li> <li><a href="http://www.keyvan.net/code/paged-comments/" title="visit plugin homepage">paged comments</a> v2.6.2 (2007-05-04) by <a href="http://www.keyvan.net/" title="visit author homepage">keyvan minoukadeh</a></li> <li><a href="http://guff.szub.net/post-templates-by-category/" title="visit plugin homepage">post templates by category</a> vr1.3 by <a href="http://szub.net" title="visit author homepage">kaf oseo</a></li> <li><a href="http://txfx.net/code/wordpress/redirect-old-slugs/" title="visit plugin homepage">redirect old slugs</a> v0.3 by <a href="http://txfx.net/" title="visit author homepage">mark jaquith</a></li> <li><a href="http://www.w-a-s-a-b-i.com/archives/2006/02/02/wordpress-related-entries-20/" title="visit plugin homepage">related posts</a> v2.04 by alexander malov, mike lu &amp; jon bourne</li> <li><a href="http://www.solo-technology.com/apps.html" title="visit plugin homepage">st add related posts to feed</a> v.02 by <a href="http://www.solo-technology.com/blog/" title="visit author homepage">chris kasten, aka handysolo</a></li> <li><a href="http://alexking.org/projects/wordpress" title="visit plugin homepage">share this</a> v1.4 by <a href="http://alexking.org/" title="visit author homepage">alex king</a></li> <li><a href="http://www.pfadvice.com/wordpress-plugins/show-top-commentators/" title="visit plugin homepage">show top commentators</a> v1.04 by <a href="http://www.savingadvice.com" title="visit author homepage">nate sanden</a></li> <li><a href="http://simpletagging.herewithme.fr" title="visit plugin homepage">simple tagging</a> v1.6.2 by <a href="http://simpletagging.herewithme.fr" title="visit author homepage">amaury balmer</a></li> <li><a href="http://unknowngenius.com/blog/wordpress/spam-karma/" title="visit plugin homepage">spam karma 2</a> v2.3 rc1 by <a href="http://unknowngenius.com/blog/" title="visit author homepage">dr dave</a></li> <li><a href="http://txfx.net/code/wordpress/subscribe-to-comments/" title="visit plugin homepage">subscribe to comments</a> v2.1 by <a href="http://txfx.net/" title="visit author homepage">mark jaquith</a></li> <li><a href="http://www.text-link-ads.com" title="visit plugin homepage">text link ads</a> v3.0.3 by <a href="http://www.text-link-ads.com" title="visit author homepage">justin klemm &amp; matthew drouin &amp; alex king</a></li> <li><a href="http://www.i-marco.nl/wp/wordpress/" title="visit plugin homepage">wp hardened trackback</a> v1.0 by <a href="http://www.i-marco.nl/weblog/" title="visit author homepage">marco van hylckama vlieg</a></li> <li><a href="http://www.skarcha.com/wp-plugins/wpvideo/" title="visit plugin homepage">wpvideo</a> v1.10 by <a href="http://www.skarcha.com" title="visit author homepage">antonio perez</a></li> <li><a href="http://guff.szub.net/the-excerpt-reloaded/" title="visit plugin homepage">the_excerpt reloaded</a> vr1 by <a href="http://szub.net" title="visit author homepage">kaf oseo</a></li> <li><a href="http://mnm.uib.es/gallir/wp-cache-2/" title="visit plugin homepage">wp-cache</a> v2.1.1 by <a href="http://mnm.uib.es/gallir/" title="visit author homepage">ricardo galli granada</a></li> </ul>')) * 1+ (MATCH (post_title) AGAINST ('ten wordpress plugins i couldn't live without')) * 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 = 2172 ) 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 = 2172 ) 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 != '2172') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7