Colorado Springs
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 (' springs organic lara worth great water bars food raw manitou per trip spring hoping ate own energy always making')) as bodyscore, (MATCH (post_title) AGAINST ('springs colorado')) 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 = '239')
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 = '239')
group by object_id
) as matchcats on (wp_posts.ID = matchcats.object_id)
where ((post_status IN ( 'publish', 'static' ) && ID != '239') and post_date <= '2008-08-27 16:11:31' 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
Hi all,
Sorry to have been gone for so long. Last weekend, my boyfriend and I went to Colorado Springs and had a really amazing time. We went biking in the Garden of the Gods, experienced some really fresh mountain air at the top of Pikes Peak, got to sample some mineral water for several different natural springs, did some hiking, and even got a psychic reading. It was all pretty awesome. Here are some pictures of the trip below.
<–sampling some natural spring water in Manitou Springs. It tasted very minerally and not as clean-tasting as I was hoping.
<–Ponderosa Pine trees smell just like butterscotch!
There are no raw food restaurants in Colorado Springs (yet) but with the help of Lara Bars and Safeway’s organic produce section, we did pretty darn good diet-wise. There was also a great organic restaurant in Manitou Springs that we ate ate twice. My advice for travelers is to bring some organic fruit for the first couple mornings and also some tupperware containers and utencils for making your own salads when you go grocery shopping, along with some Lara Bars, bee pollen, and Vitamineral Greens. I bring Celtic Sea Salt and stevia too whenever I travel.
<–”Seven-Falls” behind me. What a gorgeous day and view.
<–Garden of the Gods from afar. Very appropriately named!!
Anyway it was a fantastic trip as you can see and it really is true that you can eat well –raw-vegan-organic pretty much anywhere! (well Lara Bars aren’t organic but close enough ;) I was hoping to do more wild food foraging and was studing my book the entire way there on the plane but there wasn’t much that I recognized. There’s always my front yard though!!
I found out yesterday that I was in the Chicago Redeye on Monday. Here is the article. It’s about detoxing and the pains and gains of it. It’s short and worth the read.
Two other tidbits: I just bought myself a Q-Link because I’ve been feeling like it might give me some more energy (and more energy is always a great thing). I think it’s really been helping me. It didn’t go off when I went through the airport metal detector either. There are some really good deals on these on Amazon now. I think the price has really gone down substantially and could be worth it. I’m not a huge fan of wearing it as jewelry so I just safety pin it to the middle of my bra and it seems to work.
Also, I think I’ve found my replacement for Kombuchas. I really love Kombucha (mainly the carbonation of it) and have been brewing my own in my apartment. However, it takes quite a while to brew if you want to get all the sugar out (about 2 weeks) and I’m only making about 5 1/2 bottles worth at a time so it goes pretty fast. But I just discovered this great drink called Talking Rain at Costco last night! It’s fizzy, organicly favored sparkling artesian spring water, and it has zero calories and no artificial flavorings. It’s perfect. And it was only $9 something for 24 bottles so that’s about 42 cents per bottle. Pretty good compared to 3.50 or so per bottle. Just thought I’d share that with all you Kombucha addicts out there… ;)
P.s. I am also looking into taking a reiki 1 class so if any of you have done this or have any recommendations on where to take this class please e-mail me. Thanks so much!
~Lenette
No related posts.