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
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(…)
She started yoga at 9 and it’s been a mission since then. Niharika Tugnait, 24 is a young Indian origin girl based out of Toronto who recently joined SheThePeople.TV at our summit She Leads India in Delhi. Niharika learned yoga from her grand parents but then quickly built on it to make it interesting for(…)
This cafe by the river in Srinagar is inspired by the tea rooms in Cotswalds, England, and brings a local Kashmiri flavour to an otherwise English concept. But it’s much more than a chai place. It’s a place many girls come, to ‘breathe in’ and stay safe from staring eyes. It’s also where cultural conversations(…)
I already love this idea. When stressed, go chill with a pet. What’s that saying? A dog is a person’s best friend. Having a dog at home or at workplace can have a lot of benefits such as 10% drop in blood pressure, chemical changes in the body such as cortisol, dopamine and serotonin which have(…)