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
In one sniff Sunalini Menon can tell you of its origin, its potency, its fragrance notes and more. Coffee may not be single malt but Sunalini of Coffeelab India has been getting nuanced experience in understanding coffees. She started this journey in 1971 and has been the pioneer of India’s specialty coffee revolution. She started(…)
From Hinduism to Judaism to Christianity to Islam, religious restrictions surrounding menstruation and the belief that it makes women’s bodies impure are common across the board. While the judiciary has upheld women’s right to equality in cases of Shani Shingnapur, Haji Ali and Sabarimala, where women were denied entry to religious sites, the practice continues(…)
If you are harbouring the dream of kick-starting your own business venture, it is vital for you to have a clear understanding of what it is that you wish to achieve with your idea. It is imperative then to not just have a target audience but a network of people in your field – peers,(…)
What happened in Bangalore on 31st night was not only terrifying but a sudden awaking that the tech city is afterall not safe for women. It is telling that a city that has been a great melting point of people from around the world, donned the name Silicon Valley of India and being marshalling the(…)
It’s inspiring to see women defying stereotypes… and in so doing, creating their own trend. Take pop culture in Japan — which is pretty serious business! There’s already a fairly-established ‘norm’ in place, especially when it comes to showbiz — women and men have ‘perfect bodies’. The average weight of Japanese women between the age of 20-24(…)