Book Review: How to Win Sales & Influence Spiders
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select count(*) as count from wp_yarpp_related_cache where reference_ID = 37 and date > date_sub(now(),interval 600 minute)
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 'on duplicate key update date = now(), body = 'marketing knowled]
insert into wp_yarpp_keyword_cache (ID,body,title) values (37,'marketing knowledge book business clients online execute read internet strategies chapters great win success catherine basic books web takeaways strong ','influence spiders sales win review book ') on duplicate key update date = now(), body = 'marketing knowledge book business clients online execute read internet strategies chapters great win success catherine basic books web takeaways strong ', title = 'influence spiders sales win review book '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 37 and ID != 0
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 37
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 37
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 'on duplicate key update date = now(), body = 'marketing knowled]
insert into wp_yarpp_keyword_cache (ID,body,title) values (37,'marketing knowledge book business clients online execute read internet strategies chapters great win success catherine basic books web takeaways strong ','influence spiders sales win review book ') on duplicate key update date = now(), body = 'marketing knowledge book business clients online execute read internet strategies chapters great win success catherine basic books web takeaways strong ', title = 'influence spiders sales win review book '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 37
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 37
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 'on duplicate key update date = now(), body = 'marketing knowled]
insert into wp_yarpp_keyword_cache (ID,body,title) values (37,'marketing knowledge book business clients online execute read internet strategies chapters great win success catherine basic books web takeaways strong ','influence spiders sales win review book ') on duplicate key update date = now(), body = 'marketing knowledge book business clients online execute read internet strategies chapters great win success catherine basic books web takeaways strong ', title = 'influence spiders sales win review book '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 37
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 'on duplicate key update date = now()' at line 15]
insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 37, ID, (0+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 37 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 37 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '37') and post_date <= NOW() and post_password ='' and post_date > date_sub(now(), interval 12 month) and post_type IN ('post', 'page')
group by id
having score >= 2.5 order by score desc limit 5 on duplicate key update date = now()
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (37,0,0)
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 'using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_I]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_ID = 37 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
I read How to Win Sales & Influence Spiders by Catherine Seda, her second book regarding Internet marketing and it’s a solid tool to accomplish these things. The book is about boosting your business and buzz on the web. I’m reviewing this book as it relates to my small business customers and how it can help them.If my clients read this book they will walk away with one of two things or both:
- Basic and intermediate SEO and Internet marketing knowledge that will put more value into the strategies we layout and execute for them.
- Enough knowledge for them to plan and execute these strategies for themselves.
The book’s strong points are in the flow, easy to understand terminology (it’s light on the geek speak) and takeaways. As a 200 page book, it’s not an enternity read with a bunch of loose ends. Each of the 10 chapters offers well-orchestrated info and a “real world” success story from a business that executed that strategy. This section has the business informing you of their goal, their time to execute and the result. These sections are so valuable I wanted more … and that might be the book’s only shortfall.
There is also interjection from other accomplished Internet marketing professionals giving out strong advice. The chapters are then summarized with great takeaways in the “Tips to Remember” section.
The chapters cover basic SEO knowledge, link building, writing online articles, blogging for business, social media and email marketing just to name a few.
As a veteran of the online marketing industry, professional speaker and current Entrepreneur magazine columnist, Catherine has put together her knowledge and experience into a format for anyone to grasp.
I hope you check it out, you can buy it here online … especially if you’re one of our great Prime clients.
No related posts.
Posted on March 30th, 2007 by Jeff Wagner
Filed under: email marketing, marketing, resources, seo
If you like what you're reading, please subscribe to this blog.
Thanks, Aaron!
I tried to write the kind of book I want to read: a mix of tips, tools and success stories. Hopefully, readers think this is a good combination, too.