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 (610144, 593148, 592615, 574020, 573319, 569208, 569206, 569205, 543826, 543823, 543821, 543817, 543815, 543813, 543810, 73671, 73677, 73679, 17683, 19534, 20453, 20458, 17087, 21174, 40568, 125072, 138337, 14218, 8605, 8606)) 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,610144,593148,592615,574020,573319,569208,569206,569205,543826,543823,543821,543817,543815,543813,543810,73671,73677,73679,17683,19534,20453,20458,17087,21174,40568,125072,138337,14218,8605,8606)
-
SKU: RODE-00128
Model: VMNTG
Condition: New-In-Box
-
SKU: RODE-DS2
Model: DS2
Condition: New-In-Box
-
SKU: RODE-00192
Model: NT1SIGNATURE
Condition: New-In-Box
-
SKU: RODE-00410
Model: WIPRO
Condition: New-In-Box
-
SKU: RODE-00136
Model: M2
Condition: New-In-Box
-
SKU: RODE-00403TX
Model: WIMETX
Condition: New-In-Box
-
SKU: RODE-00403
Model: WIME
Condition: New-In-Box
-
SKU: RODE-00143T
Model: WIGOIITX
Condition: New-In-Box
-
SKU: RODE-00516
Model: PODMICUSB
Condition: New-In-Box
-
SKU: RODE-00515
Model: RCDUO-B
Condition: New-In-Box
-
SKU: RODE-00514
Model: WIGOIICHARGINGCASE
Condition: New-In-Box
-
SKU: RODE-00513
Model: STREAMERX-B
Condition: New-In-Box
-
SKU: RODE-00512
Model: BACKPACK
Condition: New-In-Box
-
SKU: RODE-00511
Model: XLR6M
Condition: New-In-Box
-
SKU: RODE-00510
Model: XLR3M
Condition: New-In-Box
-
SKU: RODE-00148
Model: VIDEOMIC ME
Condition: New-In-Box
-
SKU: RODE-00262
Model: SC7
Condition: New-In-Box
-
SKU: RODE-00270
Model: VC1
Condition: New-In-Box
-
SKU: RODE-00182
Model: Boompole Bag
Condition: New-In-Box
-
SKU: RODE-00178
Model: MICRO BOOMPOLE
Condition: New-In-Box
-
SKU: RODE-00126A
Model: RODNTG4PLUS
Condition: New-In-Box
-
SKU: RODE-00258
Model: SC1
Condition: New-In-Box
-
SKU: RODE-00153
Model: DEAD KITTEN
Condition: New-In-Box
-
SKU: RODE-00260
Model: SC3
Condition: New-In-Box
-
SKU: RODE-00145
Model: VIDEOMIC PRO-R
Condition: New-In-Box
-
SKU: RODE-00145A
Model: VIDEOMIC PRO-R+
Condition: New-In-Box
-
Rode Microphones
SC6
USD $19.95
SKU: RODE-00261
Model: SC6
Condition: New-In-Box
-
SKU: RODE-00190
Model: VXLR
Condition: New-In-Box
-
SKU: RODE-00152
Model: WS6
Condition: New-In-Box
-
SKU: RODE-00154
Model: WSVM
Condition: New-In-Box