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
Some sessions of Women’s Writer’s Festival didn’t delve into the delicate niceties of being a woman. Thank god. It sprung open a so-called Pandora’s box where women felt safe to enquire – why does my mother come home early when both my mother and father are working in the same business that they had started(…)
Vijay Menon has been a champion of entrepreneurship for years. Through his work at TiE Global, he pushes young startup owners to take risks, get mentorship and scale up businesses. He says diversity in the workplace has to go much beyond lip service — women in leadership positions are a win-win for all. Are Indian(…)
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(…)