WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
select count(*) as count from wp_yarpp_related_cache where reference_ID = 49
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (49,'students its people play friends campus life advice college lectures panels read speeches plays walk bike ride concerts attend topics ','experience college ') on duplicate key update date = now(), body = 'students its people play friends campus life advice college lectures panels read speeches plays walk bike ride concerts attend topics ', title = 'experience college '
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID in (49)
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 49
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (49,'students its people play friends campus life advice college lectures panels read speeches plays walk bike ride concerts attend topics ','experience college ') on duplicate key update date = now(), body = 'students its people play friends campus life advice college lectures panels read speeches plays walk bike ride concerts attend topics ', title = 'experience college '
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 49
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 49
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (49,'students its people play friends campus life advice college lectures panels read speeches plays walk bike ride concerts attend topics ','experience college ') on duplicate key update date = now(), body = 'students its people play friends campus life advice college lectures panels read speeches plays walk bike ride concerts attend topics ', title = 'experience college '
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 49
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 49, ID, (0+ (MATCH (post_content) AGAINST ('')) * 3+ (MATCH (post_title) AGAINST ('')) * 3+ 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 = 49 )
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 = 49 )
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 != '49') and post_password ='' and post_type = 'post'
group by id
having score >= 5.00 order by score desc limit 5) union (SELECT 49, ID, (0+ (MATCH (post_content) AGAINST ('')) * 3+ (MATCH (post_title) AGAINST ('')) * 3+ 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 = 49 )
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 = 49 )
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 != '49') and post_password ='' and post_type = 'page'
group by id
having score >= 5.00 order by score desc limit 5) on duplicate key update date = now()
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (49,0,0) on duplicate key update date = now()
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp on wp_posts.ID = yarpp.ID WHERE 1=1 AND yarpp.score >= 5 and yarpp.reference_ID = 49 AND wp_posts.post_type IN ('post', 'page') ORDER BY yarpp.score DESC limit 5
I found this at ehow.com. It offers some good advice
Tips & Warnings
* Do a lot of everything, so long as it’s legal and relatively safe.
* Nowhere else in life will you be around so many different people with such diverse and similar interests at the same time. Reach out to people; you will make lifelong friends and grow tremendously during this period.
* Don’t take college for granted. It will pass you by before you know it, and you can never really go back to that stage in life without feeling awkward.
No related posts.
Great list. I’ve probably done a good chunk of the list. I can agree…just get out there and it will be the best time of your life!
This list is making me wish I had actually gone to college! Sure, I landed in a great job and got lots of amazing work experience – but my dream is to study psychology and live the ‘college lifestyle’. I hope that by the time I have the money for it it isn’t too late!
Great list. Some of these rarely get mentioned. Going to office hours is key. No matter what the Profs say, if you go and they like you it helps. But act like you’ve been thinking about their subject because it’s soooo interesting. Don’t go and ask what will be on the exam.
The rest of these should be considered “must dos” in college. No doubt.
But I went to college in Southern California, so I disagree with the warning:
* Do a lot of everything, so long as it’s legal and relatively safe.
Some of our laws are lame and often there is little risk of getting caught. In those times, go for it. Rip a bong at a party if you never have, be drunk in public often (hell…put vodka in a sippy cup and drink in class), eat Psilocybin mushrooms, and if your state prohibits oral or anal sex, do that too.
Otherwise it’s a tight list.
[...] How to Make the Most of Your College Experience [...]