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
Who does not dream of being a princess at least once in their lifetime? Imagine what happens when one, by virtue of their royal legacy, is born a princess. And while Rajasthan is filled with these royal families, we are talking about the royal family of Jodhpur and their one and only princess Shivranjani Rajye.(…)
The 12-member Indian squad participated in the Asian Rugby Seven, won a silver this year held in Laos, Vietnam on Saturday. At the tournament, the players participated under the aegis of the Indian Rugby Football Union (IRFU), the governing body for the sport of Rugby in India. #India finishes off at the 2nd Place in #Asia #Rugby(…)
The India Navy’s first all-woman crew comprised sailboat, eyeing to traverse global circumnavigation was flagged-off on Saturday at a ceremony in Goa. This is Navy’s second vessel Tarini, with an all- woman crew, sailed at the INS Mandovi Boat Pool. INSV Tarini Inducted–All Woman Crew Scheduled to Sail her around the Globe Commencing August 2017 https://t.co/5W6fpFxazt @SpokespersonMoD(…)
You might have heard the stories of plenty of strong women in history who fought their own battles by being in a man’s shoe. For some of them, it’s literally living in a man’s shoe! The 65-year-old Egyptian Sisa Abau Dauh El-Nemr who had to hide her identity and suited up as a man to earn bread(…)
In India you will notice that various regions will have a different default cooking oil that is used in the households for years and decades. Generally, but not entirely, South Indians cook in coconut oil, Rajasthanis in sesame, up north, sunflower and mustard oil remain to be favourites of families. With advent of the western(…)
“There wasn’t much to do in Delhi apart from dining or hanging out with friends. That’s when my partner and I thought of coming up with the idea of starting Break Room,” says Sanwari Gupta, Founder and CEO of Break Room. Break Room in Gurgaon helps you destroy items at your own will. Sounds bizarre?(…)
Popularly known as the ‘Iron Lady of Manipur’, activist-turned-politician Irom Sharmila is soon to get hitched! Sharmila was talking to reporters in Imphal on Thursday, when she surprised us all with the happy news that she will marry her long-term fiancé, Desmond Coutanho, after the assembly election session is over. Desmond Coutanho, an Irish national, is of Goan(…)
In a bid to make life a wee bit easier for Saudi women, the kingdom is now set to open female-only gyms in every district, according to CNN. The aim is to give women access to recreational activities so that they could join a gym without any hesitation. Also Read: Saudi Arabia Celebrates Its First Women’s Day(…)
Good health is not easily won. If you find yourself easily falling sick or finding yourself gaining or losing weight you are probably not taking charge enough. Here are some simple ways in which you can take that first step to living a more holistic and healthier life. 1. Don’t delay all your checkups Perhaps(…)
No female judge has been sworn in the Supreme Court in the latest round of appointment. As many as five judges were sworn in on Friday, but no woman was among them. The strength of SC has now increased to 28 out of the sanctioned 31, yet there is only one female sitting judge in the(…)