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
Falguni Nayar is one of India’s top shot bankers who also sits on prestigious boards such as Tata Motors. She quit her active and vibrant banking career to become an entrepreneur and opened up India’s first online dedicated space for beauty and wellness called Nykaa Dot Com. SheThePeople.TV speaks to her about her deep plunge(…)
In this final posting on the current topic of leadership, I complete our review of some of the different approaches to discussing the traits that are commonly identified with an effective leader. Those of you who have read the previous postings will recall that I began the discussion with models that involved more simplified structures(…)
Across rural India, poor women are changing their lives and their children’s lives. In the aptly-named “Self Help Groups”, millions of women are coming together to fight long-held prejudices. They are reaching out to the disabled, people with HIV, and other women who just need a little help.