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
It is heartening to know that the F word has stopped haunting our Bollywood actresses now. They don’t feel the need to shy away from accepting what should, according to me, come naturally to them. It might take some time for them to open up properly about the importance feminism in their lives, but they(…)
There is good news for women who have been taking the contraceptive pill. A new study shows that those taking the pill have less risk of cancer. They are less likely to have bowel cancer, ovarian cancer and endometrial cancer than women who have not taken a pill. The study was conducted at the University(…)
Aamir Khan-starrer Dangal is still making a lot moolah, while clearly becoming one of Disney’s biggest overseas successes. Now this film, based on a real life wrestler family, will be specially screened for members of Parliament today in order to make the lawmakers aware of women’s empowerment while dishing out some entertainment. The whole idea of having a(…)
Are you one of those working women who juggles between the roles of a working professional and a doting mother and wife at home? Do your family members hold the view that your presence at home is vital for the family’s well-being? In this case, it is time to ensure that household work no longer(…)
Tennis ace Angelique Kerber has regained the No. 1 rankings in the WTA, dethroning Serena Williams who has slipped down to the No. 2 spot. Germany’s star player reclaimed the spot from Serena on Monday.
Despite being denied a Censor Board certificate, filmmaker Alankrita Shrivastava’s feminist film Lipstick Under My Burkha has been winning laurels in the film fraternity. “I feel if the intention of the board is to discourage people like me for making films like these, then they’ve failed. I am not going to change the kind of films I want to make.(…)
While crimes against women are on a definite rise, the funds allocated to the Women and Child Ministry to ensure safety remain underused. A parliamentary panel recently questioned the Centre about the reasons that deter the usage of funds in order to bring freedom to women in public and private spaces.
The new Chief Minister of Uttar Pradesh, BJP’s Yogi Adityanath has already made good his promise of setting up an ‘Anti-Romeo Squad’ to check eve-teasing and harassment of women, and the squad is already in action. However, this move has been met with a lot of apprehension as many say that instead of actually protecting women, it is a just another form of moral policing.
With an intriguing first look, actress Raveena Tandon flaunts fearlessness in her comeback film Maatr – The Mother. Despite of her glamourous roles in her earlier movies, director Ashtar Sayed has been able to bring out the best of her fierce look in the film’s poster. First look poster of #Maatr… Stars Raveena Tandon… Teaser(…)
Arundhati Bhattacharya is a well-known Indian banker and presently holds the chairperson’s position for the State Bank of India. She happens to be the first woman head of India’s largest bank – SBI which has a history of 211 years. Arundhati was listed as the 25th most powerful woman in the world by Forbes in 2016. After demonetisation she has led the state lender through one of the(…)