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
Sonal Kaushal was all of six years old when she became a voice artist with All India Radio, Delhi. She anchored several shows as well, and by the time she was a teenager she was offered to dub for the popular Japanese Manga-series Doraemon as the title character itself! She has been the voice of Doraemon(…)
While we Indians are so busy getting upset about how Indian men faced a terrible defeat at the hands of Pakistan on June 18 in the Champions Trophy 2017 Final, that we forgot to look beyond. Last night, when the Indian women cricketers took down England by 35 runs in the ongoing World Cup campaign and Captain Mithali Raj, who scored seventh(…)
High on their form, Indian women cricketers brought glory as they clinched the very first match of their World Cup campaign against England by 35 runs. There could not be any better opener for the Indian squad, as it would enable them stay put for a long run in the ongoing ICC women’s World Cup, which kickstarted in England(…)
The Pride month of June saw a worldwide celebration of homosexuality and the LGBTQ community with people participating in marches and walks in large numbers. But in a corner of the world, there is a growth of homophobia. Some people are becoming extremely vocal about their hatred and this small group has grown to influence(…)
An Indian-origin Sikh became the first turbaned woman to hold a chair in the judiciary in Canada, the World Sikh Organisation (WSO) of Canada said, Voice Online reported. Human rights advocate Palbinder Kaur Shergill has been appointed as a judge of the Supreme Court of British Columbia in New Westminster. Congrats to former Surrey Bar Association director(…)
Alex Mathew knew that he had a feminine side to him, but didn’t know how to bring it out or express that side. That is until he watched Mrs. Doubtfire. Robin Williams inspired him to embrace Maya, and since then he has never looked back. Maya is a fierce, sensitive, caring Keralite woman who lives(…)
Sara Geurts is battling a genetic condition called the Dermatosparaxis Ehlers-Danlos syndrome that affects ‘every system in the body’. This rare disease makes a person’s skin extremely soft and doughy.
Sowmya Nanjundaiah is the CEO of Incite, one of India’s ten most promising digital marketing solution providers. She started her company in 2010, a time when digital marketing was still relatively nascent and she always believed that it was the future of marketing. She says, ”Our ability to do this strategically as opposed to tactical campaign(…)
Last year, Malvika Joshi made news for getting into MIT, without obtaining a class 10 or 12 school certificate. Joshi had been homeschooled and had found it difficult to get into IIT without a certificate. However, the prestigious American college admitted the wonder kid with open arms. Her mother Supriya is an advocate of homeschooling(…)
A woman constable recently went beyond the call of duty to save not one but two lives. When a 24-year-old woman went into labour at Thane station, the woman constable, Railway Protection Force (RPF) officer Shobha Mothe, along with other women commuters helped the woman, Meenakshi Jadhav, deliver a baby boy. What was a regular day(…)