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 (551384, 547278, 547277, 547275, 495248, 495256, 495258, 503462, 503463, 505183, 505199, 540856, 376915, 380211, 384224, 388091, 199849, 199853, 199854, 182846, 190554, 495246, 495253, 495268, 495449, 502956, 502962, 503464, 503475, 503476)) 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,551384,547278,547277,547275,495248,495256,495258,503462,503463,505183,505199,540856,376915,380211,384224,388091,199849,199853,199854,182846,190554,495246,495253,495268,495449,502956,502962,503464,503475,503476)
-
[Gray, Black, Orange]
SKU: TLT-ALFIE
Model: ALFIE-G, ALFIE-B, ALFIE-C
Condition: New-In-Box
-
SKU: TLT-00608
Model: OLLIE-G
Condition: New-In-Box
-
SKU: TLT-00607
Model: OLLIE-C
Condition: New-In-Box
-
SKU: TLT-00606
Model: OLLIE-B
Condition: New-In-Box
-
SKU: TLT-02003
Model: BRIANDARK2.0
Condition: New-In-Box
-
SKU: TLT-02005
Model: ALANKITDARK2.0
Condition: New-In-Box
-
SKU: TLT-02006
Model: RAYKITDARK
Condition: New-In-Box
-
SKU: TLT-00201
Model: LEOKIT2
Condition: New-In-Box
-
SKU: TLT-00512
Model: TRENTKITGREY2.0
Condition: New-In-Box
-
SKU: TLT-00603
Model: ZELDA-B
Condition: New-In-Box
-
SKU: TLT-00605
Model: ZAARA-B
Condition: New-In-Box
-
SKU: TLT-00145
Model: CHARLESKITDARK2
Condition: New-In-Box
-
[Grey, Bronze/Blue]
SKU: TLT-RAY KIT
Model:
Condition: New-In-Box
-
[Grey, Bronze/Blue, Black]
SKU: TLT-BUCKY KIT W/ VU HEAD
Model: BUCKYKIT, BUCKYKITGREY, BUCKYKITDARK
Condition: New-In-Box
-
[Gray, Blue]
SKU: TLT-AIRHEDVU
Model: AHVUB, AHVUG
Condition: New-In-Box
-
[Bronze, Gray]
SKU: TLT-RAY
Model: RAY, RAYGREY
Condition: New-In-Box
-
SKU: TLT-00120
Model: BILLY
Condition: New-In-Box
-
SKU: TLT-00950
Model: QR4-EQ
Condition: New-In-Box
-
SKU: TLT-01000
Model: QR11-LC
Condition: New-In-Box
-
3 Legged Thing
Toolz
USD $7.99
SKU: TLT-02000
Model: MULTI FUNCTION TOOL
Condition: New-In-Box
-
SKU: TLT-00222
Model: PATTIBLACK
Condition: New-In-Box
-
SKU: TLT-02002
Model: BILLYDARK2.0
Condition: New-In-Box
-
SKU: TLT-02004
Model: WINSTONKIT2DARK
Condition: New-In-Box
-
SKU: TLT-02008
Model: JAYDARK
Condition: New-In-Box
-
SKU: TLT-00306
Model: BUCKYGREY
Condition: New-In-Box
-
SKU: TLT-00101
Model: COREYBLACK2.0
Condition: New-In-Box
-
SKU: TLT-00111
Model: TRAVISBLACK2.0
Condition: New-In-Box
-
SKU: TLT-00510A
Model: TRENTGREY2.0
Condition: New-In-Box
-
SKU: TLT-00951
Model: QR4-DARK
Condition: New-In-Box
-
SKU: TLT-00955
Model: QR7-DARK
Condition: New-In-Box