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
Vasudha Veerrana ran a digital agency, and Seema Sharat ran a fitness studio. When Seema contacted Vasudha for their digital marketing services, the two instantly got along and started discussing what they could do together. Seema had a property in the outskirts of Bangalore, so they came up with the idea of a ‘co-creating’ space.(…)
It is often common (read: misogynistic) parlance to say that women merely know how to spin yarns. However, the women of the village of Bhaudi in Mahoba continue to shatter this deeply patriarchal attitude merely by existing and living their lives, supporting their families. They literally have to scale mountains and brave jungles to pluck(…)
Have you ever moved to a new city and wondered how you can get to know the city better? Shikha Nambiar, an illustrator based in Bangalore had a genius idea. She took the internet challenge called #100DaysOf last year, and she turned it into a learning experience for herself. Shikha did law school and worked(…)
In the hilly state of Uttarakhand, this young lady is quietly making a difference in the lives of the youth. Divya Rawat started a business of cultivating mushrooms to the stop migration of young people from the state to other metro cities in search of livelihood. Right from childhood, she had a soft corner for(…)
What happens when you work in the corporate environment but you are eager to follow your passion instead? Well, you follow your passion. This is exactly what Arunima Choudhury did. After working in the corporate world for more than 15 years, Arunima realised that she wanted to be more creative and expressive. Leaving a job(…)