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
If we put together all of the Amul ads in chronological order, we would have ourselves the news that mattered to us the most in the last 50 years. The blue-haired girl in the red-polka dotted dress struck a chord with us right from the start. She became a national favourite for her bang on-time, tongue-in-cheek one-liners(…)
This Christmas, 18 mothers from across Delhi came together to set a new milestone — they were part of the first ever baby-wearing flash mob in Delhi, yesterday. Mothers with infants as young as 2 months joined the flash mob to groove to the universal, Jingle Bells. The event was very well received by the people(…)
Women entrepreneurs are breaking new ground everyday. Whether its their new ideas, or their ability to adapt to market needs. In an effort to mentor some of these stellar women, a special program by Tipping Point 1.0, in partnership with SheThePeople.TV is conducting special sessions. Of many who applied, 25 finalists have been picked. We(…)
For Seema Chaturvedi, realising that she could be an entrepreneur was very empowering. Seema, who founded the Accelerator Group, has over 17 years of experience in capital markets and financial management. She is an investment banker and corporate finance advisor and has worked with JM Financial Services, which is an Indian affiliate of Morgan and(…)
Princess of Parallel cinema, Tannishtha Chatterjee spoke to SheThePeople recently about the role of Pop culture in changing the mindsets of people. She told us why “Pop is what creates the mass culture” and she is very convincing! She also tell us how she chooses her movies. Chatterjee, recently hit the news when she walked out(…)