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
Is the media obsessed with women athletes? Is promoting their appearance, not talent, is what the audience demands? Why is the focus is always on female athletes’ looks? For any athlete, the focus should be on their expertise and athletic ability, right? But when it comes to women sportspersons, the picture slightly shifts from competence(…)
Criminologist Rachael Aplin’s new research shows that mothers are a ‘driving force’ in honour-based abuse. Out of the 100 honour crimes she studied, 49 of them involved mothers perpetuating the crime. However, the mothers’ roles in these crimes were often not recorded.
The Gurgaon administration has begun a drive to increase the female sex ratio in the district. It has also announced a Rs 1 lakh reward for individuals and citizens’ bodies, which are willing to provide information on female infanticide. The administration came up with these measures after many cases of baby girls being dumped in garbage bins. Also,(…)
The women and child development (WCD) ministry will now reportedly keep cradles at government hospitals, orphanages and police stations across the country where one can leave their child behind for adoption. The cradle will also have a bell for the person to ring so that the authorities can be notified. After being notified, officials will take the(…)
Blockchain, or distributed ledger technology, could soon give rise to a new internet era that is even more disruptive and transformative than the current one, according to a white paper, ‘Realizing the Potential of Blockchain’, published by the World Economic Forum. Blockchain’s ability to generate unprecedented opportunities to create and trade value in society will(…)
We all hope that the society is now more familiar with the basics of gender equality. But then comes the arrow from the pop culture world where every now and then someone misses the mark of equality, to shatter that hope. This time it was Ranbir Kapoor mansplaining for Katrina Kaif.
The success of Indians at the Paralympics 2016 has opened new avenues for the specially-abled community in the world of sports. So come July and the Women’s Wheelchair Basketball team will represent the country in the 4th Bali Cup International Tournament. While the women’s team is looking forward to representing the country at the world stage,(…)
It was a weekend and I felt like dancing. In Delhi, Turquoise Cottage in Adhchini and later, in Vasant Vihar, were the places to be—great rock music and a fun group of people coming together. I was with a couple of friends, and I called another friend over. Delhi throws up gatekeeping with sickening regularity—and(…)
India is an inherently racist country. There I said it. Every one of us has faced some form of discrimination when travelling to a part of the country we don’t call native. A South Indian gets labelled as “Mallu” in North India, a Northeasterner as “Chowmein/Momo/Chinky” in mainland India, a North Indian as “Bihari” in(…)