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
Gauri Sawant born Ganesh Sawant adopted her daughter even though it is illegal for transgender people to adopt children. “There’s no gender in being a mother,” she says. Sawant, left her family at an early age to come to Bombay. While working at a NGO, Gauri came across her daughter, Gayatri. Gayatri had been orphaned(…)
Solo in Spain is our series for travel this summer. Women travelling across the region and exploring the sights and sounds. Here’s a breathtaking stopover. Gran Canaria is a captivating place, a little Garden of Eden in the middle of the Atlantic Ocean, which woos its visitors. In this decalogue we will give you all(…)
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,(…)