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
Author Vera Hildebrand talks about her book on the Rani of Jhansi Regiment, the first all-women infantry regiment in the world. Vera Hildebrand has authored a book that takes us back in time. The history of women at war. We have always known of India’s freedom struggle and women who have led that but very(…)
Facebook, after successfully hosting Boost Your Business program in multiple cities in collaboration with SheThePeople.TV reached Lucknow, their seventh city in India for this noble initiative. THE BOOST YOUR BUSINESS PROGRAM The Boost Your Business program, a high energy meet of women entrepreneurs, helps women entrepreneurs to gain expertise in various fields that can benefit(…)
Women are a big part of Make In India. As SheThePeople Founder Shaili Chopra says Make In India shouldn’t be a lion but a lioness. As part of our ongoing effort to put the spotlight on entrepreneurs and women startup owners, we are featuring Wishberry, that’s an end-to-end solution to all crowdfunding needs of creative(…)
Celebrating stories of Mums is what keeps Blogger-Storyteller Reshma Krishnamurthy busy. In her entrepreneurial venture, she shares stories of mothers with the world through an online platform called Mums and Stories. “When I felt that one can connect with lots of mothers, I started this. I had to make it viable for me as a mum(…)
A Miss India winner, Model, Actor, entrepreneur, style icon and now producer & talk show host, Neha Dhupia is multifaceted and diverse. She began her Bollywood career in 2003, after winning the Miss India title in 2002, and in the last 14 years has starred in films of all genres. She has been praised for her(…)