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 (631204, 630718, 594868, 593789, 591420, 591374, 591371, 591370, 591368, 591367, 591365, 584745, 584697, 584692, 584689, 584684, 584259, 383810, 383834, 347562, 347604, 347631, 347645, 360329, 416607, 416631, 416760, 438645, 267606, 267607)) 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,631204,630718,594868,593789,591420,591374,591371,591370,591368,591367,591365,584745,584697,584692,584689,584684,584259,383810,383834,347562,347604,347631,347645,360329,416607,416631,416760,438645,267606,267607)
-
[Sage, Raw]
SKU: PED-SHOE POUCH
Model: BSP-SG-1, BSP-RW-1
Condition: New-In-Box
-
SKU: PED-00127
Model: L-CY-3
Condition: New-In-Box
-
[Charcoal, Sage, Midnight, Red]
SKU: PED-WALLET SLIM
Model: M-WA-AA-CH-1, M-WA-AA-RD-1, M-WA-AA-SG-1, M-WA-AA-MN-1
Condition: New-In-Box
-
[Charcoal, Midnight Blue, Sun Yellow, Redwood]
SKU: PED-WALLET STAND
Model: M-WA-AB-CH-1, M-WA-AB-SN-1, M-WA-AB-MN-1, M-WA-AB-RD-1
Condition: New-In-Box
-
SKU: PED-00708
Model: M-BM-AA-BK-1
Condition: New-In-Box
-
SKU: PED-00780
Model: M-MC-AR-CH-1
Condition: New-In-Box
-
SKU: PED-00771
Model: M-MC-BC-CH-1
Condition: New-In-Box
-
SKU: PED-00770
Model: M-MC-BB-CH-1
Condition: New-In-Box
-
SKU: PED-00755
Model: M-LC-BL-CH-1
Condition: New-In-Box
-
SKU: PED-00750
Model: M-MC-BL-CH-1
Condition: New-In-Box
-
SKU: PED-00745
Model: M-LC-BK-CH-1
Condition: New-In-Box
-
SKU: PED-00740
Model: M-MC-BK-CH-1
Condition: New-In-Box
-
SKU: PED-00705
Model: M-BM-AB-BK-1
Condition: New-In-Box
-
SKU: PED-00704
Model: M-CM-AB-BK-1
Condition: New-In-Box
-
SKU: PED-00703
Model: M-CK-AA-BK-1
Condition: New-In-Box
-
SKU: PED-00702
Model: M-TR-AA-BK-1
Condition: New-In-Box
-
SKU: PED-00700
Model: M-CS-BK-1
Condition: New-In-Box
-
[Black, Bone]
SKU: PED-EVERYDAY TOTEP 20L V2
Model: BEDTP-20-BK-2, BEDTP-20-BO-2
Condition: New-In-Box
-
[Black, Bone]
SKU: PED-EVERYDAY TOTE 15L V2
Model: BEDT-15-BK-2, BEDT-15-BO-2
Condition: New-In-Box
-
[Black, Ash, Charcoal, Midnight Blue]
SKU: PED-EVERYDAY BACKPACK 20L V2
Model: BEDB-20-BK-2, BEDB-20-CH-2, BEDB-20-AS-2, BEDB-20-MN-2
Condition: New-In-Box
-
[Black, Ash]
SKU: PED-EVERYDAY SLING 3L
Model: BEDS-3-BK-2, BEDS-3-AS-2
Condition: New-In-Box
-
[Black, Sage, Midnight, Charcoal, Bone]
SKU: PED-TECH POUCH
Model: BTP-BK-1, BTP-SG-1
Condition: New-In-Box
-
[Black, Ash, Midnight, Sage, Coyote]
SKU: PED-CUFFWRISTSTRAP
Model: CF-BL-3, CF-AS-3, CF-SG-3, CF-MN-3, CF-CY-3
Condition: New-In-Box
-
SKU: PED-00175A
Model: PL-S-3
Condition: New-In-Box
-
[Ash, Black, Midnight, Sage, Coyote]
SKU: PED-SL-SG-3 SLIDE
Model: SL-AS-3, SL-MN-3, SL-BK-3, SL-SG-3, SL-CY-3
Condition: New-In-Box
-
[Black, Ash, Midnight, Sage]
SKU: PED-SLIDELITE
Model: SLL-AS-3, SLL-MN-3, SLL-BK-3, SLL-SG-3, SLL-CY-3
Condition: New-In-Box
-
Peak Design
Leash
USD $44.95
[Black, Ash, Midnight, Sage, Coyote]
SKU: PED-LEASH
Model: L-BL-3, L-AS-3, L-SG-3, L-MN-3, L-CY-3
Condition: New-In-Box
-
[Black, Sage, Midnight]
Sizes: PED-00600, PED-00601, PED-00602
SKU: PED-TRAVEL BACKPACK 30L
Model: BTR-30-BK-1, BTR-30-SG-1, BTR-30-MN-1
Condition: New-In-Box
-
SKU: PED-01500
Model: TT-CB-5-150-AL-1
Condition: New-In-Box
-
SKU: PED-01505
Model: TT-CB-5-150-CF-1
Condition: New-In-Box