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
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.(…)
Simran Oberoi is a self-taught home baker and the founder of Ovenderful, a niche signature e-bakery that specialises in healthy and organic bakes, as well as classic bakes. She was also a mentee of The Cherie Blair Foundation’s Women in Business program for a year. In order to ensure that knowledge on healthy baking can(…)
95% of their employees are women, especially mothers. They do everything themselves, including stitching the product, finishing it, packaging it and shipping it. That’s the soul of Soul, a company into children’s products with a particular hold on the baby wearing business. Baby slings are their thing. The idea is to make them fashionable and(…)