2,854 views

Win Free Tickets for 2NE1 Concert in December 2012

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
select max(ID) as max_id from wp_yarpp_related_cache where reference_ID = 44105

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
select distinct ID from wp_yarpp_related_cache where reference_ID = 44105 and ID != 0

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 44105 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (1514,4,9173,5,6,4567,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (9174,37,2056,9177,9224,9223,9178,9291,3502,2569,9176,4371,2422,3277,1181,31,3191,2547,8828,8877,9225,9175,9226,9222,286,2548,76,8638), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '44105' and post_password ='' and post_type = 'post' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) union (SELECT 44105 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (1514,4,9173,5,6,4567,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (9174,37,2056,9177,9224,9223,9178,9291,3502,2569,9176,4371,2422,3277,1181,31,3191,2547,8828,8877,9225,9175,9226,9222,286,2548,76,8638), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '44105' and post_password ='' and post_type = 'page' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) union (SELECT 44105 as reference_ID, ID, ROUND(0 + count(distinct if( terms.term_taxonomy_id in (1514,4,9173,5,6,4567,14), terms.term_taxonomy_id, null )) * 1 + count(distinct if( terms.term_taxonomy_id in (9174,37,2056,9177,9224,9223,9178,9291,3502,2569,9176,4371,2422,3277,1181,31,3191,2547,8828,8877,9225,9175,9226,9222,286,2548,76,8638), terms.term_taxonomy_id, null )) * 1,1) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( 'publish', 'static' ) and ID != '44105' and post_password ='' and post_type = 'attachment' group by ID having score >= 2.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (21,96,98,6556,3586,1991,13606,1520,2505,67,7565,4,40,61,291,120,5,190,6,3706,426,4567,1716,15,6871,14129)) = 0 order by score desc limit 4) on duplicate key update date = now()

WordPress database error: [Table './btangxic_wrdp1/wp_yarpp_related_cache' is marked as crashed and should be repaired]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (44105,0,0) on duplicate key update date = now()

Want to win free tickets to 2NE1 concert on 1st December (in Singapore of course)? Just download the Loop & Meet App from SingTel on Android or iOS, follow a few steps (read on for more details) and you could win one of the three pairs of tickets to 2NE1 concert.

If you like to see more of 2NE1, you can check out Part 1 here or Part 2 here during their last visit at Clarke Quay in Singapore. Here is what you need to do to get a chance to win those tickets.

Click Here to Read More about it (PDF File)

Good luck. If you are chosen, have fun at the concert.

Subscribe

Subscribe to our e-mail newsletter to receive updates.

, , , , , , , , , , , , , , , , , , , , , , , , , , ,