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
Gurmehar Kaur is a real example of a survivor of online sexist abuse. Trolling is a new-age phenomenon which basically means commenting abusively to a particular gender or about a particular gender on the internet. Women go through this all the time on social media from people who do not agree with their thought-process. SheThePeople.TV(…)
It seems like everyone’s writing a book today. Everywhere you look, there’s a celebrity waving his or her memoirs on your TV screen. And since Bollywood has such a significant influence on Indians, it’s a matter of time before every single person you know will start wielding the pen. If you dream of being an(…)
Located in Jeevan Bheema Nagar, Bangalore, the Cat Studio is place where you can go and experience cats. All the cats there are rescued and put up for adoption. If you fall in love with one (or more) of the cats, you can always adopt them! Started by Osha Shetty and her husband last year,(…)
Could I say you have to be living under a rock in India if you don’t know about the legendary father who defied the patriarchal society in Haryana and trained his daughters into becoming national wrestling champions. The father in focus here is Mahavir Singh Phogat who trained his daughters Geeta and Babita along with(…)
Eminent lawyer Karuna Nundy took up law by chance. Born to parents, who were both working in leadership roles, Karuna studied Economics from St. Stephen’s College, Delhi University. Then she went on to become a TV journalist at the age of 19. Journalism didn’t empower her enough she says. A few strong legal stories kindled(…)