Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '262' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 41Notice: Trying to get property 'num_rows' of non-object in /var/www/opencart/sites/countryrustics.co.uk/catalog/model/catalog/product.php on line 10Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '64' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 41Notice: Trying to get property 'num_rows' of non-object in /var/www/opencart/sites/countryrustics.co.uk/catalog/model/catalog/product.php on line 10Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '213' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 41Notice: Trying to get property 'num_rows' of non-object in /var/www/opencart/sites/countryrustics.co.uk/catalog/model/catalog/product.php on line 10Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '267' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 41Notice: Trying to get property 'num_rows' of non-object in /var/www/opencart/sites/countryrustics.co.uk/catalog/model/catalog/product.php on line 10Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '214' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' in /var/www/opencart/sites/countryrustics.co.uk/system/library/db/mysqli.php on line 41Notice: Trying to get property 'num_rows' of non-object in /var/www/opencart/sites/countryrustics.co.uk/catalog/model/catalog/product.php on line 10 Country Rustics

Country Rustics

Product Compare (0)


..

£0.00 Ex Tax: £0.00

..

£0.00 Ex Tax: £0.00

..

£0.00 Ex Tax: £0.00

..

£0.00 Ex Tax: £0.00

..

£0.00 Ex Tax: £0.00

GARDEN TABLE (4ft) 120cm long x 60cm wide (COLLECTION)

GARDEN TABLE (4ft) 120cm long x 60cm wide (COLLECTION)

Low height GARDEN TABLE (4ft) 120cm long x 60cm wide Made from fully pressure treated ti..

£140.00 Ex Tax: £116.67

GARDEN TABLE (4ft) 120cm long x 80cm wide (COLLECTION)

GARDEN TABLE (4ft) 120cm long x 80cm wide (COLLECTION)

Low height GARDEN TABLE (4ft) 120cm long x 80cm wide Made from fully pressure treated ti..

£160.00 Ex Tax: £133.33

GARDEN TABLE (5ft) 150cm long x 60cm wide (COLLECTION)

GARDEN TABLE (5ft) 150cm long x 60cm wide (COLLECTION)

 GARDEN TABLE ( 5ft)   150CM long and 60cm wide Made from fully pressure tre..

£165.00 Ex Tax: £137.50

GARDEN TABLE (5ft) 150cm long x 80cm wide (COLLECTION)

GARDEN TABLE (5ft) 150cm long x 80cm wide (COLLECTION)

 GARDEN TABLE ( 5ft)   150CM long and 80cm wide Made from fully pressure tre..

£190.00 Ex Tax: £158.33

GARDEN TABLE (6ft ) 180cm long x 60cm wide (COLLECTION)

GARDEN TABLE (6ft ) 180cm long x 60cm wide (COLLECTION)

Low height GARDEN TABLE 6ft long x 2ft 8ins wide Made from fully pressure treated timber..

£186.00 Ex Tax: £155.00

GARDEN TABLE (6ft ) 180cm long x 80cm wide (COLLECTION)

GARDEN TABLE (6ft ) 180cm long x 80cm wide (COLLECTION)

Low height GARDEN TABLE ( 6fT) 180cm long x 80cm wide Made from fully pressure treated t..

£210.00 Ex Tax: £175.00

GARDEN TABLE - RECTANGULAR  PATIO   60cm X 90cm  low height (COLLECTION)

GARDEN TABLE - RECTANGULAR PATIO 60cm X 90cm low height (COLLECTION)

RECTANGULAR PATIO TABLE - LOW HEIGHT - 60CM X 90CM Made from fully pressure treated timber,..

£100.00 Ex Tax: £83.33

GARDEN TABLE - SQUARE PATIO   80cm X 80cm (COLLECTION)

GARDEN TABLE - SQUARE PATIO 80cm X 80cm (COLLECTION)

SQUARE PATIO TABLE  80cm x 80cm wide Made from fully pressure treated timber, plained ..

£137.00 Ex Tax: £114.17

Hanging Bird Peanut Feeder *Delivered P&P free if purchased with any bird table*

Hanging Bird Peanut Feeder *Delivered P&P free if purchased with any bird table*

Hanging Bird Peanut Feeder A Bird feeder designed to be hung of tree branches. Comes with a s..

£2.50 Ex Tax: £2.08

Hedgehog Hub COLLECTION

Hedgehog Hub COLLECTION

Hedgehog House A  lovely item, for the friends of your garden. Made from slow grown timber a..

£45.00 Ex Tax: £37.50

Showing 1 to 15 of 98 (7 Pages)