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
Carissa is a business woman, a writer, a travel junkie and ahem… a Whisky Lady. Wondering how a woman likes her peg of whisky? Well Carissa loves the entire process of nosing, sipping and savoring the “water of life.” Carissa, originally from Canada has been living in India for over two decades now and calls(…)
ICC men’s world cup flag off on March 8th at Nagpur while the women’s cup will begin from March 15th, with the first match being played between India and Bangladesh at Bengaluru. But hey, why are we not talking about the women’s team? While ICC men’s ratings are 126, women score 111, which is great(…)
The Forbes list of world’s richest people is out and features 190 women billionaires, approx. over 10 per cent of the total count last year. Five Indian women have successfully made their names enlisted. Indian women in this year’s Forbes billionaires list has increased over last year, when there were only two Indian women included.(…)
Meet 18-year-old Sataparna Mukherjee, a student of Class 12 from a village around 30km from Kolkata. No she wasn’t hired in any big company on a fat salary. Those headlines are tiring us out. Sataparna’s story is refreshing and laudable. She has been selected by the National Aeronautics and Space Administration (NASA) for its prestigious(…)
Women in UK based organization will now be offered ‘period leaves’ to deal with the discomfort associated with the monthly cycle. Bex Baxter, one of the directors of the Bristol based company named Coexis – who also happens to be a woman – came up with the idea after observing her female employees going through(…)
Finance Minister, Arun Jaitley has favoured start-up revolution in the country giving women entrepreneurs a special allocation. He praised the fact that now the job-seekers have become job-creators. He also gave some attention to rural women and their household chores. As in the case of start-ups, Jaitley has proposed 100% tax redemption in the first(…)
This March – the women’s day month – Feminist Rani is a very special one. Putting the spotlight on Mary Dore, a feminist filmmaker who directed She’s Beautiful When She’s Angry. Dore is known for her candid style, brilliant storytelling and deep understanding of the subject of gender balance and feminism. Her work has won(…)
Shoma Chaudhury, Editor-in-Chief of Catch News has reportedly been asked to leave her job. The Rajasthan Patrika led digital platform will no longer have Chaudhury as its head. An email by Chaudhury to her colleagues spelt out her disappointment as well as what she called the ‘abruptness’ of the decision. “I’m writing to tell you(…)
Finance Minister Arun Jaitley’s budget proposal presented by him this morning at the Lok Sabha came as a serious disappointment to the women. Promises made to women entrepreneurs at Startup India by PM Narendra Modi were not kept. The nation’s budgetary estimates were laid on the following ’9 Pillars’, but none of the pillars had provisions(…)
Finance minister Arun Jaitley revealed the Budget for India today – it’s been called a mixed bag with some good ideas in place but not enough to put growth on full throttle. Entrepreneurs have been hopeful to get more from the budget and so this might have even disappointed them a tad. Here are the(…)