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
Women’s safety, sexuality and liberation were the topics of discourse at a recent event organised by Apne Aap Women Worldwide in Delhi. Reciting their work at this event were Anju Sharma, Ashima Kumari, Ashok Pandey, Ngurang Reena, Sanjay Shepherd, Madhu, Aruna Lakshmi Ramu and Dr Sujata.
After months of staying away from home, Priyanka Chopra recently landed in Mumbai. Soon after her return, Bollywood was abuzz with the news that the actress has bagged an unconventional film. She would be seen essaying the role of astronaut Kalpana Chawla in a biopic directed by newcomer, Priya Mishra. If the reports are to true,(…)
The Punjab Government seems to be finally working towards elevating the status of the girl child. According to a report, the government has formulated a comprehensive policy to improve the sex-ratio of the state. It aims to achieve this by ensuring proper implementation of the ban on pre-diagnostic tests. Health minister Brahm Mohindra expressed concern over the bleak sex-ratio(…)
In February, the world’s heaviest woman, 36-year-old Egyptian Eman Ahmed, had flown down to India for a weight-loss surgery. Now her family has alleged that her surgeon Dr Muffazal Lakdawala and the hospital who treated her are liars and that she has not lost as much weight as they are claiming.
Polycystic Ovarian Syndrome(PCOS) has become a common lifestyle disease all over the world. In India about 18 per cent of women suffer from PCOS. That’s 1 in every 5 women we know. Polycystic ovaries occur when there is an imbalance in hormones, due to which the level of androgens (male hormones) in the body become(…)
Over the last 10 days I was one of the facilitators of a virtual Rotary peace conference #BridgesForPeace on Zoom, moderated a session on the use of social media for social good on behalf of the US Consulate Mumbai, was named one of Top 30 women who champion feminism on social media in India and(…)
Women’s online safety is taking centre stage for all social media platforms. In India, from tackling trolling, suicide and depressive comments through posts, the challenges are many. The number of Internet users in India is expected to reach 450-465 million by June, up 4-8% from 432 million in December 2016, a report from the Internet(…)
Last year the then 16 year old Sandhya was rescued from becoming a child bride. She was studying for class 10 exams in Hyderabad’s Ranga Reddy district, when her father decided to marry her off. After complaining about her situation, she was saved from her marriage by child rights activists. She has now scored 93(…)
Essential oils are all the rage nowadays. In the US, people have been using it for different purposes, but this trend has just started to catch on in India. Most home shop stores in India have essential oils stacked up with diffusers. However, if you’re looking for good quality essential oils – buying them online(…)