Cacao Cherry Smoothie Recipe
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 ('cacao tablespoon frozen optional mix blend vita stir sliced enjoy!!! almonds raw slivered maca handful smoothie cherry ya recipe cup')) as bodyscore, (MATCH (post_title) AGAINST ('recipe smoothie cherry cacao')) 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 = '251')
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 = '251')
group by object_id
) as matchcats on (wp_posts.ID = matchcats.object_id)
where ((post_status IN ( 'publish', 'static' ) && ID != '251') and post_date <= '2008-08-27 16:10:38' 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
It’s been a while since I’ve posted a recipe on here so here ya go:
Cherry Cacao Smoothie
1 cup frozen cherries
1 frozen banana
1 tablespoon cacao powder
1 small handful cacao nibs
1 tablespoon maca
Blend in the Vita-Mix
Optional: Stir in sliced/slivered raw almonds
Enjoy!!!
No related posts.