LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))

The range of roses which we grow have been carefully trialled and selected from the best rose breeders across the world. We choose our garden rose varieties including, hybrid tea roses, fragrant floribunda roses, fragrant climbing roses, fragrant rambling roses and fragrant standard roses based on disease resistance and health, repeat blooming and of course fragrance. We do our best to take accurate pictures of our roses, and provide detailed information based on our opinions and breeder’s descriptions. Contemporary Uyghur renditions of the legend are considerably less romantic. She was the child of the ruler of the Yarkent Khanate and her name was Nur Ela Nurhan.[1] Taken away to the imperial palace in Beijing by the Qianlong Emperor, Iparhan arms herself with daggers up her sleeves, on guard against the hated advances of the emperor, until finally she was poisoned.[2] The girl she captures is dead poor and in the beginning does not object that much to the idea of a life in luxury but then is more and more scared by the madwoman. LEFT JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '73') AND `at_name_default`.`store_id` = 0Life could be tragic or blissfull depending on what the women wanted: some are completely forgotten by the emperor and really lonely and miserable others share a happy lesbian life glad he is not paying them any attention. Others cling to power because the want their child to be the next emperor. Or like the Empress and Hidligh are in love with the man but that is not necessary mutual.

Someone once said that revenge is a double-edged sword. Her drive for revenge turns Iparhan into a crazy woman, I think, who destroys everyone who cares for her, and becomes a ruthless killer. I love books set in places that I am not familiar with and with characters that are unlike others that I have read before. The setting was especially captivating to me. This book takes place in the 1700s in China, which is a time and location that I have not read much about. The author takes us into the court of the Emperor, a place that is filled with social rules and obligations. At first, Hidligh is not familiar with any of the rules she will have to follow. One of my favorite parts in the book is when Iparhan and her servants are trying to teach Hidligh how to be a proper lady.Things get really complicated when Hidligh is at court and realises she loves the emperor and made good friends and wants to do everything to keep them save but on the other hand will lose her own life if it ever comes clear she was send to the palace to spy. The result is a very thrilling tale with dangers lurking everywhere. Born in Tarim in southern Yemen, Abu al-Marahim was a descendant of the Prophet Muhammad through ‘Ali and Husayn. He studied the traditional legal and religious sciences with renowned scholars in Yemen, the Hijaz, India and Egypt, where he died in 1192 AH/1778 AD. He attracted many students in the course of his travels, including ‘Abd al-Rahman al-Jabarti and al-Murtada al-Zabidi. He is the author of more than 60 works in Arabic, including the present treatise, al-‘Arf al-‘atir fi ma’rifat al-khawatir wa-ghayriha min al-jawahir. You may also like… We pride ourselves on providing each and every one of our roses with individual care and attention in our fields and on our nursery, by individually hand pruning to the correct size and bud, dead heading regularly to encourage new flower, feeding and spraying to keep in healthy disease free conditions on the nursery so they are in perfect condition before we dispatch, providing you with all the instructions that you need to give you years of enjoyment in your garden. We welcome people to visit our nursery and field to see our selection in person. Our field grown roses are grown in the most fertile soils in the United Kingdom and produce the best quality garden roses anywhere in the world. We are able to supply our rose plants not just to the UK, but also to the EU and some other European counties. INNER JOIN `temp_7f1fab15277061fd945237ebe9e31224139f0765` AS `search_result` ON `e`.`entity_id` = `search_result`.`entity_id`

century Kashgar. Hidligh has only ever wanted safety and a full belly. On the street and living hand-to-mouth, the beautiful young woman is rapidly running out of any option but prostitution. So when she’s abducted by a Muslim noblewoman, she has little choice but to agree to the deal she’s offered: pose as a concubine to the Emperor of China and act as a spy. Writer Melissa Addey wondered how both legends could be so vastly different even when you consider the political implications of the era. She wondered if there could be a version in which both are true. The Fragrant Scent is the first English translation of the work of the great eighteenth-century scholar Sayyid Abu al-Marahim ‘Abd al-Rahman b. Mustafa b. Shaykh al-‘Aydarus. The book is a meditation on the fleeting thoughts that pass through the mind of the spiritual wayfarer, and the author’s aim is to provide guidance for those on the spiritual path. Though we design / produce all of our clay diffusers, and blend our own fragrances, the actual concept of using fragrant oils with clay diffusers dates from the Greek and Egyptian periods. The concept is more familiar in countries such as Italy, France and England. All of our clay diffusers are hand-dipped in a variety of colors, always leaving a portion of the decanter in its natural porous state. It is then through the porous clay part of our clay diffusers, that the fragrance emits, and provides a delicate fragrance wherever it is placed.The Afaq Khoja Mausoleum (mazar) located outside Kashgar was built in 1640 and, in addition to encompassing a larger complex that includes a functioning mosque and madrasa, houses the coffins of five generations of the Afak Khoja family, including what is purported to be the body of the Fragrant Concubine. In fact, the real Imperial Consort Rong died of illness on 24 May 1788 and was buried in an imperial tomb in Beijing; the legend of the Fragrant Concubine first became closely associated with the Kashgar tomb in the late 19th century, and the connection has since been officially established and endorsed through a proliferation of signs and guided tours.[citation needed] stars. "The Fragrant Concubine" is the story of Hidligh, a young woman who becomes mistress to China's emperor. The twist in the book comes when not everything is as it first seems with her. She is asked to be a spy at the Emperor's court by Iparhan, a woman bent on getting even with the Emperor. She wants to use Hidligh to get her vengeance. The author uses a combination of myth and historical fact to weave a story of the fragrant concubine. Reaching the Forbidden City and working hard to win over her eunuchs and the other concubines, she succeeds in gaining the monarch’s affections. But as her shadowy “benefactor” loses patience, Hidligh finds herself entangled in a deadly web of vengeance and assassination.