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
First we are officers, then women says Wing Commander Pooja Thakur who led the Guard of Honour today for President Barack Obama at Rashtrapati Bhawan. She became the first female officer of the Air Force who led the Guard of Honour. Thakur’s moment of pride came as ‘nari shakti’ (woman power) is the theme for(…)
As the awareness for the rising need of women participation in business increases, there has been a visible increase in women participation around the world. According to a report by International Labour Organization, women in business and management are gaining momentum. The report states that female bosses are more common in before in different countries(…)
In a land that is still a kingdom, that is as skeptical about films as it about letting their women watch films, let alone make them, Haifaa al-Mansour attempted a fatal feat, for the love of art and freedom. Saudi’s first ever woman film-maker, director of award-winning “Wadjda,” a story about a school-girl who just wants to ride a bike.