Myth & Moor

Dilly Dally

£85.00 per sq. metre

Myth & Moor

Dilly Dally

Dilly Dally

608-21051

Myth & Moor

Dilly Dally

Dilly Dally

608-21051

£85.00 per sq. metre

Where to Buy

Keep it Real


A stylish collection of plaids and tartans. Inspired by some of our favourite walks, this collection reveals the beauty of the landscape with powdery blue skies, rich warm heathers and ground shades of granite and quartz to deliver an endlessly versatile range of carpets.

  • Features:
  • Extra Heavy Domestic Use
  • Commercial 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

£1020

Medium Room

Medium Room

5m x 4m

£1700

Large Room

Large Room

6m x 4m

£2040

Stairs

Stairs

17m2

£1445

Specifications

80% Wool 20% Nylon

  • Construction: Woven Axminster
  • Suitability:
  • Extra Heavy Domestic Use
  • Commercial Use
  • Widths:
  • 3.66m (12')
  • Pattern Repeat: 11x12cm
  • Tog Rating: 1.35
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` = '497'
AND `product`.`discard` IS FALSE
AND `product`.`publish` IS TRUE
Command completed in 0.0015029907226562 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 ('497')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00098395347595215 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 ('497')
Command completed in 0.00086092948913574 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 ('27')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00063896179199219 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 ('497')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00079703330993652 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 ('497')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00064897537231445 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 ('497')
Command completed in 0.00045895576477051 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 ('27')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00064420700073242 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 ('497')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00057411193847656 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 ('295')
ORDER BY `color`.`name` ASC, `color`.`id` ASC
Command completed in 0.00065803527832031 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 ('27')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.00067710876464844 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 ('27')
Command completed in 0.00050115585327148 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 ('479', '481', '483', '485', '487', '489', '491', '493', '495', '497', '499', '501')
ORDER BY `product`.`name` ASC
Command completed in 0.0010039806365967 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 ('487', '489', '497', '481', '479', '499', '491', '493', '483', '495', '485', '501')
ORDER BY `variant`.`ordinal` ASC, `variant`.`name` ASC, `variant`.`id` ASC
Command completed in 0.00071310997009277 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 ('487', '489', '497', '481', '479', '499', '491', '493', '483', '495', '485', '501')
Command completed in 0.00054693222045898 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 ('27', '27', '27', '27', '27', '27', '27', '27', '27', '27', '27', '27')
ORDER BY `category`.`parent` ASC, `category`.`ordinal` ASC, `category`.`name` ASC, `category`.`id` ASC
Command completed in 0.0005948543548584 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 ('487', '489', '497', '481', '479', '499', '491', '493', '483', '495', '485', '501')
ORDER BY `product_image`.`ordinal` ASC, `product_image`.`name` ASC, `product_image`.`id` ASC
Command completed in 0.00060105323791504 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.0014588832855225 seconds - 43 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/497-dilly-dally' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.0034050941467285 seconds - 293 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` = '285'
Command completed in 0.00055217742919922 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` = '287'
Command completed in 0.0005648136138916 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` = '295'
Command completed in 0.0004889965057373 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` = '279'
Command completed in 0.00049901008605957 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` = '277'
Command completed in 0.00048685073852539 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` = '297'
Command completed in 0.00048017501831055 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` = '289'
Command completed in 0.00047707557678223 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` = '291'
Command completed in 0.00034904479980469 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` = '281'
Command completed in 0.00041890144348145 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` = '293'
Command completed in 0.00050497055053711 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` = '283'
Command completed in 0.00049114227294922 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` = '299'
Command completed in 0.00048398971557617 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.00065803527832031 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.00055503845214844 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.0017361640930176 seconds - 305 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', '355', '357', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '359', '601', '603', '605', '607', '545', '547', '549', '551', '361', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '117', '119', '121', '123', '125', '131', '133', '137', '141', '145', '149', '153', '155', '261', '263', '267', '273', '279', '301', '303', '307', '247', '257', '259', '265', '269', '271', '275', '277', '281', '283', '285', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '245', '253', '255', '497', '3', '5', '7', '609', '611', '333', '329', '331', '35', '37', '365', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '653', '655', '479', '25', '27', '373', '375', '9', '11', '377', '379', '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', '387', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '399', '499', '159', '161', '163', '165', '167', '171', '173', '177', '179', '181', '183', '185', '187', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '719', '721', '211', '723', '213', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '235', '531', '533', '535', '401', '661', '663', '403', '69', '407', '513', '507', '405', '409', '19', '21', '615', '617', '619', '621', '625', '627', '631', '633', '635', '637', '639', '641', '643', '647', '411', '413', '415', '29', '31', '33', '567', '23', '13', '15', '17', '45', '585', '587', '589', '591', '417', '419', '421', '423', '425', '427', '491', '429', '431', '561', '563', '565', '577', '579', '581', '583', '493', '433', '483', '657', '345', '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.0013720989227295 seconds - 305 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', '355', '357', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '359', '601', '603', '605', '607', '545', '547', '549', '551', '361', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '117', '119', '121', '123', '125', '131', '133', '137', '141', '145', '149', '153', '155', '261', '263', '267', '273', '279', '301', '303', '307', '247', '257', '259', '265', '269', '271', '275', '277', '281', '283', '285', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '245', '253', '255', '497', '3', '5', '7', '609', '611', '333', '329', '331', '35', '37', '365', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '653', '655', '479', '25', '27', '373', '375', '9', '11', '377', '379', '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', '387', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '399', '499', '159', '161', '163', '165', '167', '171', '173', '177', '179', '181', '183', '185', '187', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '719', '721', '211', '723', '213', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '235', '531', '533', '535', '401', '661', '663', '403', '69', '407', '513', '507', '405', '409', '19', '21', '615', '617', '619', '621', '625', '627', '631', '633', '635', '637', '639', '641', '643', '647', '411', '413', '415', '29', '31', '33', '567', '23', '13', '15', '17', '45', '585', '587', '589', '591', '417', '419', '421', '423', '425', '427', '491', '429', '431', '561', '563', '565', '577', '579', '581', '583', '493', '433', '483', '657', '345', '671', '435', '437', '537', '539', '541', '543', '495', '485', '501')
Command completed in 0.001093864440918 seconds - 305 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', '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', '7', '7', '7', '7', '7', '9', '9', '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', '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', '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', '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', '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', '41', '41', '43', '43', '43', '43', '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', '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.0011119842529297 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', '355', '357', '487', '347', '349', '335', '337', '339', '489', '1', '573', '575', '359', '601', '603', '605', '607', '545', '547', '549', '551', '361', '659', '49', '57', '63', '71', '515', '519', '523', '503', '509', '665', '667', '669', '363', '117', '119', '121', '123', '125', '131', '133', '137', '141', '145', '149', '153', '155', '261', '263', '267', '273', '279', '301', '303', '307', '247', '257', '259', '265', '269', '271', '275', '277', '281', '283', '285', '287', '291', '293', '295', '297', '299', '309', '311', '315', '317', '319', '321', '325', '239', '241', '243', '245', '253', '255', '497', '3', '5', '7', '609', '611', '333', '329', '331', '35', '37', '365', '47', '51', '59', '61', '65', '73', '75', '53', '481', '367', '369', '341', '343', '371', '517', '521', '525', '505', '511', '613', '623', '629', '649', '651', '653', '655', '479', '25', '27', '373', '375', '9', '11', '377', '379', '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', '387', '389', '391', '393', '395', '397', '529', '527', '39', '41', '43', '399', '499', '159', '161', '163', '165', '167', '171', '173', '177', '179', '181', '183', '185', '187', '189', '191', '193', '737', '739', '741', '199', '201', '713', '203', '715', '205', '717', '207', '719', '721', '211', '723', '213', '725', '727', '217', '729', '219', '731', '221', '733', '223', '735', '225', '229', '231', '233', '235', '531', '533', '535', '401', '661', '663', '403', '69', '407', '513', '507', '405', '409', '19', '21', '615', '617', '619', '621', '625', '627', '631', '633', '635', '637', '639', '641', '643', '647', '411', '413', '415', '29', '31', '33', '567', '23', '13', '15', '17', '45', '585', '587', '589', '591', '417', '419', '421', '423', '425', '427', '491', '429', '431', '561', '563', '565', '577', '579', '581', '583', '493', '433', '483', '657', '345', '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.0010750293731689 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.00068497657775879 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.00061202049255371 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`
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.000762939453125 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.00061511993408203 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`
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.0010490417480469 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`
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.0010521411895752 seconds - 6 row(s) affected.