WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
select min(ID) as min_id from wp_yarpp_related_cache where reference_ID = 467
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 467 and ID != 0
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 467
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 467
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 467
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (467,'the by song is of video music very but to and like discover weird most suits here really this again ','tv shows through discovered music recently new ') on duplicate key update date = now(), body = 'the by song is of video music very but to and like discover weird most suits here really this again ', title = 'tv shows through discovered music recently new '
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 467 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('the by song is of video music very but to and like discover weird most suits here really this again')) * 1 + (MATCH (post_title) AGAINST ('tv shows through discovered music recently new')) * 1 + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'category', refterms.term_taxonomy_id, null )),1) as score
from wp_posts
left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID )
left join wp_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
left join wp_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 467 )
where post_status in ( 'publish', 'static' ) and ID != '467' and post_password ='' and post_type = 'post'
group by ID
having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) union (SELECT 467 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('the by song is of video music very but to and like discover weird most suits here really this again')) * 1 + (MATCH (post_title) AGAINST ('tv shows through discovered music recently new')) * 1 + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'category', refterms.term_taxonomy_id, null )),1) as score
from wp_posts
left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID )
left join wp_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
left join wp_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 467 )
where post_status in ( 'publish', 'static' ) and ID != '467' and post_password ='' and post_type = 'page'
group by ID
having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) on duplicate key update date = now()
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 467 and ID != 0
WordPress database error: [Table 'rhythmic_raj.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 = 467 AND wp_posts.post_type IN ('post', 'page') ORDER BY yarpp.score DESC limit 5
Just like movies, TV shows can also be a great way of discovering new music especially music which you would never listen to otherwise. In my case, most music I discover is similar to the music I like but by artists I don’t give a try. Its weird that most music I discover is Alternative/Indie and Electronica. Or is it simply a case of self-selection?
So here’s a list of few songs I discovered recently through TV and liked enough to listen again (and mention here!):
1. Undercover Martyn by Two Door Cinema Club: I really like this song. The video isn’t too bad either.
2. Walking on a Dream by Empire of The Sun: Very trippy, very M83-ish. The video is extremely weird though.
3. Bonafide Lovin’ by Chromeo: A funny song! The video here is a fan video but suits the song very well.
4. Let Your Love Grow Tall by Passion Pit: This is a happy song. Again, its an amateur video that suits the song pretty well.
5. Only Man by Audio Bullys: The song’s alright but the video is really cool!
Honorable mentions:
Run by Stephen Fretwell: Theme song of ‘Gavin & Stacie’
One Way Road by Paul Weller: Theme song of ‘Lead Balloon’
You really need to watch House, M.D. – amazing sound track it has!
I did try watching it but I can’t stand medical procedurals. Just the crime procedurals for me. But I trust your recommendation so I will go directly to heardontv.com