Solid Wood Bookcase - Cottage Collection - 2945
Solid Wood Bookcase - Cottage Collection - 2945
ID# CR-8017
Cottage CollectionMade in
Please select below options to see correct price, dimensions and availability.
Features & Specifications
| Country of Manufacture | Canada |
| Warranty Note | 1 year |
| Material | Knot-free Solid Southern Yellow Pine |
Description
- Made of solid Southern Yellow Pine.
- 3/4" thick back panels.
Shipping Box Dimensions
Matching Case Goods
escapeHtml(__($block->getTitle())) ?>
- getImage($_item, $image)->toHtml() ?>
Bedroom Mirror - Cottage Collection - 3240 - Classic
$378.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Bedroom Mirror - Cottage Collection - 3240 - Brindle
$378.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Bedroom Mirror - Cottage Collection - 3240 - Cloud
$378.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Bedroom Mirror - Cottage Collection - 3240 - Espresso
$378.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Bedroom Mirror - Cottage Collection - 3240 - Graphite
$378.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Bedroom Mirror - Cottage Collection - 3240 - Storm
$378.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Bedroom Mirror - Cottage Collection - 3240 - Unfinished
$378.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Shelf n Door - Left Hinge - 27" H - Classic
$448.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Shelf n Door - Left Hinge - 27" H - Brindle
$448.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Shelf n Door - Left Hinge - 27" H - Cloud
$448.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Shelf n Door - Left Hinge - 27" H - Graphite
$448.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Shelf n Door - Left Hinge - 27" H - Espresso
$448.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Shelf n Door - Left Hinge - 27" H - Storm
$448.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Shelf n Door - Left Hinge - 27" H - Unfinished
$448.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Drawer n Door - Left Hinge - 27" H - Classic
$548.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Drawer n Door - Left Hinge - 27" H - Brindle
$548.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Drawer n Door - Left Hinge - 27" H - Cloud
$548.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Drawer n Door - Left Hinge - 27" H - Graphite
$548.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Drawer n Door - Left Hinge - 27" H - Espresso
$548.00getReviewsSummaryHtml($_item, $templateType) ?> - getImage($_item, $image)->toHtml() ?>
Solid Wood Petit Nightstand - Cottage Collection - w Drawer n Door - Left Hinge - 27" H - Storm
$548.00getReviewsSummaryHtml($_item, $templateType) ?>
Matching Beds
Error filtering template: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'FIELD(e.sku, 'CR-4017-N', 'CR-4017-B', 'CR-4017-C', 'CR-4017-G', 'CR-4017-E', 'CR-4017-S', 'CR-4017-U', 'CR-4099-N', 'CR-4099-B', 'CR-4099-C', 'CR-4099-E', 'CR-4099-G', 'CR-4099-S', 'CR-4099-U' in 'order clause', query was: SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 3, 4) AND cat_index.category_id=2
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (((IFNULL(`e`.`sku`, 0) IN ('CR-4017-N', 'CR-4017-B', 'CR-4017-C', 'CR-4017-G', 'CR-4017-E', 'CR-4017-S', 'CR-4017-U', 'CR-4099-N', 'CR-4099-B', 'CR-4099-C', 'CR-4099-E', 'CR-4099-G', 'CR-4099-S', 'CR-4099-U', 'CR-4100-N', 'CR-4100-B', 'CR-4100-C', 'CR-4100-E', 'CR-4100-G', 'CR-4100-S', 'CR-4100-U', 'CR-4336-N', 'CR-4336-B', 'CR-4336-C', 'CR-4336-G', 'CR-4336-E', 'CR-4336-S', 'CR-4336-U', 'CR-4366-N', 'CR-4366-B', 'CR-4366-C', 'CR-4366-G', 'CR-4366-E', 'CR-4366-S', 'CR-4366-U', 'CR-4372-N', 'CR-4372-B', 'CR-4372-C', 'CR-4372-G', 'CR-4372-E', 'CR-4372-S', 'CR-4372-U', 'CR-4376-N', 'CR-4376-B', 'CR-4376-C', 'CR-4376-G', 'CR-4376-E', 'CR-4376-S', 'CR-4376-U', 'CR-4379-N', 'CR-4379-B', 'CR-4379-C', 'CR-4379-G', 'CR-4379-E', 'CR-4379-S', 'CR-4379-U', 'CR-4382-N', 'CR-4382-B', 'CR-4382-C', 'CR-4382-G', 'CR-4382-E', 'CR-4382-S', 'CR-4382-U', 'CR-4386-N', 'CR-4386-B', 'CR-4386-C', 'CR-4386-G', 'CR-4386-E', 'CR-4386-S', 'CR-4386-U', 'CR-4389-N', 'CR-4389-B', 'CR-4389-C', 'CR-4389-G', 'CR-4389-E', 'CR-4389-S', 'CR-4389-U', 'CR-4396-N', 'CR-4396-B', 'CR-4396-C', 'CR-4396-G', 'CR-4396-E', 'CR-4396-S', 'CR-4396-U', 'CR-4717-N', 'CR-4717-B', 'CR-4717-C', 'CR-4717-G', 'CR-4717-E', 'CR-4717-S', 'CR-4717-U', 'CR-4747-N', 'CR-4747-B', 'CR-4747-C', 'CR-4747-E', 'CR-4747-G', 'CR-4747-S', 'CR-4747-U', 'CR-4749-N', 'CR-4749-B', 'CR-4749-C', 'CR-4749-E', 'CR-4749-G', 'CR-4749-S', 'CR-4749-U', 'CR-4767-N', 'CR-4767-B', 'CR-4767-C', 'CR-4767-E', 'CR-4767-G', 'CR-4767-S', 'CR-4767-U', 'CR-4769-N', 'CR-4769-B', 'CR-4769-C', 'CR-4769-E', 'CR-4769-G', 'CR-4769-S', 'CR-4769-U', 'CR-4797-N', 'CR-4797-B', 'CR-4797-C', 'CR-4797-G', 'CR-4797-E', 'CR-4797-S', 'CR-4797-U', 'CR-43717-N', 'CR-43717-B', 'CR-43717-C', 'CR-43717-G', 'CR-43717-E', 'CR-43717-S', 'CR-43717-U', 'CR-43742-N', 'CR-43742-B', 'CR-43742-C', 'CR-43742-G', 'CR-43742-E', 'CR-43742-S', 'CR-43742-U', 'CR-43749-N', 'CR-43749-B', 'CR-43749-C', 'CR-43749-G', 'CR-43749-E', 'CR-43749-S', 'CR-43749-U', 'CR-43762-N', 'CR-43762-B', 'CR-43762-C', 'CR-43762-G', 'CR-43762-E', 'CR-43762-S', 'CR-43762-U', 'CR-43768-N', 'CR-43768-B', 'CR-43768-C', 'CR-43768-G', 'CR-43768-E', 'CR-43768-S', 'CR-43768-U', 'CR-43769-N', 'CR-43769-B', 'CR-43769-C', 'CR-43769-G', 'CR-43769-E', 'CR-43769-S', 'CR-43769-U', 'CR-43798-N', 'CR-43798-B', 'CR-43798-C', 'CR-43798-G', 'CR-43798-E', 'CR-43798-S', 'CR-43798-U', 'CR-437448-N', 'CR-437448-B', 'CR-437448-C', 'CR-437448-G', 'CR-437448-E', 'CR-437448-S', 'CR-437448-U', 'CR-43988-B', 'CR-43988-N', 'CR-43988-C', 'CR-43988-E', 'CR-43988-G', 'CR-43988-S', 'CR-43988-U', 'CR-43928-B', 'CR-43928-N', 'CR-43928-C', 'CR-43928-E', 'CR-43928-G', 'CR-43928-S', 'CR-43928-U') OR (FIND_IN_SET ('CR-4017-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4017-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4017-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4017-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4017-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4017-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4017-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4099-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4099-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4099-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4099-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4099-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4099-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4099-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4100-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4100-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4100-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4100-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4100-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4100-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4100-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4336-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4336-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4336-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4336-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4336-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4336-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4336-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4366-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4366-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4366-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4366-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4366-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4366-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4366-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4372-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4372-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4372-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4372-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4372-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4372-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4372-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4376-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4376-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4376-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4376-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4376-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4376-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4376-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4379-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4379-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4379-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4379-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4379-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4379-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4379-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4382-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4382-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4382-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4382-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4382-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4382-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4382-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4386-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4386-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4386-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4386-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4386-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4386-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4386-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4389-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4389-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4389-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4389-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4389-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4389-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4389-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4396-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4396-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4396-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4396-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4396-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4396-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4396-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4717-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4717-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4717-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4717-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4717-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4717-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4717-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4747-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4747-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4747-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4747-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4747-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4747-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4747-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4749-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4749-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4749-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4749-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4749-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4749-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4749-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4767-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4767-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4767-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4767-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4767-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4767-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4767-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4769-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4769-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4769-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4769-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4769-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4769-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4769-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4797-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4797-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4797-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4797-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4797-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4797-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4797-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43717-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43717-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43717-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43717-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43717-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43717-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43717-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43742-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43742-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43742-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43742-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43742-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43742-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43742-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43749-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43749-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43749-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43749-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43749-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43749-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43749-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43762-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43762-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43762-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43762-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43762-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43762-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43762-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43768-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43768-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43768-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43768-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43768-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43768-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43768-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43769-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43769-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43769-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43769-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43769-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43769-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43769-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43798-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43798-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43798-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43798-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43798-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43798-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43798-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-437448-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-437448-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-437448-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-437448-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-437448-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-437448-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-437448-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43988-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43988-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43988-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43988-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43988-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43988-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43988-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43928-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43928-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43928-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43928-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43928-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43928-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-43928-U', `e`.`sku`) > 0)) )) ORDER BY `price_index`.`min_price` asc, `FIELD(e`.`sku, 'CR-4017-N', 'CR-4017-B', 'CR-4017-C', 'CR-4017-G', 'CR-4017-E', 'CR-4017-S', 'CR-4017-U', 'CR-4099-N', 'CR-4099-B', 'CR-4099-C', 'CR-4099-E', 'CR-4099-G', 'CR-4099-S', 'CR-4099-U', 'CR-4100-N', 'CR-4100-B', 'CR-4100-C', 'CR-4100-E', 'CR-4100-G', 'CR-4100-S', 'CR-4100-U', 'CR-4336-N', 'CR-4336-B', 'CR-4336-C', 'CR-4336-G', 'CR-4336-E', 'CR-4336-S', 'CR-4336-U', 'CR-4366-N', 'CR-4366-B', 'CR-4366-C', 'CR-4366-G', 'CR-4366-E', 'CR-4366-S', 'CR-4366-U', 'CR-4372-N', 'CR-4372-B', 'CR-4372-C', 'CR-4372-G', 'CR-4372-E', 'CR-4372-S', 'CR-4372-U', 'CR-4376-N', 'CR-4376-B', 'CR-4376-C', 'CR-4376-G', 'CR-4376-E', 'CR-4376-S', 'CR-4376-U', 'CR-4379-N', 'CR-4379-B', 'CR-4379-C', 'CR-4379-G', 'CR-4379-E', 'CR-4379-S', 'CR-4379-U', 'CR-4382-N', 'CR-4382-B', 'CR-4382-C', 'CR-4382-G', 'CR-4382-E', 'CR-4382-S', 'CR-4382-U', 'CR-4386-N', 'CR-4386-B', 'CR-4386-C', 'CR-4386-G', 'CR-4386-E', 'CR-4386-S', 'CR-4386-U', 'CR-4389-N', 'CR-4389-B', 'CR-4389-C', 'CR-4389-G', 'CR-4389-E', 'CR-4389-S', 'CR-4389-U', 'CR-4396-N', 'CR-4396-B', 'CR-4396-C', 'CR-4396-G', 'CR-4396-E', 'CR-4396-S', 'CR-4396-U', 'CR-4717-N', 'CR-4717-B', 'CR-4717-C', 'CR-4717-G', 'CR-4717-E', 'CR-4717-S', 'CR-4717-U', 'CR-4747-N', 'CR-4747-B', 'CR-4747-C', 'CR-4747-E', 'CR-4747-G', 'CR-4747-S', 'CR-4747-U', 'CR-4749-N', 'CR-4749-B', 'CR-4749-C', 'CR-4749-E', 'CR-4749-G', 'CR-4749-S', 'CR-4749-U', 'CR-4767-N', 'CR-4767-B', 'CR-4767-C', 'CR-4767-E', 'CR-4767-G', 'CR-4767-S', 'CR-4767-U', 'CR-4769-N', 'CR-4769-B', 'CR-4769-C', 'CR-4769-E', 'CR-4769-G', 'CR-4769-S', 'CR-4769-U', 'CR-4797-N', 'CR-4797-B', 'CR-4797-C', 'CR-4797-G', 'CR-4797-E', 'CR-4797-S', 'CR-4797-U', 'CR-43717-N', 'CR-43717-B', 'CR-43717-C', 'CR-43717-G', 'CR-43717-E', 'CR-43717-S', 'CR-43717-U', 'CR-43742-N', 'CR-43742-B', 'CR-43742-C', 'CR-43742-G', 'CR-43742-E', 'CR-43742-S', 'CR-43742-U', 'CR-43749-N', 'CR-43749-B', 'CR-43749-C', 'CR-43749-G', 'CR-43749-E', 'CR-43749-S', 'CR-43749-U', 'CR-43762-N', 'CR-43762-B', 'CR-43762-C', 'CR-43762-G', 'CR-43762-E', 'CR-43762-S', 'CR-43762-U', 'CR-43768-N', 'CR-43768-B', 'CR-43768-C', 'CR-43768-G', 'CR-43768-E', 'CR-43768-S', 'CR-43768-U', 'CR-43769-N', 'CR-43769-B', 'CR-43769-C', 'CR-43769-G', 'CR-43769-E', 'CR-43769-S', 'CR-43769-U', 'CR-43798-N', 'CR-43798-B', 'CR-43798-C', 'CR-43798-G', 'CR-43798-E', 'CR-43798-S', 'CR-43798-U', 'CR-437448-N', 'CR-437448-B', 'CR-437448-C', 'CR-437448-G', 'CR-437448-E', 'CR-437448-S', 'CR-437448-U', 'CR-43988-B', 'CR-43988-N', 'CR-43988-C', 'CR-43988-E', 'CR-43988-G', 'CR-43988-S', 'CR-43988-U', 'CR-43928-B', 'CR-43928-N', 'CR-43928-C', 'CR-43928-E', 'CR-43928-G', 'CR-43928-S', 'CR-43928-U')` ASC
LIMIT 30
