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
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(…)
Promises to be a saviour for new mothers. But even bigger, it’s a promise of how women are exceeding all expectations in technology. Raybaby is a technology enhanced health and sleep monitor for babies that works as a watchdog for parents to keep a track on their babies’ breathing and sleeping pattern through a mobile app.(…)
https://vimeo.com/205657097 The Delhi High Court is well into 50 years of existence. Yet even today there are only 10 female judges working there out of the total strength of 40. By the way, Delhi High Court has apparently got the largest number of female judges among all the HCs in the country. So where are the missing(…)
Some sessions of Women’s Writer’s Festival didn’t delve into the delicate niceties of being a woman. Thank god. It sprung open a so-called Pandora’s box where women felt safe to enquire – why does my mother come home early when both my mother and father are working in the same business that they had started(…)