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
A balmy Sunday afternoon in Mumbai and the usual hunger pang that kicks in around 1pm… that’s how I met Maunika Gowardhan. Meeting a chef at lunch time seemed like a perfect set-up to have a fulfilling conversation infused with random anecdotes and story behind her recipes. Growing up in Mumbai, Maunika was inspired by her(…)
Far, far away from Clean India campaigns, people in India live, breathe, and work in villages and surrounding areas with zero fundamental amenities such as clean drinking water and public conveniences. One such place is the village of Gaurhari in the Mahoba district of Bundelkhand, which has not been cleaned in the past two months(…)
Entrepreneurs are always on the look out to a solution to a problem. To answers to their gazillion questions. So we at SheThePeople decided to reach out to some of the established entrepreneurs in the country to ask them things that probably cross your mind all the time. Get asked questions about your calibre? About(…)
Savita Devi sat on the dais along with four other women. One of them being Miss India Crown 1995, the other being an Architect and an Urban Transport planner among the other two. The panel discussion started with Savita Devi’s long monologue. Before she handed over the mic to the other panellist, she said, “Hum bajake aye hain”. The crowd(…)