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
Former Secretary of state and Presidential Candidate against Obama in 2008; Hilary Clinton is one of the most powerful and influential women in the United States. Married to former President of the country, Bill Clinton, she has not just been the ‘First Lady’ and has had an active political career. With many gender issues(…)
Recently tying first with Tavleen Batra at Hero Women’s professional tour, 2014 in Pahalgam; at the age of 42, Simi Mehra is one of the leading golfers in the country and a pioneer of the sport in India. Born in Kolkata, Mehra was interested in golf since she was in school. When she grew(…)
Having taken a few steps in the direction of progress, a lot of companies now somewhat have a balanced men women ratio at workplaces. However, as you go up the number of women keeps decreasing and less than roughly 5% of all companies have women at top positions. According to a report by(…)
Women sportspersons have always struggled when it comes to receiving the same fame and fortune as their male counterparts. Especially in developing countries, this problem is more apparent. In most developed countries however, this gap seems to be slowly decreasing. Sportspersons like Maria Sharapova and Serena Williams are currently the highest earning women sportspersons(…)
The increasing, or at least stagnant gender pay gap has been discussed a lot of times in the past. As grave as the problem is, it is high time to stop discussing the problem and start figuring out solutions. A recent report by The Guardian, proposed five ways in which we could end the gender(…)
Yael Shafritz, a student of politics at the University of Sheffield, who has recently been elected the student union President- the first woman to get the position in eleven years, shares her experience. She announces that studying in a convent schools, she experienced sexism first-hand. Yet, she did not think that she would see a(…)
Women all over the world are making progress at workplaces- more in certain countries than others. Women leaders however, have additional challenges that need to be dealt with. The Wall Street Journal asked a few leading women about these specific challenges and the ways in which they overcame them. Angela Braly, the CEO of(…)
Those of us who grew up around both parents, mostly remember spending less time with our fathers than mothers (irrespective of whether they were working or not.) The traditional gender roles have always dictated that men are providers where as women are nurturers. Even in the households where both men and women both are breadwinners,(…)