Dartmoor Pattern

Filigree

£94.00 per sq. metre

Dartmoor Pattern

Filigree

Autumn Glow

148-07101

Dartmoor Pattern

Filigree

Autumn Glow

148-07101

£94.00 per sq. metre

Where to Buy

Keep it Real


Filigree is a subtle botanical pattern which dances delicately across the beautiful berber of the ground shade. This is a truly delightful carpet that will add a touch of understated sophistication to any room.

  • Features:
  • Heavy Domestic Use
  • Woven Axminster

We Have More For You

Related Range Items


Price Examples

All prices are estimates, and are exclusive of underlay & fitting. This estimate does not allow for carpet width or pattern repeat requirements.
Small Room

Small Room

4m x 3m

£1128

Medium Room

Medium Room

5m x 4m

£1880

Large Room

Large Room

6m x 4m

£2256

Stairs

Stairs

17m2

£1598

Specifications

100% Pure New Wool

  • Construction: Woven Axminster
  • Suitability:
  • Heavy Domestic Use
  • Widths:
  • 4.57m (15')
  • 3.66m (12')
  • 0.91m (3')
  • Pattern Repeat: 91x91cm
  • Tog Rating: 1.25
SELECT	(`product`.`id`) AS `id`,
	(`product`.`name`) AS `name`,
	(`product`.`category`) AS `category`,
	(`product`.`title`) AS `title`,
	(`product`.`summary`) AS `summary`,
	(`product`.`product_price`) AS `product_price`,
	(`product`.`content`) AS `content`,
	(`product`.`tax_rate_id`) AS `tax_rate_id`,
	(`product`.`style_id`) AS `style_id`,
	(`product`.`new`) AS `new`,
	(`product`.`color_id`) AS `color_id`,
	(`product`.`extra_heavy_domestic`) AS `extra_heavy_domestic`,
	(`product`.`heavy_domestic`) AS `heavy_domestic`,
	(`product`.`commercial`) AS `commercial`,
	(`product`.`lounge`) AS `lounge`,
	(`product`.`dining`) AS `dining`,
	(`product`.`stairs`) AS `stairs`,
	(`product`.`bedroom`) AS `bedroom`,
	(`product`.`exclusivity`) AS `exclusivity`,
	(`product`.`construction`) AS `construction`,
	(`product`.`tog`) AS `tog`,
	(`product`.`pile_content`) AS `pile_content`,
	(`product`.`pattern_repeat`) AS `pattern_repeat`,
	(`product`.`width`) AS `width`,
	(`product`.`meta_title`) AS `meta_title`,
	(`product`.`meta_description`) AS `meta_description`,
	(`product`.`star`) AS `star`,
	(`product`.`publish`) AS `publish`,
	(`product`.`discard`) AS `discard`,
	(`product`.`updated`) AS `updated`,
	(
	SELECT	`image`
	FROM `product_image`
	WHERE `product_image`.`discard` IS FALSE
	AND `product_image`.`publish` IS TRUE
	AND `product_image`.`product_id` = `product`.`id`
	ORDER BY `product_image`.`ordinal` ASC
	LIMIT 1) AS `image`,
	(
	SELECT	MIN(price)
	FROM `variant`
	WHERE `variant`.`discard` IS FALSE
	AND `variant`.`publish` IS TRUE
	AND `variant`.`product_id` = `product`.`id`) AS `price`
FROM `product`
WHERE `product`.`id` = '53'
AND `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
Command completed in 0.0017001628875732 seconds - 1 row(s) affected.
SELECT	(`variant`.`id`) AS `id`,
	(`variant`.`product_id`) AS `product_id`,
	(`variant`.`name`) AS `name`,
	(`variant`.`ordinal`) AS `ordinal`,
	(`variant`.`sku`) AS `sku`,
	(`variant`.`image`) AS `image`,
	(`variant`.`color_id`) AS `color_id`,
	(`variant`.`price`) AS `price`,
	(`variant`.`publish`) AS `publish`,
	(`variant`.`discard`) AS `discard`,
	(`variant`.`updated`) AS `updated`,
	(`product`.`tax_rate_id`) AS `tax_rate_id`
FROM `variant`
INNER JOIN `product` ON `product`.`id` = `variant`.`product_id`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` IN ('53')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.001244068145752 seconds - 1 row(s) affected.
SELECT	(`category_product`.`category_id`) AS `category_id`,
	(`category_product`.`product_id`) AS `product_id`,
	(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`product_id` IN ('53')
Command completed in 0.00090289115905762 seconds - 1 row(s) affected.
SELECT	(`category`.`id`) AS `id`,
	(`category`.`parent`) AS `parent`,
	(`category`.`ordinal`) AS `ordinal`,
	(`category`.`name`) AS `name`,
	(`category`.`title`) AS `title`,
	(`category`.`summary`) AS `summary`,
	(`category`.`content`) AS `content`,
	(`category`.`image`) AS `image`,
	(`category`.`meta_title`) AS `meta_title`,
	(`category`.`meta_description`) AS `meta_description`,
	(`category`.`publish`) AS `publish`,
	(`category`.`discard`) AS `discard`,
	(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('3')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.0007941722869873 seconds - 1 row(s) affected.
SELECT	(`product_image`.`id`) AS `id`,
	(`product_image`.`product_id`) AS `product_id`,
	(`product_image`.`ordinal`) AS `ordinal`,
	(`product_image`.`name`) AS `name`,
	(`product_image`.`title`) AS `title`,
	(`product_image`.`image`) AS `image`,
	(`product_image`.`publish`) AS `publish`,
	(`product_image`.`discard`) AS `discard`,
	(`product_image`.`updated`) AS `updated`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` IN ('53')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00088596343994141 seconds - 0 row(s) affected.
SELECT	(`variant`.`id`) AS `id`,
	(`variant`.`product_id`) AS `product_id`,
	(`variant`.`name`) AS `name`,
	(`variant`.`ordinal`) AS `ordinal`,
	(`variant`.`sku`) AS `sku`,
	(`variant`.`image`) AS `image`,
	(`variant`.`color_id`) AS `color_id`,
	(`variant`.`price`) AS `price`,
	(`variant`.`publish`) AS `publish`,
	(`variant`.`discard`) AS `discard`,
	(`variant`.`updated`) AS `updated`,
	(`product`.`tax_rate_id`) AS `tax_rate_id`
FROM `variant`
INNER JOIN `product` ON `product`.`id` = `variant`.`product_id`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` IN ('53')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00079512596130371 seconds - 1 row(s) affected.
SELECT	(`category_product`.`category_id`) AS `category_id`,
	(`category_product`.`product_id`) AS `product_id`,
	(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`product_id` IN ('53')
Command completed in 0.00062084197998047 seconds - 1 row(s) affected.
SELECT	(`category`.`id`) AS `id`,
	(`category`.`parent`) AS `parent`,
	(`category`.`ordinal`) AS `ordinal`,
	(`category`.`name`) AS `name`,
	(`category`.`title`) AS `title`,
	(`category`.`summary`) AS `summary`,
	(`category`.`content`) AS `content`,
	(`category`.`image`) AS `image`,
	(`category`.`meta_title`) AS `meta_title`,
	(`category`.`meta_description`) AS `meta_description`,
	(`category`.`publish`) AS `publish`,
	(`category`.`discard`) AS `discard`,
	(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('3')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.000762939453125 seconds - 1 row(s) affected.
SELECT	(`product_image`.`id`) AS `id`,
	(`product_image`.`product_id`) AS `product_id`,
	(`product_image`.`ordinal`) AS `ordinal`,
	(`product_image`.`name`) AS `name`,
	(`product_image`.`title`) AS `title`,
	(`product_image`.`image`) AS `image`,
	(`product_image`.`publish`) AS `publish`,
	(`product_image`.`discard`) AS `discard`,
	(`product_image`.`updated`) AS `updated`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` IN ('53')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00075984001159668 seconds - 0 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`publish` IS TRUE
AND `color`.`id` IN ('21')
ORDER BY `color`.`name` ASC, `color`.`id` ASC
Command completed in 0.00061392784118652 seconds - 1 row(s) affected.
SELECT	(`category`.`id`) AS `id`,
	(`category`.`parent`) AS `parent`,
	(`category`.`ordinal`) AS `ordinal`,
	(`category`.`name`) AS `name`,
	(`category`.`title`) AS `title`,
	(`category`.`summary`) AS `summary`,
	(`category`.`content`) AS `content`,
	(`category`.`image`) AS `image`,
	(`category`.`meta_title`) AS `meta_title`,
	(`category`.`meta_description`) AS `meta_description`,
	(`category`.`publish`) AS `publish`,
	(`category`.`discard`) AS `discard`,
	(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('3')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00076699256896973 seconds - 1 row(s) affected.
SELECT	(`category_product`.`category_id`) AS `category_id`,
	(`category_product`.`product_id`) AS `product_id`,
	(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`category_id` IN ('3')
Command completed in 0.00069093704223633 seconds - 16 row(s) affected.
SELECT	(`product`.`id`) AS `id`,
	(`product`.`name`) AS `name`,
	(`product`.`category`) AS `category`,
	(`product`.`title`) AS `title`,
	(`product`.`summary`) AS `summary`,
	(`product`.`product_price`) AS `product_price`,
	(`product`.`content`) AS `content`,
	(`product`.`tax_rate_id`) AS `tax_rate_id`,
	(`product`.`style_id`) AS `style_id`,
	(`product`.`new`) AS `new`,
	(`product`.`color_id`) AS `color_id`,
	(`product`.`extra_heavy_domestic`) AS `extra_heavy_domestic`,
	(`product`.`heavy_domestic`) AS `heavy_domestic`,
	(`product`.`commercial`) AS `commercial`,
	(`product`.`lounge`) AS `lounge`,
	(`product`.`dining`) AS `dining`,
	(`product`.`stairs`) AS `stairs`,
	(`product`.`bedroom`) AS `bedroom`,
	(`product`.`exclusivity`) AS `exclusivity`,
	(`product`.`construction`) AS `construction`,
	(`product`.`tog`) AS `tog`,
	(`product`.`pile_content`) AS `pile_content`,
	(`product`.`pattern_repeat`) AS `pattern_repeat`,
	(`product`.`width`) AS `width`,
	(`product`.`meta_title`) AS `meta_title`,
	(`product`.`meta_description`) AS `meta_description`,
	(`product`.`star`) AS `star`,
	(`product`.`publish`) AS `publish`,
	(`product`.`discard`) AS `discard`,
	(`product`.`updated`) AS `updated`,
	(
	SELECT	`image`
	FROM `product_image`
	WHERE `product_image`.`discard` IS FALSE
	AND `product_image`.`publish` IS TRUE
	AND `product_image`.`product_id` = `product`.`id`
	ORDER BY `product_image`.`ordinal` ASC
	LIMIT 1) AS `image`,
	(
	SELECT	MIN(price)
	FROM `variant`
	WHERE `variant`.`discard` IS FALSE
	AND `variant`.`publish` IS TRUE
	AND `variant`.`product_id` = `product`.`id`) AS `price`
FROM `product`
WHERE `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
AND `product`.`id` IN ('45', '47', '49', '51', '53', '55', '57', '59', '61', '63', '65', '67', '69', '71', '73', '75')
ORDER BY `product`.`name` ASC
Command completed in 0.001154899597168 seconds - 16 row(s) affected.
SELECT	(`variant`.`id`) AS `id`,
	(`variant`.`product_id`) AS `product_id`,
	(`variant`.`name`) AS `name`,
	(`variant`.`ordinal`) AS `ordinal`,
	(`variant`.`sku`) AS `sku`,
	(`variant`.`image`) AS `image`,
	(`variant`.`color_id`) AS `color_id`,
	(`variant`.`price`) AS `price`,
	(`variant`.`publish`) AS `publish`,
	(`variant`.`discard`) AS `discard`,
	(`variant`.`updated`) AS `updated`,
	(`product`.`tax_rate_id`) AS `tax_rate_id`
FROM `variant`
INNER JOIN `product` ON `product`.`id` = `variant`.`product_id`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` IN ('55', '67', '49', '57', '63', '71', '47', '51', '59', '61', '65', '73', '75', '53', '69', '45')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.000885009765625 seconds - 16 row(s) affected.
SELECT	(`category_product`.`category_id`) AS `category_id`,
	(`category_product`.`product_id`) AS `product_id`,
	(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`product_id` IN ('55', '67', '49', '57', '63', '71', '47', '51', '59', '61', '65', '73', '75', '53', '69', '45')
Command completed in 0.00064992904663086 seconds - 16 row(s) affected.
SELECT	(`category`.`id`) AS `id`,
	(`category`.`parent`) AS `parent`,
	(`category`.`ordinal`) AS `ordinal`,
	(`category`.`name`) AS `name`,
	(`category`.`title`) AS `title`,
	(`category`.`summary`) AS `summary`,
	(`category`.`content`) AS `content`,
	(`category`.`image`) AS `image`,
	(`category`.`meta_title`) AS `meta_title`,
	(`category`.`meta_description`) AS `meta_description`,
	(`category`.`publish`) AS `publish`,
	(`category`.`discard`) AS `discard`,
	(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00077104568481445 seconds - 1 row(s) affected.
SELECT	(`product_image`.`id`) AS `id`,
	(`product_image`.`product_id`) AS `product_id`,
	(`product_image`.`ordinal`) AS `ordinal`,
	(`product_image`.`name`) AS `name`,
	(`product_image`.`title`) AS `title`,
	(`product_image`.`image`) AS `image`,
	(`product_image`.`publish`) AS `publish`,
	(`product_image`.`discard`) AS `discard`,
	(`product_image`.`updated`) AS `updated`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` IN ('55', '67', '49', '57', '63', '71', '47', '51', '59', '61', '65', '73', '75', '53', '69', '45')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00071310997009277 seconds - 0 row(s) affected.
SELECT	(`page`.`id`) AS `id`,
	(`page`.`parent`) AS `parent`,
	(`page`.`ordinal`) AS `ordinal`,
	(`page`.`name`) AS `name`,
	(`page`.`title`) AS `title`,
	(`page`.`subtitle`) AS `subtitle`,
	(`page`.`alternate_layout`) AS `alternate_layout`,
	(`page`.`summary`) AS `summary`,
	(`page`.`content`) AS `content`,
	(`page`.`second_content`) AS `second_content`,
	(`page`.`image`) AS `image`,
	(`page`.`meta_title`) AS `meta_title`,
	(`page`.`meta_description`) AS `meta_description`,
	(`page`.`static`) AS `static`,
	(`page`.`publish`) AS `publish`,
	(`page`.`discard`) AS `discard`,
	(`page`.`updated`) AS `updated`
FROM `page`
WHERE `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
ORDER BY `page`.`parent` ASC, `page`.`ordinal` ASC, `page`.`name` ASC, `page`.`id` ASC
Command completed in 0.0016880035400391 seconds - 46 row(s) affected.
SELECT	(`label`.`id`) AS `id`,
	(`label`.`name`) AS `name`,
	(`label`.`path`) AS `path`,
	(`label`.`source`) AS `source`,
	(`label`.`content`) AS `content`,
	(`label`.`block`) AS `block`,
	(`label`.`discard`) AS `discard`
FROM `label`
WHERE `label`.`discard` IS FALSE
AND (`label`.`path` = ''
	OR '/carpets/53-Filigree' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.0032632350921631 seconds - 304 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '23'
Command completed in 0.00061297416687012 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '29'
Command completed in 0.00057601928710938 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '21'
Command completed in 0.00061798095703125 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '25'
Command completed in 0.00059604644775391 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '29'
Command completed in 0.00062108039855957 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '17'
Command completed in 0.00050687789916992 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '19'
Command completed in 0.00045204162597656 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '21'
Command completed in 0.00063300132751465 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '25'
Command completed in 0.00055885314941406 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '27'
Command completed in 0.00051593780517578 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '29'
Command completed in 0.00061202049255371 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '17'
Command completed in 0.00052690505981445 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '33'
Command completed in 0.00059318542480469 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '21'
Command completed in 0.00051617622375488 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '29'
Command completed in 0.00051712989807129 seconds - 1 row(s) affected.
SELECT	(`color`.`id`) AS `id`,
	(`color`.`name`) AS `name`,
	(`color`.`color`) AS `color`,
	(`color`.`publish`) AS `publish`
FROM `color`
WHERE `color`.`id` = '17'
Command completed in 0.00059294700622559 seconds - 1 row(s) affected.
SELECT	(`color_group`.`id`) AS `id`,
	(`color_group`.`name`) AS `name`,
	(`color_group`.`ordinal`) AS `ordinal`,
	(`color_group`.`color`) AS `color`,
	(`color_group`.`content`) AS `content`,
	(`color_group`.`image`) AS `image`
FROM `color_group`
ORDER BY `color_group`.`ordinal` ASC, `color_group`.`name` ASC, `color_group`.`id` ASC
Command completed in 0.00073695182800293 seconds - 12 row(s) affected.
SELECT	(`style`.`id`) AS `id`,
	(`style`.`name`) AS `name`,
	(`style`.`publish`) AS `publish`
FROM `style`
WHERE `style`.`publish` IS TRUE
ORDER BY `style`.`name` ASC, `style`.`id` ASC
Command completed in 0.00056791305541992 seconds - 8 row(s) affected.
SELECT	(`product`.`id`) AS `id`,
	(`product`.`name`) AS `name`,
	(`product`.`category`) AS `category`,
	(`product`.`title`) AS `title`,
	(`product`.`summary`) AS `summary`,
	(`product`.`product_price`) AS `product_price`,
	(`product`.`content`) AS `content`,
	(`product`.`tax_rate_id`) AS `tax_rate_id`,
	(`product`.`style_id`) AS `style_id`,
	(`product`.`new`) AS `new`,
	(`product`.`color_id`) AS `color_id`,
	(`product`.`extra_heavy_domestic`) AS `extra_heavy_domestic`,
	(`product`.`heavy_domestic`) AS `heavy_domestic`,
	(`product`.`commercial`) AS `commercial`,
	(`product`.`lounge`) AS `lounge`,
	(`product`.`dining`) AS `dining`,
	(`product`.`stairs`) AS `stairs`,
	(`product`.`bedroom`) AS `bedroom`,
	(`product`.`exclusivity`) AS `exclusivity`,
	(`product`.`construction`) AS `construction`,
	(`product`.`tog`) AS `tog`,
	(`product`.`pile_content`) AS `pile_content`,
	(`product`.`pattern_repeat`) AS `pattern_repeat`,
	(`product`.`width`) AS `width`,
	(`product`.`meta_title`) AS `meta_title`,
	(`product`.`meta_description`) AS `meta_description`,
	(`product`.`star`) AS `star`,
	(`product`.`publish`) AS `publish`,
	(`product`.`discard`) AS `discard`,
	(`product`.`updated`) AS `updated`,
	(
	SELECT	`image`
	FROM `product_image`
	WHERE `product_image`.`discard` IS FALSE
	AND `product_image`.`publish` IS TRUE
	AND `product_image`.`product_id` = `product`.`id`
	ORDER BY `product_image`.`ordinal` ASC
	LIMIT 1) AS `image`,
	(
	SELECT	MIN(price)
	FROM `variant`
	WHERE `variant`.`discard` IS FALSE
	AND `variant`.`publish` IS TRUE
	AND `variant`.`product_id` = `product`.`id`) AS `price`
FROM `product`
WHERE `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
AND `product`.`style_id` IN ('7', '1', '13', '3', '9', '11', '5', '15')
ORDER BY `product`.`name` ASC
Command completed in 0.0017709732055664 seconds - 263 row(s) affected.
SELECT	(`variant`.`id`) AS `id`,
	(`variant`.`product_id`) AS `product_id`,
	(`variant`.`name`) AS `name`,
	(`variant`.`ordinal`) AS `ordinal`,
	(`variant`.`sku`) AS `sku`,
	(`variant`.`image`) AS `image`,
	(`variant`.`color_id`) AS `color_id`,
	(`variant`.`price`) AS `price`,
	(`variant`.`publish`) AS `publish`,
	(`variant`.`discard`) AS `discard`,
	(`variant`.`updated`) AS `updated`,
	(`product`.`tax_rate_id`) AS `tax_rate_id`
FROM `variant`
INNER JOIN `product` ON `product`.`id` = `variant`.`product_id`
WHERE `variant`.`discard` IS FALSE
AND `variant`.`publish` IS TRUE
AND `variant`.`product_id` IN ('55', '67', '351', '353', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '601', '603', '605', '607', '545', '547', '549', '551', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '119', '121', '123', '125', '131', '137', '141', '153', '261', '263', '267', '273', '279', '301', '303', '307', '247', '259', '265', '269', '271', '275', '277', '283', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '497', '5', '7', '609', '611', '333', '329', '331', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '655', '479', '25', '373', '375', '9', '11', '381', '439', '441', '443', '445', '447', '449', '451', '453', '455', '457', '459', '461', '463', '465', '467', '469', '471', '473', '475', '477', '593', '595', '597', '599', '383', '553', '555', '557', '559', '385', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '719', '721', '159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '211', '723', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '499', '531', '533', '535', '401', '569', '661', '663', '69', '407', '513', '507', '405', '409', '19', '615', '617', '619', '621', '625', '627', '631', '633', '635', '639', '641', '643', '647', '413', '29', '33', '567', '23', '13', '17', '45', '417', '419', '421', '423', '425', '427', '491', '429', '561', '563', '565', '577', '579', '581', '583', '493', '483', '657', '671', '435', '437', '537', '539', '541', '543', '495', '485', '501')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0012691020965576 seconds - 263 row(s) affected.
SELECT	(`category_product`.`category_id`) AS `category_id`,
	(`category_product`.`product_id`) AS `product_id`,
	(`category_product`.`ordinal`) AS `ordinal`
FROM `category_product`
WHERE `category_product`.`product_id` IN ('55', '67', '351', '353', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '601', '603', '605', '607', '545', '547', '549', '551', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '119', '121', '123', '125', '131', '137', '141', '153', '261', '263', '267', '273', '279', '301', '303', '307', '247', '259', '265', '269', '271', '275', '277', '283', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '497', '5', '7', '609', '611', '333', '329', '331', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '655', '479', '25', '373', '375', '9', '11', '381', '439', '441', '443', '445', '447', '449', '451', '453', '455', '457', '459', '461', '463', '465', '467', '469', '471', '473', '475', '477', '593', '595', '597', '599', '383', '553', '555', '557', '559', '385', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '719', '721', '159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '211', '723', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '499', '531', '533', '535', '401', '569', '661', '663', '69', '407', '513', '507', '405', '409', '19', '615', '617', '619', '621', '625', '627', '631', '633', '635', '639', '641', '643', '647', '413', '29', '33', '567', '23', '13', '17', '45', '417', '419', '421', '423', '425', '427', '491', '429', '561', '563', '565', '577', '579', '581', '583', '493', '483', '657', '671', '435', '437', '537', '539', '541', '543', '495', '485', '501')
Command completed in 0.0010337829589844 seconds - 263 row(s) affected.
SELECT	(`category`.`id`) AS `id`,
	(`category`.`parent`) AS `parent`,
	(`category`.`ordinal`) AS `ordinal`,
	(`category`.`name`) AS `name`,
	(`category`.`title`) AS `title`,
	(`category`.`summary`) AS `summary`,
	(`category`.`content`) AS `content`,
	(`category`.`image`) AS `image`,
	(`category`.`meta_title`) AS `meta_title`,
	(`category`.`meta_description`) AS `meta_description`,
	(`category`.`publish`) AS `publish`,
	(`category`.`discard`) AS `discard`,
	(`category`.`updated`) AS `updated`
FROM `category`
WHERE `category`.`discard` IS FALSE
AND `category`.`publish` IS TRUE
AND `category`.`id` IN ('1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '3', '7', '7', '7', '7', '7', '7', '7', '7', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '9', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '11', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '13', '15', '15', '15', '15', '15', '15', '15', '15', '15', '17', '17', '17', '19', '19', '19', '19', '19', '19', '19', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '21', '23', '23', '23', '23', '23', '23', '23', '23', '23', '23', '25', '25', '25', '25', '25', '25', '25', '25', '25', '25', '27', '27', '27', '27', '27', '27', '27', '27', '27', '27', '27', '27', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '29', '31', '33', '33', '33', '35', '35', '35', '35', '35', '35', '35', '35', '35', '35', '35', '35', '37', '37', '37', '39', '39', '41', '41', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '43', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '45', '47', '47', '49', '49', '49', '49', '49', '49')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.0011200904846191 seconds - 24 row(s) affected.
SELECT	(`product_image`.`id`) AS `id`,
	(`product_image`.`product_id`) AS `product_id`,
	(`product_image`.`ordinal`) AS `ordinal`,
	(`product_image`.`name`) AS `name`,
	(`product_image`.`title`) AS `title`,
	(`product_image`.`image`) AS `image`,
	(`product_image`.`publish`) AS `publish`,
	(`product_image`.`discard`) AS `discard`,
	(`product_image`.`updated`) AS `updated`
FROM `product_image`
WHERE `product_image`.`discard` IS FALSE
AND `product_image`.`publish` IS TRUE
AND `product_image`.`product_id` IN ('55', '67', '351', '353', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '601', '603', '605', '607', '545', '547', '549', '551', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '119', '121', '123', '125', '131', '137', '141', '153', '261', '263', '267', '273', '279', '301', '303', '307', '247', '259', '265', '269', '271', '275', '277', '283', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '497', '5', '7', '609', '611', '333', '329', '331', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '655', '479', '25', '373', '375', '9', '11', '381', '439', '441', '443', '445', '447', '449', '451', '453', '455', '457', '459', '461', '463', '465', '467', '469', '471', '473', '475', '477', '593', '595', '597', '599', '383', '553', '555', '557', '559', '385', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '719', '721', '159', '161', '163', '165', '167', '171', '177', '179', '181', '183', '185', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '211', '723', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '499', '531', '533', '535', '401', '569', '661', '663', '69', '407', '513', '507', '405', '409', '19', '615', '617', '619', '621', '625', '627', '631', '633', '635', '639', '641', '643', '647', '413', '29', '33', '567', '23', '13', '17', '45', '417', '419', '421', '423', '425', '427', '491', '429', '561', '563', '565', '577', '579', '581', '583', '493', '483', '657', '671', '435', '437', '537', '539', '541', '543', '495', '485', '501')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.0010509490966797 seconds - 0 row(s) affected.
SELECT	(`page`.`id`) AS `id`,
	(`page`.`parent`) AS `parent`,
	(`page`.`ordinal`) AS `ordinal`,
	(`page`.`name`) AS `name`,
	(`page`.`title`) AS `title`,
	(`page`.`subtitle`) AS `subtitle`,
	(`page`.`alternate_layout`) AS `alternate_layout`,
	(`page`.`summary`) AS `summary`,
	(`page`.`content`) AS `content`,
	(`page`.`second_content`) AS `second_content`,
	(`page`.`image`) AS `image`,
	(`page`.`meta_title`) AS `meta_title`,
	(`page`.`meta_description`) AS `meta_description`,
	(`page`.`static`) AS `static`,
	(`page`.`publish`) AS `publish`,
	(`page`.`discard`) AS `discard`,
	(`page`.`updated`) AS `updated`
FROM `page`
WHERE `page`.`id` = '27'
AND `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
Command completed in 0.0007469654083252 seconds - 1 row(s) affected.
SELECT	(`page_image`.`id`) AS `id`,
	(`page_image`.`page_id`) AS `page_id`,
	(`page_image`.`ordinal`) AS `ordinal`,
	(`page_image`.`name`) AS `name`,
	(`page_image`.`title`) AS `title`,
	(`page_image`.`summary`) AS `summary`,
	(`page_image`.`url`) AS `url`,
	(`page_image`.`label`) AS `label`,
	(`page_image`.`image`) AS `image`,
	(`page_image`.`publish`) AS `publish`,
	(`page_image`.`discard`) AS `discard`,
	(`page_image`.`updated`) AS `updated`
FROM `page_image`
WHERE `page_image`.`discard` IS FALSE
AND `page_image`.`publish` IS TRUE
AND `page_image`.`page_id` IN ('27')
ORDER BY `page_image`.`ordinal` ASC, `page_image`.`name` ASC, `page_image`.`id` ASC
Command completed in 0.00070691108703613 seconds - 4 row(s) affected.
SELECT	(`order`.`id`) AS `id`,
	(`order`.`session_id`) AS `session_id`,
	(`order`.`user_id`) AS `user_id`,
	(`order`.`reference`) AS `reference`,
	(`order`.`email`) AS `email`,
	(`order`.`billing_address_id`) AS `billing_address_id`,
	(`order`.`delivery_address_id`) AS `delivery_address_id`,
	(`order`.`delivery_instructions`) AS `delivery_instructions`,
	(`order`.`notes`) AS `notes`,
	(`order`.`analytics_id`) AS `analytics_id`,
	(`order`.`subscribe`) AS `subscribe`,
	(`order`.`abandon`) AS `abandon`,
	(`order`.`confirm`) AS `confirm`,
	(`order`.`confirmed`) AS `confirmed`,
	(`order`.`complete`) AS `complete`,
	(`order`.`completed`) AS `completed`,
	(`order`.`discard`) AS `discard`,
	(`order`.`created`) AS `created`,
	(`order`.`updated`) AS `updated`,
	(`order`.`contactAgreed`) AS `contactAgreed`,
	(`order`.`designer`) AS `designer`
FROM `order`
WHERE `order`.`discard` IS FALSE
AND `order`.`confirm` IS FALSE
AND `order`.`id` IS NULL
ORDER BY `order`.`created` DESC
LIMIT 1
Command completed in 0.00079894065856934 seconds - 0 row(s) affected.
SELECT	(`page`.`id`) AS `id`,
	(`page`.`parent`) AS `parent`,
	(`page`.`ordinal`) AS `ordinal`,
	(`page`.`name`) AS `name`,
	(`page`.`title`) AS `title`,
	(`page`.`subtitle`) AS `subtitle`,
	(`page`.`alternate_layout`) AS `alternate_layout`,
	(`page`.`summary`) AS `summary`,
	(`page`.`content`) AS `content`,
	(`page`.`second_content`) AS `second_content`,
	(`page`.`image`) AS `image`,
	(`page`.`meta_title`) AS `meta_title`,
	(`page`.`meta_description`) AS `meta_description`,
	(`page`.`static`) AS `static`,
	(`page`.`publish`) AS `publish`,
	(`page`.`discard`) AS `discard`,
	(`page`.`updated`) AS `updated`
FROM `page`
WHERE `page`.`id` = 23
AND `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
Command completed in 0.00083208084106445 seconds - 1 row(s) affected.
SELECT	(`article`.`id`) AS `id`,
	(`article`.`name`) AS `name`,
	(`article`.`title`) AS `title`,
	(`article`.`summary`) AS `summary`,
	(`article`.`author`) AS `author`,
	(`article`.`content`) AS `content`,
	(`article`.`second_content`) AS `second_content`,
	(`article`.`image`) AS `image`,
	(`article`.`meta_title`) AS `meta_title`,
	(`article`.`meta_description`) AS `meta_description`,
	(`article`.`publish_date`) AS `publish_date`,
	(`article`.`publish`) AS `publish`,
	(`article`.`discard`) AS `discard`,
	(`article`.`updated`) AS `updated`,
	(`article`.`hide_date`) AS `hide_date`,
	(`article`.`static`) AS `static`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
LIMIT 6
Command completed in 0.0011091232299805 seconds - 6 row(s) affected.
SELECT	(`article`.`id`) AS `id`,
	(`article`.`name`) AS `name`,
	(`article`.`title`) AS `title`,
	(`article`.`summary`) AS `summary`,
	(`article`.`author`) AS `author`,
	(`article`.`content`) AS `content`,
	(`article`.`second_content`) AS `second_content`,
	(`article`.`image`) AS `image`,
	(`article`.`meta_title`) AS `meta_title`,
	(`article`.`meta_description`) AS `meta_description`,
	(`article`.`publish_date`) AS `publish_date`,
	(`article`.`publish`) AS `publish`,
	(`article`.`discard`) AS `discard`,
	(`article`.`updated`) AS `updated`,
	(`article`.`hide_date`) AS `hide_date`,
	(`article`.`static`) AS `static`
FROM `article`
WHERE `article`.`discard` IS FALSE
AND `article`.`publish` IS TRUE
AND `article`.`publish_date` <= CURRENT_DATE
ORDER BY `article`.`publish_date` DESC, `article`.`id` DESC
LIMIT 6
Command completed in 0.0011570453643799 seconds - 6 row(s) affected.