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 (17778, 18447, 18448, 18468, 19305, 17184, 17356, 25489, 129417, 141146, 168720, 93130, 14978, 14979, 12679, 12680, 6476, 6477, 6479, 6482, 6483, 6489, 6490, 6495, 6496, 6497, 6498, 6501, 6931, 6934)) 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,17778,18447,18448,18468,19305,17184,17356,25489,129417,141146,168720,93130,14978,14979,12679,12680,6476,6477,6479,6482,6483,6489,6490,6495,6496,6497,6498,6501,6931,6934)
-
SKU: TAN-00132
Model: AFB011EMS-700
Condition: New-In-Box
Mount Type: Canon EOS (M)
-
SKU: TAN-00068C
Model: AFA012C-700
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: TAN-00068N
Model: AFA012N-700
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: TAN-00068S
Model: AFA012S-700
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: TAN-00397
Model: TAMR AFA009S-700
Condition: New-In-Box
-
SKU: TAN-00074
Model: AFB016S-700
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: TAN-00844
Model: RHAF005
Condition: New-In-Box
-
SKU: TAN-00843M
Model: RHAFA001
Condition: New-In-Box
-
SKU: TAN-00844H
Model: RHAFA007
Condition: New-In-Box
-
SKU: TAN-00910
Model: A035TM
Condition: New-In-Box
-
SKU: TAN-00809
Model: FLCA012
Condition: New-In-Box
-
SKU: TAN-01011
Model: A011LC
Condition: New-In-Box
-
SKU: TAN-00395
Model: A009C-700
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: TAN-00396
Model: A009N-700
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: TAN-00129
Model: AFB011700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00130
Model: AFB011S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00370
Model: AFG005C-700
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: TAN-00372
Model: AFG005S-700
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: TAN-00423
Model: AF017M-700
Condition: New-In-Box
-
SKU: TAN-00481
Model: AFB01N-700
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: TAN-00482
Model: AFB01M-700
Condition: New-In-Box
-
SKU: TAN-00630
Model: AF20C-700
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: TAN-00631
Model: AF20N-700
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: TAN-00800
Model: flc52
Condition: New-In-Box
-
SKU: TAN-00801
Model: flc55
Condition: New-In-Box
-
SKU: TAN-00803
Model: flc62
Condition: New-In-Box
-
SKU: TAN-00806
Model: flc77
Condition: New-In-Box
-
SKU: TAN-00845
Model: RHAFA09
Condition: New-In-Box
-
![SP AF17-50mm F/2.8 XR Di II LD Aspherical [IF] (Sony/Minolta)](https://robertscamera.com/media/catalog/product/cache/fbfc0465a79e951f6376d1dbe9b12d2d/t/a/tamron_17-50l_1.jpg)
SKU: TAN-00093
Model: AF016M-700
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: TAN-00122
Model: AF014NII-700
Condition: New-In-Box
