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
What happened in Bangalore on 31st night was not only terrifying but a sudden awaking that the tech city is afterall not safe for women. It is telling that a city that has been a great melting point of people from around the world, donned the name Silicon Valley of India and being marshalling the(…)
It’s inspiring to see women defying stereotypes… and in so doing, creating their own trend. Take pop culture in Japan — which is pretty serious business! There’s already a fairly-established ‘norm’ in place, especially when it comes to showbiz — women and men have ‘perfect bodies’. The average weight of Japanese women between the age of 20-24(…)
Prime Minister Narendra Modi has announced new approach to loans, farmers and women in a bid to give them a boost in the economy and get them to contribute meaningfully in return. Here are key highlights you need to know. SMEs BOOST -Govt to extend credit guarantee to SME loans to Rs 2 crore, up(…)
Sheelika Ravishankar is part of India’s moon mission. A privately funded team that’s aiming to successfully place a robot on the Moon that explores at least 500 meters and transmits high-definition video and images back to Earth. All this before the end of next year. It’s the stuff dreams are made of – what’s the reality(…)
Meet Avneet Mann, a young and energetic founder for home and gifting brand called The Wishing Chair. An armed forces child who grew up all over the country, Avneet picked marketing as her specialty and join a corporation with a well paying job. But entrepreneurship in India was on the rise and Avneet felt the(…)