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
The modern workplaces are changing. Some are putting extra pressure on our work lives. While there are many other reasons why we feel tired and fatigued. Perhaps the pressure is omnipresent? The recent surge in the number of working women in India is a positive step towards making women financially independent, but can’t deny it(…)
Soon after women around the world protested the disparity, sexism and inherent bias they face in their professional and public lives, twenty aspiring and successful Women entrepreneurs gathered to reflect and emerge from the challenges of being a “boss lady” in an otherwise male-dominated environment. At SheThePeople’s Rise and Shine Power Breakfast event on Tuesday,(…)
Anita Dongre is India’s Queen of Pret. It’s been 21 years since she launched her first label, AND. She started out with a 300 sq ft store and today has 475 stores across the country. Her company And Designs India Limited (Now House of Anita Dongre) was born in 1995. House of Anita Dongre boasts of diverse brands such as AND, Global(…)
Being the daughter of a film star who is considered no less than a god by some people can be a surreal experience, and director Aishwaryaa Dhanush is very open about being grateful for most of it…But she also reveals something about losing out on “normal” childhood, in her memoir Standing on an Apple Box. Beyond being(…)
She’s known for her “manly” style, and hot temper in Haidergarh block of District Barabanki. And of course, her supremely addictive self-confidence. Her name is Rani Kanojia and she’s a well-known figure on the political scene in Barabanki. Rani owns a petrol pump in Dadupur village eight kilometers from Haidergarh, and she likes to use(…)