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
A viral video shows a Caucasian woman demanding that a White doctor treat her son. The incident took place at a Canadian medical facility where the mother insisted that she see a White doctor, not a brown one with an accent. “So you’re telling me that my kid has chest pains, he’s going to have(…)
Chandra Gopalan, Director of Contours India, biggest chain of women’s gyms in the country, quit her job as regional manager of Swiss Air to pursue her passion as her profession. Chandra is the first senior woman to complete the 100 kilometres and a 24-hour run on the Bangalore Ultra. She loves running, it is a way of life(…)
College is not just about getting a degree, but also working on your passions and hobbies at a more professional level. Collegiate extracurricular groups give a foundation for actors and dancers to grow and see what the professional world looks like. However, it is not all rosy; there is struggle and competition where people are(…)
A 12-year-old Mormon girl, Savannah, recently came out to the members of her church. Savannah came out to her parents a day after her birthday on June 22nd of last year. Her parents and her friends had learnt to accept her, and Savannah decided that she wanted to come out to her community as well.(…)
Students pursuing BA English course in Mumbai University will now get a chance to study works of new authors. The change has been made to help students enhance their knowledge by studying a diversity of cultures and perspectives. The new authors will be a part of Indian Writing and American Writing papers which are worth 100(…)
A new study by the Population Reference Bureau (a nonprofit that looks at population and other development issues) in the United States found that young American women, namely millennials, are poorer than their mothers and grandmothers and their well-being is declining. The study revealed that these women were more likely to face mental health issues, and(…)
As part of the Father’s Day series #TaughtByDad, we bring you a lovely, heart felt piece by Nidhi Agarwal, Founder of Kaaryah. She reflects on what makes him her biggest safety net, her unconditional friend and a champion of her fearless self. For most women, the very first impression of a “man” is that of(…)
The much-awaited step proposed by the Maneka Gandhi-led WCD ministry might just see the light of day in the capital city. The Aam Aadmi Party has cleared the proposal to install CCTV cameras in all DTC buses and cluster buses moving in the city to ensure women’s safety. “The cabinet approved the Transport department’s proposal to authorise(…)