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
Diamond are a girl’s best friend? We’ve heard that a thousand times, and we’ve adhered to it for generations. Gold, diamond, platinum – precious metals make us feel precious. Apparently. In this new day and age, where millennials are opting for more pragmatic options in life, like education and career (rather than marriage), is jewellery(…)
This wasn’t an ordinary Sunday morning for those who passed by the Gurgaon-Faridabad Expressway. On April 23, an all-women biker group unleashed its passion for the roads and conquered a male bastion. Riding Workshop for Women organized by Delhi Royal Enfield Riders in association with Riders Alliance Group. #xBhp https://t.co/juYkmcelRi pic.twitter.com/y8DoSmxOgt — xBhp (@xBhp) April 24,(…)
Beyonce released her album ‘Lemonade’ a year ago, and in celebration of its one-year anniversary, she is offering four US scholarships. As per a statement on her website, she has established the ‘Formation Scholar awards for the 2017-18 academic year’.
It has been only a few weeks since the release of the show, and it has been the talk of the town. Gaining popularity not only in the US, but India too, Netflix’s “13 Reasons Why” is a story about a girl who commits suicide, and how she leaves tapes revealing 13 reasons on why(…)
The wife of a Silicon Valley CEO reported long term domestic violence and abuse. Her husband, a software engineer who had emigrated to California in 2005 from India, and currently the CEO of Cuberon, got just two weeks in jail for the long term domestic violence he subjected his wife to. Read The Full Story About This Abusive(…)
Life altering events like the death of a loved one can shake a person’s self-confidence. While finding inner strength in the times of adversities can be difficult, robust support from family and friends can help people to recover and rebound. That’s what Sheryl Sandberg’s new book Option B: Facing Adversity, Building Resilience, and Finding Joy talks about.(…)
Ontario, Canada, is planning to experiment with a basic income trial. Four thousand people in three regions of the province will receive additional income till 2020, based on their current salary. Eligible recipients will be between 18 and 64 years old and will be in the low-income group.
‘Nikaah’ or the Muslim marriage has been in the midst of various controversies, courtesy several misconceptions. While polygamy and triple talaq are the aspects most talked about, there is more to it. And progressive Muslim Nazia Erum’s letter to Sadhvi Prachi published by a news daily explains just that.
There are a range of contraceptives available to women these days. One of the most effective forms of birth control are the intrauterine devices (IUDs). These are very small devices, made of plastic or copper and shaped like a ’T’ that are inserted into the uterus. The hormonal IUD is made of plastic and gives(…)
In the midst of the triple talaq debate, there is a new discourse that has been completed neglected from the public eye. It is of the rising number of educated Muslim women in both rural and urban areas in the country. The percentage of Muslim women graduates’ growth in the period of 2001-11 as found out(…)