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
School for Justice is an initiative by Free a Girl Movement to help the girl’s abducted or sold for human trafficking. The campaign’s main objective is to take the girls out of the brothels and into the law school, so that the survivors can fight for their own justice. The girls will be given all the necessary(…)
She is straight out of jungle book. Except that she finds herself in urban Delhi now, in a hospital having to go back from being a human-monkey to a normal human. This young girl grew up with monkeys. She talks in a broken muttering style and is being attended by medical officers. The day she came(…)
SheThePeople.TV spoke with India’s highest selling author, Amish Tripathi — best known for his Shiva Trilogy, about his new book ‘Sita: Warrior of Mithila’. The book is the second one in Tripathi’s Ram Chandra series, and portrays a Sita who is very different from the docile wife whom most of us are familiar with. In(…)
Poonam is a teenager from Varanasi. She used to firmly believe that girls should stay at home and eventually get married. “Today I feel girls should have full freedom,” she says. What changed for Poonam? She and a bunch of girls in her community learnt to play football. Bend it Like Poonam: Varanasi’s Girls Challenge(…)
Shabana Azmi and Manish Malhotra headlined an event to promote the inaugural Indian Academy Awards Women Achievers Award in New Jersey. The event honoured 15 women, selected through a process audited by Ernst and Young, along with a fashion show and fundraiser for Azmi’s NGO Mijwan Welfare Society. “True progress of a society is not(…)