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
India’s coveted list of Indian female authors has another name added to it. This time, it is a 15-year-old girl. Zuni Chopra, author of The House That Spoke, discussed about her journey as a writer at the Women’s Writers Fest held recently in Mumbai. Zuni started her writing journey with a book of poetry. Talking(…)
Sunita Maheshwari, the co-founder of Teleradiology Solutions, one of the best radiology companies for radiology services in India, describes herself as “one of those kids who always knew she wanted to go to medical school”. Her first love was medicine and not technology. But as luck and destiny would have it, the two came together(…)
They are shattering the glass ceiling in science and tech. They are driven, committed and convinced that the future is female. Meet the women who took India’s mission to mars in a most successful way. When in 2014 the Mars Orbiter Mission was successful and India became the first country to achieve this feat in(…)
On International Women’s Day, here are eight Indian women who have forged their own destinies and carved their own careers, letting nothing and no one get in the way of their dreams. Gitanjali Surendran, Lawyer 1. “It is important for one to find the things that speak to you… but there needs to be a larger systemic change. Women are(…)
Three powerful political faces in India called for a stronger effort towards women’s equality in India. Former Finance Minister P Chidambaram, Niti Ayog CEO Amitabh Kant and Parliamentarian Sachin Pilot all called for economic empowerment, strengthening of women’s position in public life and a greater role in decision making. Three Powerful Men Stand For Greater(…)