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
From today, women travellers in Karachi, Pakistan, will be able to commute without any fear of eve-teasing and sexual harassment. Pink taxis, especially for women travellers, will ply in the commercial hubs of the city. To tackle the problem of crime against women, a Pakistani resident, Ambreen Sheikh, has launched a cab service along with her husband, Zahid Sheikh titled — Pink taxi.(…)
The Women’s Reservation Bill has been a topic of debate for years now. While the NDA government had it in its manifesto while contesting for elections in 2014, it is yet to become a reality. To set the conversation in motion again, the Dravida Munnetra Kazhagam (DMK) party, led by its Rajya Sabha member, Kanimozhi,(…)
The Forbes 2017 list of the World’s Billionaires was unveiled earlier this week and features 56 self-made women billionaires. Cheers to these ladies who successfully secured their positions of being the richest women worldwide! This is the first time in Forbes’ 30-year history that so many self-made women billionaires have made it to the list.(…)
A two-day-long, 100 women edit-a-thon event was held in Bhubaneswar on 18 and 19 March. This first-of its kind of event in India, it was jointly organised by ‘Sambad’, arguably the largest circulated Odia daily, and Odia Wikipedia to mark the International Women’s Month. Edit-a-thons are events in which editors of various online communities, such(…)
Yugal Joshi is a history buff who found that the stories of women warriors in India were few and far between. So he set out to find and chronicle stories of Indian women warriors, and a year and a half later has come out with his book, Women Warriors In Indian History.
The female founder of the period underwear company, Thinx, has been accused of sexual harassment. A former employee of the company, Chelsea Leibow, has accused Miki Agrawal of making inappropriate comments, touching employees’ breasts and “having an aggressive and retaliatory demeanour”.