A post to put a smile on your face
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 'natural join
where .taxonomy = 'post_tag'
and .term_taxonomy_id in (selec' at line 5]
SELECT *, (bodyscore * 1 + titlescore * 1 + tagscore * 1 + catscore * 1) AS score
from (
select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST (' wild health foods great front magic hedge http www com yard guy website info booth finger free mustard measure')) as bodyscore, (MATCH (post_title) AGAINST ('face smile post')) as titlescore, ifnull(catscore,0) as catscore, ifnull(tagscore,0) as tagscore
from wp_posts left join (
select count(*) as tagscore, object_id from natural join
where .taxonomy = 'post_tag'
and .term_taxonomy_id in (select term_taxonomy_id from where object_id = '236')
group by object_id
) as matchtags on (wp_posts.ID = matchtags.object_id)
left join (
select count(*) as catscore, object_id from natural join
where .taxonomy = 'category'
and .term_taxonomy_id in (select term_taxonomy_id from where object_id = '236')
group by object_id
) as matchcats on (wp_posts.ID = matchcats.object_id)
where ((post_status IN ( 'publish', 'static' ) && ID != '236') and post_date <= '2008-08-27 16:11:41' and post_password ='' and post_type IN ('post') )
) as rawscores where (bodyscore * 1 + titlescore * 1 + tagscore * 1 + catscore * 1) >= 5 and catscore >= 2 order by score DESC limit 5
<–one of two of my new 4 x 4 square foot gardens (surrounded by tons of wild edibles ironically enough!)
Happy Friday Everyone!!! Need some upliftment? Here are some short but effective audio clips to get you in the mood ;) I try to listen to these every morning now. I’m a such a nerd, I know! http://www.soundboard.com/sb/laugh_track.aspx
The Chicago Green Fest last weekend was awesome. I think it was the biggest so far. It’s always fun running into friends from the local raw food community, sampling new products, supporting local companies just starting up, and browsing through the gorgeous organic clothing. I’m not sure what booth/product was my favorite, but my friends and I all got a health reading at this one particular booth and each got a print out of where we stood with our digestion, adrenals, hormones, sleep, etc (there were about 30 points of measure)-and we thought this booth was well worth visiting. The testing method was new to me but the guy said the readings were usually pretty accurate. He put a clip the hand of tip of my left index finger and then wet an electrical probe and pressed it onto the outside of the middle bone of my right index finger. The guy pressed down with the probe for each health measure and obtained a number on the computer. Funny enough, I was slightly outside the ideal range for water!! That was a great wake up call for me though. I am now really focused on making sure I get at least 3 liters of water in me a day (not including juices, teas, etc.) The basics are always a great thing to re-focus on 
I’m seeing wild foods everywhere right now! Clover, plantain, dandelion, wild violet, rhubarb, lambsquarters, lemon sorrel, and garlic mustard (I LOVE garlic mustard). I think I’ve been thinking about and studying wild foods so much lately that the universe is literally putting them right in front of me everywhere I go! I borrowed a book on wild edibles from the library last month, wanting to identify everything in my front yard. It turns out I have four of the above eight wild foods in my front yard alone. I feel so lucky. I plan on going to the Magic Hedge near Montrose beach in Chicago soon to check out what else is going off now that spring is in full gear. Probably mulberries, wild apples, and tons more. Check out this post I did last year on wild foods for more info on the Magic Hedge. I think the next young and raw meetup will be an intro to wild foods in my front yard and then a field trip out to the Magic Hedge. I’m VERY excited…
One last thing for today to spark that ever-expanding mind of yours: I found a great source for some free e-books on superfood health from Mike Adams, “The Health Ranger.” He’s such an awesome guy that has started up a website called http://www.newstarget.com/, a completely independent website dedicated to educating us on health info the FDA doesn’t want us to know about. The website is
http://www.truthpublishing.com/Articles.asp?ID=131 and gives you access to about 10 free e-books. I’ve already read/skimmed through four of them and have learned a ton of new info. Also, here are some great youtube videos of him I’d highly recommend. This is a series of about eight though so watch them when you have time. His knowledge base is huge and this is not your everyday information. You’ll definitely learn something new from him. Enjoy and have a wonderful Memorial Day Weekend!
~Lenette
No related posts.