SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (20374, 20375, 20376, 20378, 20380, 20382, 20383, 20384, 20385, 20387, 20388, 20389, 20391, 20392, 190972, 13688, 8757, 3959, 3963, 2164, 2171, 20366, 20372, 20373, 20377, 20379, 20386, 20390, 182269, 386608)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,20374,20375,20376,20378,20380,20382,20383,20384,20385,20387,20388,20389,20391,20392,190972,13688,8757,3959,3963,2164,2171,20366,20372,20373,20377,20379,20386,20390,182269,386608)
-
SKU: KNK-01271A
Model: KAC-55CRPL
Condition: New-In-Box
-
SKU: KNK-01341A
Model: KAC-58CRPL
Condition: New-In-Box
-
SKU: KNK-01391A
Model: KAC-62CRPL
Condition: New-In-Box
-
SKU: KNK-01491A
Model: KAC-72CRPL
Condition: New-In-Box
-
SKU: KNK-01571A
Model: KAC-82CRPL
Condition: New-In-Box
-
SKU: KNK-01156
Model: KAC-43UV
Condition: New-In-Box
-
SKU: KNK-01158
Model: KAC-46UV
Condition: New-In-Box
-
SKU: KNK-01181
Model: KAC-49UV
Condition: New-In-Box
-
SKU: KNK-01241
Model: KAC-52UV
Condition: New-In-Box
-
SKU: KNK-01341
Model: KAC-58UV
Condition: New-In-Box
-
SKU: KNK-01391
Model: KAC-62UV
Condition: New-In-Box
-
SKU: KNK-01441
Model: KAC-67UV
Condition: New-In-Box
-
SKU: KNK-01531
Model: KAC-77UV
Condition: New-In-Box
-
SKU: KNK-01571
Model: KAC-82UV
Condition: New-In-Box
-
SKU: KNK-01158A
Model: KAC-46CRPL
Condition: New-In-Box
-
SKU: KNK-01155
Model: KB-405CRPL
Condition: New-In-Box
-
SKU: KNK-01124
Model: KB-30UV
Condition: New-In-Box
-
SKU: KNK-01320
Model: KB-58ND4
Condition: New-In-Box
-
SKU: KNK-01520
Model: KB-77ND4
Condition: New-In-Box
-
SKU: KNK-01140
Model: KB-30CRPL
Condition: New-In-Box
-
SKU: KNK-01560
Model: KB-82ND4
Condition: New-In-Box
-
SKU: KNK-01151A
Model: KAC-37CRPL
Condition: New-In-Box
-
SKU: KNK-01181A
Model: KAC-49CRPL
Condition: New-In-Box
-
SKU: KNK-01241A
Model: KAC-52CRPL
Condition: New-In-Box
-
SKU: KNK-01441A
Model: KAC-67CRPL
Condition: New-In-Box
-
SKU: KNK-01531A
Model: KAC-77CRPL
Condition: New-In-Box
-
SKU: KNK-01271
Model: KAC-55UV
Condition: New-In-Box
-
SKU: KNK-01491
Model: KAC-72UV
Condition: New-In-Box
-
SKU: KNK-03483
Model: A-EXTUBEDG-SEF
Condition: New-In-Box
-
SKU: KNK-TELEPLUS HD 2.0X
Model: K-TPHD2.0-C, K-TPHD2.0-N
Condition: New-In-Box
Available For: Canon AF, Nikon AF