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
Working from home may look like fun, people often feel it would involve a lot of free time and leisure, sure it saves a lot of time from traveling but that’s won’t be the case if you don’t manage your time well, and don’t set specific working guidelines. Chances are you might end up working(…)
Certify ‘Lipstick Under My Burkha’ Adult says film tribunal. It claims the film explores women’s sexuality and hence the proposal to give it an adult certification. The film – which is a runaway hit on the global film festival circuit – made headlines after the censor board refused it certification, and banned it from being(…)
If you think co-parenting after a split rarely happens, log on to Facebook and checkout this heartwarming picture of Maelyn and her four parents, which endorses mutual happiness rather than resentments in a family. Looks like we went viral on twitter too ❤ love my family https://t.co/zx1aVQnkzU — Emilee Player (@emileeplayer12) April 18, 2017 How y'all feel(…)
The debate whether a tomato is a fruit or a vegetable is long-standing one, but tomatoes are definitely beneficial for health. They do much more than just provide basic nutrition to the body. So let’s check out some amazing health benefits which make it an irreplaceable part of our daily diet: 1) Combats Cancer: Tomatoes(…)
Australian model and Miss World finalist, Adau Mornyang went live on Facebook to reveal how she had been raped when she was a teenager. The hour long video has since gone viral. She says that she is protecting other girls by revealing the details of what happened to her. The model, who was born in(…)
Women despise Donald Trump. That’s a given. He’s called them fat, slobs, disgusting, pigs and many more names in the past. The most powerful nation in the world doesn’t need a leader that doesn’t respect women at all. This makes us lose all sense of progress that we have made in the past. It’s been(…)
Dr Varsha Jain is the world’s first ‘space gynaecologist’. She specialises in how women’s bodies react in space and has published a new paper in Microgravity which talks about options for period suppression in space.
This is turning out to be a truly memorable month for tennis star Serena Williams. Days after she announced the news of her pregnancy, the ace has jumped right back to the No. 1 spot in the Women’s Tennis Association (WTA) ranking. Williams’ Snapchat post revealed the news in which she was seen flaunting a swimsuit and taking(…)
Chetan Bhagat’s ‘One Indian Girl’, that was released only six months ago and became his bestselling novel for 2016, has been facing plagiarism charges by Bengaluru-based author and research professional Anvita Bajpai.
Solo in Spain is our series for travel this summer. Women travelling across the region and exploring the sights and sounds. Here’s a breathtaking stopover. Gran Canaria is a captivating place, a little Garden of Eden in the middle of the Atlantic Ocean, which woos its visitors. In this decalogue we will give you all(…)