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
In the hilly state of Uttarakhand, this young lady is quietly making a difference in the lives of the youth. Divya Rawat started a business of cultivating mushrooms to the stop migration of young people from the state to other metro cities in search of livelihood. Right from childhood, she had a soft corner for(…)
What happens when you work in the corporate environment but you are eager to follow your passion instead? Well, you follow your passion. This is exactly what Arunima Choudhury did. After working in the corporate world for more than 15 years, Arunima realised that she wanted to be more creative and expressive. Leaving a job(…)
At the Indo-Israeli Entrepreneurship Forum, Nitzan Solan’s eyes gleam with excitement as she explains her startup. The Israeli entrepreneur is the CEO and co-founders of LivingBox – a portable, modular and sustainable system that allows you to grow vegetables anywhere and everywhere. The standalone, fold-able LivingBox uses a hydroponic system enabling individuals or families to grow vegetables on water, without the(…)
The people of Bheeti Block, Ambedkar Nagar in Pandey Pakoli are distraught. Since the appointment of the new Pradhan, the people, especially the women, have not been given any work under MNREGA. People have been alleging that in spite of work being available, they have not been given employment. According to Anjali and Vidya, no new(…)
Here’s a dance you may have not known about. Just like Kathakali represents Kerala, Yakshagana is a dance that represents Karnataka. It is a unique traditional form of theatre that combines dance, drama, dialogue, music, make up and more. Yakshagana tells stories of Mahabharata and Ramayana and the dance typically begins in the twilight hours.(…)