Compost and Coconuts
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 (' organic maybe chicago why friends gardening coconuts compost making supply green thought young great business soil food order bag')) as bodyscore, (MATCH (post_title) AGAINST ('coconuts compost')) 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 = '229')
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 = '229')
group by object_id
) as matchcats on (wp_posts.ID = matchcats.object_id)
where ((post_status IN ( 'publish', 'static' ) && ID != '229') and post_date <= '2008-08-27 16:14:48' 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
Last weekend I continued my shopping (I feel like it’s been a real scavenger hunt) for supplies and ingredients for my square foot garden. It seems like it’s been years since first talking about this and I am just SO excited to get started. However, I’ve encountered a few challenges: I’m finding that not a lot of gardening supply centers carry organic transplants, composts, copper shovels, etc–at least not in Chicago. I REALLY thought these things would be more prevalent and not at all hard to find but I guess I was wrong. Chicago is striving to be the “greenest” city in America. Why not start with the actual greenery? Organic gardening materials are definitely the most sustainable and earth friendly way to go. Oh well. I’ve posted some want ads on Craig’s list. Maybe someone is making organic compost in their kitchen using some sort of automatic composter and has some extra to unload. The universe will line it up for me, right? Right! It would definitely be a great business for someone in the Chicago to take on–making and selling organic compost. It’s a great way to promote growing your own food too, or the whole Anastatia Movement.
One thing I did see (and smell!) at the garden supply center that I thought was pretty cool was a bag of cacao shells. I wasn’t sure how to use this in my soil mix so I didn’t buy it. I’ve heard David Wolfe say that cacao shells add a lot of nitrogen to the soil. The bag that I saw was sitting in the sun and smelled SO good I was seriously ready to take it home and use it as potpourri (maybe someday soon. It would be a pretty neat idea. I wonder if anyone has done this?).
On another topic: Are you interested in trying out young green coconuts but don’t have $400 to take a vacation to the tropics? I was pondering this question myself the other day and decided to start Googling. If found this business in Florida, Broward Palm Trees, where you can order a case of 12 (I don’t know why 12) young green coconuts for about $5-$6 per coconut, depending on where you live. Expensive I know, but it’s FedEx that really gets you because I spoke with the guy and he sells them for only $1 each! It’s just an option. Maybe if you can get five other friends together you can go in on a box together for $10-$12 each. If you are anything like me-I know you’ve spent more than that on good food and superfoods before. Why not try something new? OR….if you can get together a bunch of friends and order a crate of 400 you can get the cost down to about $3 each. Maybe if you’re in New York or California it would be possible to get this many willing people together. Just putting it out there… It would be a good reason to put an event together 
Have the best weekend ever,
Lenette
No related posts.
July 2nd, 2008 at 2:30 pm
Try Grand Street Gardens, its a really nice shop located at 2200 W. Grand.
July 20th, 2008 at 8:49 am
Hello. I just found your blog the other day and have been fun ever since reading about your raw adventures. Did you ever end up getting some cacao shells? We have some in our little garden just as decorative ground cover. In fact my mom put some fresh ones down yesterday and they smell so delicious!