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
Contraceptives. A most basic concept, a plain and simple word. But we in India are fearful of uttering it. People look around while talking about it. Yes, even now. How well do we know our contraceptives? And why should we really know them? I decided to go out into the streets to find out what(…)
52% of girls in our country have no future because they are not able to study. One major reason why they cannot study further, or opt out, is because they are often teased, molested, raped or sexually harassed. Rather than dealing with these issues, the quick-fix solution families and societies abruptly resort to is pausing(…)
The digital space in India owes women for its tremendous outreach over the past few years. Women entrepreneurs in various sectors are embracing new tech, building businesses, turning new and irregular opportunities into new ideas, giving wings to brilliant ideas, boosting economy — all of this is transforming the work scenario for women. SheThePeople.TV picks thirty resilient(…)
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(…)