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
Leather was never her thing. And so Devika Srimal Bapna set course on a mission to find conscious shoes for herself. In the quest of wanting something unique, fashionable and ecofriendly, she started Kanabis. A PETA volunteer and an animal-lover, she wanted to do something completely different whether animals wouldn’t be hurt. “As an animal(…)
Young women in Haryana have enrolled in a skills training at a stainless steel plant in Rohad district. Over a four-month period, 180 young women will be trained to work in stainless steel application in Haryana, a state where women’s workforce participation remains low. The skilling programme is a one-of-its kind public-private partnership initiative led(…)
Founder of two startups, Sharmin Ali has recently written her second book How I Was Forced To Become A Staunch Racist, which documents her journey as an entrepreneur. Importantly, it also highlights the brutal truth about the sexist culture that still persists in the Indian startup ecosystem. Her book also questions why most people in(…)
Women in the National Capital Region were asked: Is Lack of Information a Critical Barrier to Availing of Skilling Opportunities? And here’s what the results looked like: 51.8% Strongly Agree 23.5 % Agree Source: UNDP SheThePeople Team visited Ashok Vihar in New Delhi to talk about skilling India, the informal economy, and why economic empowerment(…)
Bangalore-based Aparna Athreya’s self-funded startup –‘The Kid and Parent Foundation’– is running a conventional education system, not to bore, but to inspire children and parents about the fun-learning process.