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
Prime Minister Narendra Modi has helped 21-year-old Bibi Sara attain her MBA. The student who lives 100 km from Bengaluru needed Rs 1.5 lakh to complete her course. She had applied for a student loan to the Central Bank of India, but they had rejected her plea. She then wrote to the Prime Minister, seeking(…)
“Why should there be shame around Menstruation?” asks Twinkle Khanna who’s taken on the producer’s role for an upcoming film, ‘Padman’, which depicts the life of Arunachalam Muruganantham — known as the India’s ‘Menstruation Man’.
Danish Husain transitioned from a corporate banking job to theatre over a decade ago, and as we speak, I realise his enthusiasm for the medium still remains unfettered. Husain who is the founder of the theatre company Hoshruba Repertory, says, “There is a kind of immediacy to a live performance. The audience is inescapably engaged(…)
When it comes to saree and how Indians wear it, people have a fixed mindset, but when you try to break the norm, outrage is what we come across. A similar thing happened when a Toronto-based magazine — Jodi Bridal Show – unveiled its latest cover with a picture of a woman in a traditional saree but with a slit that reveals model Thanuska Subramaniam’s legs.
My Stealthy Freedom, the online Facebook campaign in which Iranian women post photos of themselves without the hijab, has started another campaign — this time to show videos of women who struggle with everyday hardships in the country.
My college authorities had organised a seminar to apprise us about Cyber Crime, the various ugly forms it can take and the extent to which it is embedded in our society. We were informed about digital footprints that we tend to leave. Those are permanent in nature and cannot be erased easily. The person conducting(…)
Work-from-home isn’t as easy as it sounds especially for a mom. It definitely has its perks, but it is far from fun when you have to meet a deadline while taking care of a sick toddler. So here is a list of 8 essentials to make working at home a little bit easier. Reliable Childcare:(…)
Comedian Amy Schumer has pulled out of Sony’s upcoming Barbie film because of scheduling conflicts. She signed on as the star of the film in December last year and her sister and her had also signed up to do a partial rewrite of the film. Schumer told Variety that she will no longer be able(…)
The Delhi Police have identified 165 dark spots in the city where crimes mostly take place and are unsafe for women. They are building a “total surveillance system” comprising CCTV cameras, spotters and emergency response vehicles (ERVs) under which all these dark spots will come.