Royal Borough

Windsor

£143.00 per sq. metre

Royal Borough

Windsor

Itschner Light Grey

1220/W0623

Royal Borough

Windsor

Itschner Light Grey

1220/W0623

£143.00 per sq. metre

Where to Buy

Keep it Real


Choose from the intricate trellis work of the beautiful Covent Garden or the ornamental, elegant Windsor to create timeless style in any room.

  • Features:
  • Heavy Domestic Use
  • Woven Wilton

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

£1716

Medium Room

Medium Room

5m x 4m

£2860

Large Room

Large Room

6m x 4m

£3432

Stairs

Stairs

17m2

£2431

Specifications

100% Pure New Wool

  • Construction: Woven Wilton
  • Suitability:
  • Heavy Domestic Use
  • Widths:
  • 4m (13.1')
  • Pattern Repeat: 25x23cm
  • Tog Rating: 1.20
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` = '539'
AND `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
Command completed in 0.0026140213012695 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 ('539')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0011579990386963 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 ('539')
Command completed in 0.0010249614715576 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 ('35')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.0011508464813232 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 ('539')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00091099739074707 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 ('539')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00076103210449219 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 ('539')
Command completed in 0.00070095062255859 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 ('35')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00071907043457031 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 ('539')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00074887275695801 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 ('217')
ORDER BY `color`.`name` ASC, `color`.`id` ASC
Command completed in 0.00082993507385254 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 ('35')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00077295303344727 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 ('35')
Command completed in 0.00084614753723145 seconds - 12 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 ('537', '539', '541', '543', '545', '547', '549', '551', '553', '555', '557', '559')
ORDER BY `product`.`name` ASC
Command completed in 0.0023298263549805 seconds - 12 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 ('545', '547', '549', '551', '553', '555', '557', '559', '537', '539', '541', '543')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.0013830661773682 seconds - 12 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 ('545', '547', '549', '551', '553', '555', '557', '559', '537', '539', '541', '543')
Command completed in 0.00099897384643555 seconds - 12 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 ('35', '35', '35', '35', '35', '35', '35', '35', '35', '35', '35', '35')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.001093864440918 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 ('545', '547', '549', '551', '553', '555', '557', '559', '537', '539', '541', '543')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.0010290145874023 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.0017662048339844 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/539-windsor' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.0040090084075928 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` = '215'
Command completed in 0.00060296058654785 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` = '217'
Command completed in 0.0005488395690918 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` = '219'
Command completed in 0.00056695938110352 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` = '221'
Command completed in 0.00053000450134277 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` = '215'
Command completed in 0.00060296058654785 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` = '217'
Command completed in 0.00059413909912109 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` = '219'
Command completed in 0.00056695938110352 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` = '221'
Command completed in 0.00045490264892578 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` = '215'
Command completed in 0.00054001808166504 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` = '217'
Command completed in 0.00045299530029297 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` = '219'
Command completed in 0.00041389465332031 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` = '221'
Command completed in 0.00043797492980957 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.00065398216247559 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.00057888031005859 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.0016980171203613 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.0015490055084229 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.0010800361633301 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.0011129379272461 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.001121997833252 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.00083494186401367 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.0008389949798584 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.00069093704223633 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.00076007843017578 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.0010619163513184 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.0010809898376465 seconds - 6 row(s) affected.