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
22-year-old Shanti Mahli was very young when she lost her mother. Being the eldest daughter in her family of two younger sisters and father, a brick kiln worker, from a very young age, she had to do household chores. While young children cry for candies and toys, Shanti cried because her father beat her up(…)
Following the recent gangrape of a 35-year-old woman in a car moving from Gurgaon to Noida, the police have arrested three accused in the case. The car in which the heinous crime took place has been seized, ANI reported on Thursday (June 22). The rape survivor is originally from Rajasthan and had come to Gurgaon in(…)
While the United Nations appreciated Colombia for putting an unprecedented focus on women’s rights and keeping their problems and issues that arose as a result of the 50 years long war in the centre, a recent study by a Colombian Rights Group called GPaz claims otherwise. The war that had been going on in Colombia created(…)
Double births often evoke startling reactions and have fascinated people since ancient times to be at the core of many tales and myths. There doesn’t seem to be a culture which has not got a good tale involving twins. The fact that they were extraordinary, and often unexplainable, myths and legends grew around them, mostly(…)
Imposter syndrome is when someone feels like they don’t deserve their success, when they feel like an imposter in their current role — when they feel like they just don’t belong. Psychologists have found that women feel the imposter syndrome more than men. Among the successful women who have felt like imposters are Emma Watson, Kate(…)
Facebook has announced that it will pilot new privacy tools to provide people in India with an enriching experience while using the social media platform. The decision was taken after the realisation that a lot of women avoid putting a profile picture on Facebook fearing they will get downloaded and circulated. “In our research with(…)
In a new study done by skincare brand SK II and Proctor and Gamble, only 2 out of 10 women said that they were comfortable with getting older. The survey took views from 4,280 women and 3,261 men aged 18 and older across Japan, Korea, China, Hong Kong, Taiwan, Thailand, Malaysia, Indonesia, the US, the(…)
Slam poetry has been gaining popularity on social media over the last few years. There are a lot of men and women who write their own poems and then go on stage and perform them. This is called slam or spoken word poetry. These performances are then recorded and posted on social media. You may(…)
Gymnast Dipa Karmakar, who won accolades at the Rio Olympics for performing the ‘vault of death’ — the Produnova, is skipping the World Gymnastics Championships as she is recovering slowly from a knee surgery.
When Deepika Padukone spoke out about her depression, she also spoke about the woman who had helped her through it. Counsellor Anna Chandy provided guidance and friendship to the star, and later became the chairperson of Padukone’s Live Love Laugh Foundation, an organisation that aims to reduce the stigma around mental health. Chandy’s new book(…)