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 (618397, 603179, 603130, 594605, 594602, 594507, 591290, 590105, 590102, 589942, 589941, 589940, 589939, 589938, 589925, 585748, 585169, 585167, 578317, 578316, 578312, 578311, 578310, 578309, 578308, 573643, 560825, 560819, 557414, 550220)) 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,618397,603179,603130,594605,594602,594507,591290,590105,590102,589942,589941,589940,589939,589938,589925,585748,585169,585167,578317,578316,578312,578311,578310,578309,578308,573643,560825,560819,557414,550220)
-
[Black, White, Pink, Green]
SKU: CAN-SELPHY SQUARE QX10
Model: 4107C002, 4108C002, 4109C002, 4110C001
Condition: New-In-Box
-
[Black, Silver]
SKU: CAN-V10
Model: 5946C002, 5947C002
Condition: New-In-Box
-
[Black, White]
SKU: CAN-CR-N700
Model: 6022C001, 6022C002
Condition: New-In-Box
-
SKU: CAN-20277
Model: 6317B001
Condition: New-In-Box
-
SKU: CAN-20278
Model: 0576C001
Condition: New-In-Box
-
SKU: CAN-12927
Model: 3683C001
Condition: New-In-Box
-
SKU: CAN-40515
Model: 5777C002
Condition: New-In-Box
-
SKU: CAN-21130
Model: 6572C001
Condition: New-In-Box
-
SKU: CAN-12829G
Model: 6264C001
Condition: New-In-Box
-
SKU: CAN-17492
Model: 6349C002
Condition: New-In-Box
-
SKU: CAN-17490
Model: 6348C002
Condition: New-In-Box
-
SKU: PRE-CAN-17159
Model: 6263C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-16846
Model: 6262C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: PRE-CAN-17009
Model: 6347C002
Condition: Preorder
Mount Type: Canon EOS (RF)
-
SKU: CAN-17493
Model: 6572C001
Condition: New-In-Box
-
[Black, White]
SKU: CAN-CP1500
Model: 5540C002, 5539C001
Condition: New-In-Box
-
SKU: CAN-20308
Model: 6181C001
Condition: New-In-Box
-
SKU: CAN-16850
Model: 6182C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12338
Model: 6404C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12337
Model: 6403C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12336
Model: 6402C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12335
Model: 6401C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12334
Model: 6400C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12333
Model: 6399C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-12332
Model: 6398C001
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-20283
Model: 2962C001
Condition: New-In-Box
-
SKU: CAN-30292
Model: 4507C017
Condition: New-In-Box
-
SKU: CAN-15125
Model: 5077C024
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-15202
Model: 5803C037
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: CAN-16991
Model: 6128C002
Condition: New-In-Box
Mount Type: Canon EOS (RF)