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
On May 24, this year, Taiwan became the first Asian country to legalise same sex marriage. The woman behind this historic move is Tsai Ing-wen, Taiwan’s first woman President who was sworn in last year. She is the chairman of Democratic Progressive Party (DPP). Tsai Ing-wen has asked the Ministry of Justice to formulate a legal framework in(…)
Pelva Naik is one of the very few women exponents of Dhrupad – a genre of Indian classical music. Born and brought up in Ahmedabad, her’s was a family with cultural proclivities that extended from classical arts and music to dance, cinema and literature. She developed an interest in performing Indian classical music from a(…)
Islam has always been at the centre of controversy when it comes to terrorism. Although it is one of the largest religions in the world and the percentage of terrorists is way less, the conversations relating the two refuse to die down. The recent terrorist attack at an Ariana Grande concert in Manchester on Monday evening has(…)
The screenshot of a sexist chat between a white man and a woman recently went viral, causing outrage on social media at the former’s attitude for assuming that he would be preferred, thanks to his gender! The conversation was about a promotion the woman got in an internship programme and he started criticizing her for it as he was not considered for it.
In a heinous incident, a group of armed criminals raped four women and murdered a man at the Khurja-Jhajhar road in Greater Noida region early on Thursday (May 25). Seven family members, who were reportedly travelling from Jewar to Bulandshahr to visit an ailing relative in the hospital, were waylaid by the criminals. One of the(…)
The Indian woman who was allegedly forced at a gunpoint to marry a Pakistani man has returned to India this morning. The Islamabad High Court had allowed her deportation a day earlier. Uzma, who was a refugee at the Indian High Commission in Islamabad, returned to India through the Wagah border according to NDTV reports. Uzma is(…)
Peanut butter, which is made from the grounded and roasted peanuts, is immensely popular these days because of its health benefits. The proteins and oil in the peanut butter help in reducing weight and diabetes. It also helps in curing Alzheimer’s disease as it contains niacin. Peanut butter is a convenient way to help boost(…)
Safety issues have forced women’s groups to raise voice against law and order in Lucknow. The protest took place on Wednesday (May 24) as women — led by members of the All India Democratic Women’s Association (AIDWA) — came forward to complain to the state government about the poor law and order.
In the hilly state of Uttarakhand, this young lady is quietly making a difference in the lives of the youth. Divya Rawat started a business of cultivating mushrooms to the stop migration of young people from the state to other metro cities in search of livelihood. Right from childhood, she had a soft corner for(…)
The Goods and Services council has announced tax rates for 1,211 items and it is not good news for those expecting an exemption on sanitary napkins. There have been various tax slabs under which the items are segregated. The recent announcement says that items like sindoor, bindi, bangles will be exempted from any tax while(…)