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 (574214, 570133, 557613, 541406, 541403, 541390, 541388, 342534, 243050, 260496, 302072, 229282, 71148, 17859, 19546, 20179, 111208, 371343, 375752, 382841, 389592, 389629, 389637, 389657, 389658, 389844, 396465, 396720, 396870, 396871)) 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,574214,570133,557613,541406,541403,541390,541388,342534,243050,260496,302072,229282,71148,17859,19546,20179,111208,371343,375752,382841,389592,389629,389637,389657,389658,389844,396465,396720,396870,396871)
-
SKU: TETH-SDAC18
Model: SDAC18
Condition: New-In-Box
-
SKU: TETH-SDAC14
Model: SDAC14
Condition: New-In-Box
-
SKU: TETH-00231
Model: SDAC150W
Condition: New-In-Box
-
SKU: TETH-1003
Model: CUC31RB-ORG
Condition: New-In-Box
-
SKU: TETH-1002
Model: CUC31B-ORG
Condition: New-In-Box
-
SKU: TETH-1001
Model: CUC31R-ORG
Condition: New-In-Box
-
SKU: TETH-1000
Model: CUC31-ORG
Condition: New-In-Box
-
SKU: TETH-01030
Model: TB-QR-004G
Condition: New-In-Box
-
SKU: TETH-01013
Model: TPHDCA15
Condition: New-In-Box
-
SKU: TETH-00991A
Model: CUC3315-ORG
Condition: New-In-Box
-
SKU: TETH-00962
Model: CUC15-BLK
Condition: New-In-Box
-
SKU: TETH-00963
Model: CUC15-ORG
Condition: New-In-Box
-
SKU: TETH-01024
Model: CU3016
Condition: New-In-Box
-
SKU: TETH-00500
Model: RS220
Condition: New-In-Box
-
SKU: TETH-01008
Model: CU1917
Condition: New-In-Box
-
SKU: TETH-01003
Model: CU5453
Condition: New-In-Box
-
SKU: TETH-01052
Model: CRUPS
Condition: New-In-Box
-
SKU: TETH-02020
Model: TBPRO3-ORG
Condition: New-In-Box
-
[Orange, Black]
SKU: TETH-USB-C CORE CONTR EXT
Model: TETH-02020, TETH-02021
Condition: New-In-Box
-
SKU: TETH-02025
Model: CUC15RT-BLK
Condition: New-In-Box
-
SKU: TETH-00990
Model: CUC3215-BLK
Condition: New-In-Box
-
SKU: TETH-01004
Model: CU5454
Condition: New-In-Box
-
SKU: TETH-01000
Model: CU5450
Condition: New-In-Box
-
SKU: TETH-00602
Model: RSTAA2
Condition: New-In-Box
-
SKU: TETH-00701
Model: AD-ARCA
Condition: New-In-Box
-
SKU: TETH-RELAYCAMERACOUPLER
Model: CRSFW50, CRCE18, CRPBLC12, CRND4, CRCE6, CRPBLF19, CRBLN-1
Condition: New-In-Box
-
SKU: TETH-02030
Model: TA-CCLB
Condition: New-In-Box
-
SKU: TETH-01053
Model: CRNPFZ100
Condition: New-In-Box
-
SKU: TETH-1089
Model: CRN5A
Condition: New-In-Box
-
SKU: TETH-01090
Model: CRN5B-C
Condition: New-In-Box