There are no items currently on your wishlist. Visit any product on our website and click the "Add to Wishlist" button to save for later or share your wishlist with family or friends
Area
Roses for Pots & Patios
If there is no room left in the border or you want to make a special feature or memory in your garden or outside space look no furter than our decorative roses for pots and patios. This also allows you to add colour, fragrance and pleasure to areas of your garden where it is not possible to plant into the ground like Patios and paved areas.
All roses can be grown in a container, the larger the height of the rose the bigger the pot size needs to be, the smallest growing Fragrant Roses like the Patio/Front Border range require a pot 30 x 30 cm increasing to a pot size of 50 x 50cm for the largest roses like Fragrant Standards Roses or Fragrant Climbing Roses, make sure you use a heavy ceramic or clay pot that has been treated for frost protection or a large wooden heavy pot up to half barrel size. Always use a John Innes No.3 as your compost for roses. Make sure the rose when planted into its container gets at least half day of sunshine and water regularly, during hot dry weather spells your roses in containers need watering daily, adding a large saucer underneath will also help greatly with watering issues when hot.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=199
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `temp_49d7d0a352c17986dca04dad11f943ebb37dec7b` AS `search_result` ON `e`.`entity_id` = `search_result`.`entity_id`
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'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
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` = 0
LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '73') AND (`at_name`.`store_id` = 1) ORDER BY `name` ASC, `e`.`entity_id` DESC, `e`.`entity_id` ASC
LIMIT 25 OFFSET 50
