What’s been going on? Let me fill you in on some good stuff!
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 (' youtube com raw www v watch organic http getting chicago before buy haven hope testing clothes muscle great yet')) as bodyscore, (MATCH (post_title) AGAINST ('stuff! fill let')) 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 = '219')
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 = '219')
group by object_id
) as matchcats on (wp_posts.ID = matchcats.object_id)
where ((post_status IN ( 'publish', 'static' ) && ID != '219') and post_date <= '2008-08-27 16:11:05' 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
Sorry I’ve been M.I.A. as of late, there is just SO much new stuff happening. I keep making notes on my “Blog” word doc on what to talk about next, and it’s to the point where I have enough to write a 10-page post! Instead, I think I’ll post some short tidbits on all these new things. Hope you this newsletter-like post!
-I’ve been jogging around my neighborhood a lot more lately. Chicago is definitely getting “greener” and greener.” Especially in Bucktown and Wickerpark–there are more and more eco-boutiques and vegetarian and organic places popping up all over. Most noteworthy is the organic juice and smoothie bar, Doc’s (which I’ve mentioned before). When I walked in to say hi to the owner the other day, I saw that he was now selling 100% organic juices and will be rolling out green smoothies (with some help from little ole me) very soon! The prices are so reasonable too! AND you don’t have to get carrot juice in it if you don’t want to :) I had a celery-cucumber juice and it was amazing!
-Another place of note is The Green Grocer that just opened on 1402 W. Grand Ave. Todd and I went and checked it out on Saturday to meet the owners and thank them for opening up more organic-purchasing opportunities for them. They are really wonderful people. The Chicago Conscious Choice ran an article about them and that’s how I found out. I just love helping to spread the word about businesses like this though. They have a great little website in the works that even has a coupon on it. Please check them out if you’re in the neighborhood. They have some fresh organic and local produce there too. I bought some organic ginger there (which Wholefoods surprisingly doesn’t even have).
-I’ve updated some pages on my website quite a bit. They are the Great Links, How to Makeover Your Kitchen, How to make your own Super-smoothies, Super-juices, and Super-soups, Raw Friendly Places to Eat In Chicago, and How to shop for raw foods if you’re in Chicago pages. Please check them out!
-In the spirit of Earth Day, last weekend my girlfriends and I got together at my place and had a Girls Night In/Score Your Friends’ Clothes Party! We all brought trashbags of clothes we no longer wanted or were going to wear and just had a ball going through each other’s things. I think we were all amazed at how many clothes we went home with. I must have scored at least 30 new items, not including some brand new makeup a girlfriend no longer wanted. There were about 8 trashbags full of clothes leftover which no one wanted so I’ll be calling the VVA soon to come pick the stuff up BUT I want to do this again!! This was just such a great idea and SO much better than getting ripped off by going to a Buffalo Exchange or similar clothing store. I should host a Young and Raw clothing exchange meetup. Hmmmm….. ;)
-I’ve been getting into a few new things practices lately: EFT and Muscle Testing. I think I’ve watched about 30 YouTube videos on these two things alone in the past week! Wow. There is just so much out there (on YouTube), it’s just ridiculous. I don’t think I’ve blogged about this yet (I probably need to), but when I had the Young and Raw meetup featuring a naturopath guest speaker at my apartment the other week, there was a huge interest in her muscle testing (a.k.a. kinesiology) abilities. What an invaluable skill to have! We can waste $100s of dollars a year on supplements that really aren’t doing anything for us or may even be HARMING us. I’ve talked to my bf about this, and from now on, he’ll be muscle testing me (if he’s with me) before I buy any new supplements at the store in the future. Here are the best YouTube videos I’ve found on muscle testing:
http://www.youtube.com/watch?v=-t1qaEAYu1w
http://www.youtube.com/watch?v=6vZyWouhNpc
- EFT (Emotional Freedom Technique). A lot of you have probably heard about this in the past. I’ve heard about it a couple of times a year now for about five years. It’s never really caught on with me until now though. I’ve been using it on all sorts of things (mainly while I’m in the car driving to or from work, before I’m about to eat a meal, and before I go to sleep at night) and it’s really been working wonders. If you haven’t heard about this before or would like to learn more, here are some great YouTube videos I’ve found on this (they can explain it much better than I could here):
http://www.youtube.com/watch?v=aQp0kA5a5OI
http://www.youtube.com/watch?v=VyU08zK8mzs
http://www.youtube.com/watch?v=nKMFPFB1Ng8
http://www.youtube.com/watch?v=d1mqUPm7L5A
-A money-saving tip for Chicagoans: The cheapest place I’ve now found to buy coconuts in Chicago is Chicago Food Corporation (there’s as big sign that says JOONGBOO market that you’ll see from the 90/94). The address is 3333 North Kimball Ave. I went there last night to buy some coconuts (in dire need for some more coconut kefir) and realized that I was only paying 39 cents per pound for them. They came out to less than $1 each. I was paying $1.50 for them at the Chinese market in uptown Chicago! No durian at this place though :( Darn!
-Here’s a really cool news clip taken at Karyn’s Fresh Corner the other week if you haven’t seen it yet. I hope to be looking at feeling that young at 61!!
-The Raw Spirit Fest: Yes, it’s still about 5 months away but this is really getting me excited!! My friend Anthony, from RawModel.com, just registered to host a workshop there (I’ll be assisting him) and I’ll be working with the We Like It Raw team to get the Give It To Me Raw members together at some point in the weekend for a some sort of awesome shindig! If you haven’t bought your ticket yet, it’s definitely not too late. But it IS getting a little late if you haven’t make hotel accommodations yet so I suggest you start looking around or talking to others going. Just a little favor to ask you: if/when you do buy your tickets, if you could buy them using this link,that would be the best ever! Thank you so much 
-Ask and it is given–It’s SO true! I’ve been wanting to leave my corporate job for a long time now and my wish has finally been answered. I’ll be leaving with a severance package in July!!! I’m SO excited to pursue what I want to do and am so good at doing, full time now. This is the best situation ever. I’ve just been walking on air the last two weeks. So many opportunities are opening up in front of me right now and I’m just scribbling down my ideas as soon as they come. The BIG idea is still on the way though….
Hope you enjoyed the randomness of this post as well as the MANY, MANY links. Hope this keeps you busy for a while!. Love you guys!
~Lenette
No related posts.