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
Nina Lekhi turned an entrepreneur when the words starting up were not even fashionable. Entrepreneurship meant business and that was an idea most women in her times (1980s) steered away from. Nina started and built Baggit, probably India’s first bags enterprise made in India. Travelling from the comfort of her home to the bylanes of(…)
Heads Up For Tails founded by Rashi Sanon Narang has recently raised $2 Mn in a Pre-series A round from a closed group of HNI’s. With this new amount of funding, HUFT is all set to expand the brand in the country and abroad and invest in technology. Rashi started HUFT because being a pet(…)
Indian cities like Pune and Bangalore have been IT and Marketing hubs. They have boasted educated and diverse employees, including a significant number of women in their workforce. In this light, the incidents such as mass molestation and murder case of an IT employee in Pune raise security concerns. She The People talked to working(…)
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(…)