Factory Shop


Axminster Carpets’ online shop and showroom is a simple way to choose and buy your high quality, luxurious Axminster carpet direct from us.

The shop sells an extensive range of genuine Axminster Carpets’, near perfects, seconds, remnants & perfects and shop exclusive carpets, as well as our high quality, Axfelt™ Triple Layer underlay. Request your free samples today to experience a real Axminster Carpet for yourself.

Our team of carpet experts is available to help you choose the perfect Axminster Carpet of your dreams. You can contact then by phone Monday to Saturday or online either by email or by using our live chat feature when available.

We pride ourselves on providing the highest standard of customer care together with the very best advice to help you make the right choice for your carpet which you will enjoy long into the future.

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` = '97'
AND `page`.`discard` IS FALSE
AND `page`.`publish` IS TRUE
Command completed in 0.00079083442687988 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 ('97')
ORDER BY `page_image`.`ordinal` ASC, `page_image`.`name` ASC, `page_image`.`id` ASC
Command completed in 0.00077986717224121 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.0018010139465332 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 '/97-factory-shop' LIKE `label`.`path`)
ORDER BY `label`.`name` ASC, `label`.`path` ASC
Command completed in 0.00087785720825195 seconds - 304 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.00064492225646973 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.00058698654174805 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.0017931461334229 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.001446008682251 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.00098204612731934 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.0010910034179688 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.0010480880737305 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.00063300132751465 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.0006711483001709 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.00082707405090332 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.0007469654083252 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.0011839866638184 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.001183032989502 seconds - 6 row(s) affected.