Bedroom Mirror - Cottage Collection - 3240

Error filtering template: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'FIELD(e.sku, 'CR-4102-N', 'CR-4102-B', 'CR-4102-C', 'CR-4102-G', 'CR-4102-E', 'CR-4102-S', 'CR-4102-U', 'CR-5005-N', 'CR-5005-B', 'CR-5005-C', 'CR-5005-G', 'CR-5005-E', 'CR-5005-S', 'CR-5005-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-4102-N', 'CR-4102-B', 'CR-4102-C', 'CR-4102-G', 'CR-4102-E', 'CR-4102-S', 'CR-4102-U', 'CR-5005-N', 'CR-5005-B', 'CR-5005-C', 'CR-5005-G', 'CR-5005-E', 'CR-5005-S', 'CR-5005-U', 'CR-7009-N', 'CR-7009-B', 'CR-7009-C', 'CR-7009-G', 'CR-7009-E', 'CR-7009-S', 'CR-7009-U', 'CR-7010-N', 'CR-7010-B', 'CR-7010-C', 'CR-7010-G', 'CR-7010-E', 'CR-7010-S', 'CR-7010-U', 'CR-7011-N', 'CR-7011-B', 'CR-7011-C', 'CR-7011-G', 'CR-7011-E', 'CR-7011-S', 'CR-7011-U', 'CR-7012-N', 'CR-7012-B', 'CR-7012-C', 'CR-7012-G', 'CR-7012-E', 'CR-7012-S', 'CR-7012-U', 'CR-7013-N', 'CR-7013-B', 'CR-7013-C', 'CR-7013-G', 'CR-7013-E', 'CR-7013-S', 'CR-7013-U', 'CR-7015-N', 'CR-7015-B', 'CR-7015-C', 'CR-7015-G', 'CR-7015-E', 'CR-7015-S', 'CR-7015-U', 'CR-7017-N', 'CR-7017-B', 'CR-7017-C', 'CR-7017-G', 'CR-7017-E', 'CR-7017-S', 'CR-7017-U', 'CR-7018-N', 'CR-7018-B', 'CR-7018-C', 'CR-7018-G', 'CR-7018-E', 'CR-7018-S', 'CR-7018-U', 'CR-7024-N', 'CR-7024-B', 'CR-7024-C', 'CR-7024-G', 'CR-7024-E', 'CR-7024-S', 'CR-7024-U', 'CR-7026-N', 'CR-7026-B', 'CR-7026-C', 'CR-7026-G', 'CR-7026-E', 'CR-7026-S', 'CR-7026-U', 'CR-7028-N', 'CR-7028-B', 'CR-7028-C', 'CR-7028-G', 'CR-7028-E', 'CR-7028-S', 'CR-7028-U', 'CR-7029-N', 'CR-7029-B', 'CR-7029-C', 'CR-7029-G', 'CR-7029-E', 'CR-7029-S', 'CR-7029-U', 'CR-7216-N', 'CR-7216-B', 'CR-7216-C', 'CR-7216-G', 'CR-7216-E', 'CR-7216-S', 'CR-7216-U', 'CR-8004-N', 'CR-8004-B', 'CR-8004-C', 'CR-8004-G', 'CR-8004-E', 'CR-8004-S', 'CR-8004-U', 'CR-8005-N', 'CR-8005-B', 'CR-8005-C', 'CR-8005-G', 'CR-8005-E', 'CR-8005-S', 'CR-8005-U', 'CR-8007-N', 'CR-8007-B', 'CR-8007-C', 'CR-8007-G', 'CR-8007-E', 'CR-8007-S', 'CR-8007-U', 'CR-8014-N', 'CR-8014-B', 'CR-8014-C', 'CR-8014-G', 'CR-8014-E', 'CR-8014-S', 'CR-8014-U', 'CR-8015-N', 'CR-8015-B', 'CR-8015-C', 'CR-8015-G', 'CR-8015-E', 'CR-8015-S', 'CR-8015-U', 'CR-8017-N', 'CR-8017-B', 'CR-8017-C', 'CR-8017-G', 'CR-8017-E', 'CR-8017-S', 'CR-8017-U', 'CR-7009D-N', 'CR-7009D-B', 'CR-7009D-C', 'CR-7009D-G', 'CR-7009D-E', 'CR-7009D-S', 'CR-7009D-U', 'CR-7009L-N', 'CR-7009L-B', 'CR-7009L-C', 'CR-7009L-G', 'CR-7009L-E', 'CR-7009L-S', 'CR-7009L-U', 'CR-7010D-N', 'CR-7010D-B', 'CR-7010D-C', 'CR-7010D-G', 'CR-7010D-E', 'CR-7010D-S', 'CR-7010D-U', 'CR-7010L-N', 'CR-7010L-B', 'CR-7010L-C', 'CR-7010L-G', 'CR-7010L-E', 'CR-7010L-S', 'CR-7010L-U', 'CR-8003L-N', 'CR-8003L-B', 'CR-8003L-C', 'CR-8003L-G', 'CR-8003L-E', 'CR-8003L-S', 'CR-8003L-U', 'CR-8003DL-N', 'CR-8003DL-B', 'CR-8003DL-C', 'CR-8003DL-G', 'CR-8003DL-E', 'CR-8003DL-S', 'CR-8003DL-U') OR (FIND_IN_SET ('CR-4102-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4102-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4102-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4102-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4102-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4102-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-4102-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-5005-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-5005-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-5005-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-5005-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-5005-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-5005-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-5005-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7011-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7011-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7011-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7011-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7011-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7011-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7011-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7012-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7012-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7012-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7012-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7012-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7012-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7012-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7013-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7013-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7013-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7013-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7013-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7013-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7013-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7015-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7015-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7015-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7015-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7015-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7015-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7015-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7017-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7017-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7017-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7017-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7017-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7017-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7017-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7018-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7018-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7018-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7018-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7018-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7018-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7018-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7024-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7024-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7024-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7024-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7024-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7024-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7024-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7026-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7026-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7026-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7026-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7026-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7026-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7026-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7028-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7028-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7028-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7028-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7028-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7028-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7028-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7029-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7029-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7029-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7029-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7029-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7029-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7029-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7216-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7216-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7216-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7216-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7216-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7216-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7216-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8004-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8004-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8004-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8004-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8004-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8004-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8004-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8005-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8005-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8005-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8005-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8005-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8005-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8005-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8007-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8007-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8007-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8007-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8007-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8007-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8007-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8014-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8014-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8014-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8014-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8014-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8014-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8014-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8015-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8015-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8015-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8015-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8015-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8015-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8015-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8017-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8017-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8017-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8017-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8017-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8017-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8017-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009D-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009D-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009D-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009D-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009D-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009D-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009D-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009L-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009L-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009L-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009L-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009L-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009L-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7009L-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010D-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010D-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010D-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010D-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010D-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010D-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010D-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010L-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010L-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010L-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010L-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010L-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010L-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-7010L-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003L-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003L-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003L-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003L-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003L-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003L-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003L-U', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003DL-N', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003DL-B', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003DL-C', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003DL-G', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003DL-E', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003DL-S', `e`.`sku`) > 0) OR (FIND_IN_SET ('CR-8003DL-U', `e`.`sku`) > 0)) )) ORDER BY `price_index`.`min_price` asc, `FIELD(e`.`sku, 'CR-4102-N', 'CR-4102-B', 'CR-4102-C', 'CR-4102-G', 'CR-4102-E', 'CR-4102-S', 'CR-4102-U', 'CR-5005-N', 'CR-5005-B', 'CR-5005-C', 'CR-5005-G', 'CR-5005-E', 'CR-5005-S', 'CR-5005-U', 'CR-7009-N', 'CR-7009-B', 'CR-7009-C', 'CR-7009-G', 'CR-7009-E', 'CR-7009-S', 'CR-7009-U', 'CR-7010-N', 'CR-7010-B', 'CR-7010-C', 'CR-7010-G', 'CR-7010-E', 'CR-7010-S', 'CR-7010-U', 'CR-7011-N', 'CR-7011-B', 'CR-7011-C', 'CR-7011-G', 'CR-7011-E', 'CR-7011-S', 'CR-7011-U', 'CR-7012-N', 'CR-7012-B', 'CR-7012-C', 'CR-7012-G', 'CR-7012-E', 'CR-7012-S', 'CR-7012-U', 'CR-7013-N', 'CR-7013-B', 'CR-7013-C', 'CR-7013-G', 'CR-7013-E', 'CR-7013-S', 'CR-7013-U', 'CR-7015-N', 'CR-7015-B', 'CR-7015-C', 'CR-7015-G', 'CR-7015-E', 'CR-7015-S', 'CR-7015-U', 'CR-7017-N', 'CR-7017-B', 'CR-7017-C', 'CR-7017-G', 'CR-7017-E', 'CR-7017-S', 'CR-7017-U', 'CR-7018-N', 'CR-7018-B', 'CR-7018-C', 'CR-7018-G', 'CR-7018-E', 'CR-7018-S', 'CR-7018-U', 'CR-7024-N', 'CR-7024-B', 'CR-7024-C', 'CR-7024-G', 'CR-7024-E', 'CR-7024-S', 'CR-7024-U', 'CR-7026-N', 'CR-7026-B', 'CR-7026-C', 'CR-7026-G', 'CR-7026-E', 'CR-7026-S', 'CR-7026-U', 'CR-7028-N', 'CR-7028-B', 'CR-7028-C', 'CR-7028-G', 'CR-7028-E', 'CR-7028-S', 'CR-7028-U', 'CR-7029-N', 'CR-7029-B', 'CR-7029-C', 'CR-7029-G', 'CR-7029-E', 'CR-7029-S', 'CR-7029-U', 'CR-7216-N', 'CR-7216-B', 'CR-7216-C', 'CR-7216-G', 'CR-7216-E', 'CR-7216-S', 'CR-7216-U', 'CR-8004-N', 'CR-8004-B', 'CR-8004-C', 'CR-8004-G', 'CR-8004-E', 'CR-8004-S', 'CR-8004-U', 'CR-8005-N', 'CR-8005-B', 'CR-8005-C', 'CR-8005-G', 'CR-8005-E', 'CR-8005-S', 'CR-8005-U', 'CR-8007-N', 'CR-8007-B', 'CR-8007-C', 'CR-8007-G', 'CR-8007-E', 'CR-8007-S', 'CR-8007-U', 'CR-8014-N', 'CR-8014-B', 'CR-8014-C', 'CR-8014-G', 'CR-8014-E', 'CR-8014-S', 'CR-8014-U', 'CR-8015-N', 'CR-8015-B', 'CR-8015-C', 'CR-8015-G', 'CR-8015-E', 'CR-8015-S', 'CR-8015-U', 'CR-8017-N', 'CR-8017-B', 'CR-8017-C', 'CR-8017-G', 'CR-8017-E', 'CR-8017-S', 'CR-8017-U', 'CR-7009D-N', 'CR-7009D-B', 'CR-7009D-C', 'CR-7009D-G', 'CR-7009D-E', 'CR-7009D-S', 'CR-7009D-U', 'CR-7009L-N', 'CR-7009L-B', 'CR-7009L-C', 'CR-7009L-G', 'CR-7009L-E', 'CR-7009L-S', 'CR-7009L-U', 'CR-7010D-N', 'CR-7010D-B', 'CR-7010D-C', 'CR-7010D-G', 'CR-7010D-E', 'CR-7010D-S', 'CR-7010D-U', 'CR-7010L-N', 'CR-7010L-B', 'CR-7010L-C', 'CR-7010L-G', 'CR-7010L-E', 'CR-7010L-S', 'CR-7010L-U', 'CR-8003L-N', 'CR-8003L-B', 'CR-8003L-C', 'CR-8003L-G', 'CR-8003L-E', 'CR-8003L-S', 'CR-8003L-U', 'CR-8003DL-N', 'CR-8003DL-B', 'CR-8003DL-C', 'CR-8003DL-G', 'CR-8003DL-E', 'CR-8003DL-S', 'CR-8003DL-U')` ASC LIMIT 20

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