SELECT DISTINCT tt2.term_id AS tag_id, sum(pv.count) as priority
FROM u1nugz_posts as posts
INNER JOIN u1nugz_term_relationships as tr1 ON posts.ID = tr1.object_ID
INNER JOIN u1nugz_term_taxonomy as tt1 ON tr1.term_taxonomy_id = tt1.term_taxonomy_id
INNER JOIN u1nugz_term_relationships as tr2 ON posts.ID = tr2.object_ID
INNER JOIN u1nugz_term_taxonomy as tt2 ON tr2.term_taxonomy_id = tt2.term_taxonomy_id
INNER JOIN u1nugz_term_relationships as tr3 ON posts.ID = tr3.object_ID
INNER JOIN u1nugz_term_taxonomy as tt3 ON tr3.term_taxonomy_id = tt3.term_taxonomy_id
LEFT JOIN u1nugz_post_views as pv on pv.id = posts.ID AND pv.type = 'total'
WHERE posts.post_status = 'publish'
AND tt1.taxonomy = 'category' AND tt1.term_id IN (8,5,149)
AND tt2.taxonomy = 'post_tag'
AND tt3.taxonomy = 'post_tag'
group by tag_id
order by priority DESC limit 4
Swapna Liddle was bombarded with questions after she wrapped up a session with author Omair Ahmed. Swapna Liddle, convenor at Indian National Trust for Art and Cultural Heritage and an author was at the World Book Fair Delhi to talk about her new book and discuss ‘Delhi as a Historical City’. A tall guy in a coat(…)
She’s managed to carve a niche for herself in highly competitive Bollywood and that’s no mean feat. Tisca Chopra is talented, smart and an achiever. But her journey hasn’t been easy. Post her Bollywood debut 24 years ago, she struggled to find meaningful roles. She’s Unstoppable With Tisca Chopra, Her Film Chutney wins Filmfare Award She(…)
Fashion director for Vogue India, stylist and creative consultant Anaita Shroff Adajania is a one of the stalwarts of the Indian fashion industry. One of India’s foremost film stylists, she began her styling career when most people didn’t know what styling was. Bollywood first took notice of her when she styled Dhoom 2 but it was(…)
In one sniff Sunalini Menon can tell you of its origin, its potency, its fragrance notes and more. Coffee may not be single malt but Sunalini of Coffeelab India has been getting nuanced experience in understanding coffees. She started this journey in 1971 and has been the pioneer of India’s specialty coffee revolution. She started(…)