Myth & Moor

Dilly Dally

£89.00 per sq. metre

Myth & Moor

Dilly Dally

Dilly Dally

608-21051

Myth & Moor

Dilly Dally

Dilly Dally

608-21051

£89.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

£1068

Medium Room

Medium Room

5m x 4m

£1780

Large Room

Large Room

6m x 4m

£2136

Stairs

Stairs

17m2

£1513

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.0016460418701172 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.0008699893951416 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.0007178783416748 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.0010011196136475 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.00080299377441406 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.00082707405090332 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.00064301490783691 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.00085997581481934 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.00081396102905273 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.00091004371643066 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.00082302093505859 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.00060796737670898 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.0011970996856689 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.00084114074707031 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.00066113471984863 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.00081491470336914 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.00077080726623535 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.0018758773803711 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/497-Dilly%20Dally' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.0044379234313965 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` = '285'
Command completed in 0.0006101131439209 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.0006568431854248 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.00063586235046387 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.00053691864013672 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.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` = '297'
Command completed in 0.00057506561279297 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.00059390068054199 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.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` = '281'
Command completed in 0.0005640983581543 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` = '325'
Command completed in 0.00051689147949219 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.00049400329589844 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.00045299530029297 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.00080084800720215 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.00069189071655273 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.0017211437225342 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.001478910446167 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.0011510848999023 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.0010509490966797 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.0010108947753906 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.00077986717224121 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.00083303451538086 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.00089001655578613 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.00068187713623047 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.0020639896392822 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.0010168552398682 seconds - 6 row(s) affected.