Top 20 love songs of all time
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
select min(ID) as min_id from wp_yarpp_related_cache where reference_ID = 668
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 668 and ID != 0
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 668
WordPress database error: [Table 'intimacy_db1.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 668
WordPress database error: [Table 'intimacy_db1.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 668
WordPress database error: [Table 'intimacy_db1.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (668,'love you the songs com www html 20 time me roberta flack my tonight top to your adams bryan will ','all time of songs 20 love top ') on duplicate key update date = now(), body = 'love you the songs com www html 20 time me roberta flack my tonight top to your adams bryan will ', title = 'all time of songs 20 love top '
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 668 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('love you the songs com www html 20 time me roberta flack my tonight top to your adams bryan will')) * 1 + (MATCH (post_title) AGAINST ('all time of songs 20 love top')) * 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 = 668 )
where post_status in ( 'publish', 'static' ) and ID != '668' and post_date <= '2009-03-30 15:16:18' 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 668 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('love you the songs com www html 20 time me roberta flack my tonight top to your adams bryan will')) * 1 + (MATCH (post_title) AGAINST ('all time of songs 20 love top')) * 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 = 668 )
where post_status in ( 'publish', 'static' ) and ID != '668' and post_date <= '2009-03-30 15:16:18' 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 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 668 and ID != 0
WordPress database error: [Table 'intimacy_db1.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 = 668 AND wp_posts.post_type IN ('post', 'page') ORDER BY yarpp.score DESC limit 5
INTIMACY4US’ Top 20 love songs of all time
- THE POLICE – Every breath you take
- FRANK SINATRA – Fly Me To The Moon
- CHICAGO – You’re the inspiration
- ROBERTA FLACK & PEABO BRYSON – Tonight, I celebrate my love
- ROD STEWART – Have I told you lately
- SONNY & CHER – I got you babe
- BILLY JOEL – Just the way you are
- ELTON JOHN – Your Song
- JOE COCKER & JENNIFER WARNES – Up where we belong
- ELVIS PRESLEY – Love Me Tender
-

THE RIGHTEOUS BROTHERS – Unchained Melody
- JOURNEY – Open Arms
- ERIC CLAPTON – Wonderful Tonight
- BRYAN ADAMS – All For Love – Bryan Adams
- WHITNEY HOUSTON – Will Always Love You
- DIANA ROSS & LIONEL RICHIE – Endless Love
- ROBERTA FLACK – The First Time Ever I Saw Your Face
- AEROSMITH – I don’t wanna miss a thing
- SINEAD O’CONNOR – Nothing compares to you
- CELINE DION – My heart will go on
*Sources: www.soundexp.com/top20.html, www.theydeserveit.com/songs/love-songs/top-20-love-songs.html, www.whatisthatsong.net/charts-lists/lovesongs.html, http://valentinelovecard.com/pg_songs_alltime.php, www.mylovehewitt.com/mylovenews/100lovesongs.htm
Popularity: 9% [?]
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.



Leave your response!