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 (416631, 416760, 438645, 267606, 267607, 267611, 267614, 267615, 267616, 267617, 267619, 267628, 267629, 267630, 267632, 267633, 267636, 267637, 199670, 200994, 213243, 221745, 125270, 125271, 383810, 383834, 384777, 347527, 354039, 403996)) 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,416631,416760,438645,267606,267607,267611,267614,267615,267616,267617,267619,267628,267629,267630,267632,267633,267636,267637,199670,200994,213243,221745,125270,125271,383810,383834,384777,347527,354039,403996)
-
[Black, Ash, Midnight, Sage]
SKU: PED-SLIDELITE
Model: SLL-AS-3, SLL-MN-3, SLL-BK-3, SLL-SG-3
Condition: New-In-Box
-
Peak Design
Leash
USD $44.95
[Black, Ash, Midnight, Sage]
SKU: PED-LEASH
Model: L-BL-3, L-AS-3, L-SG-3, L-MN-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
-
SKU: PED-00462
Model: BEDBZ-15-MN-2
Condition: New-In-Box
-
SKU: PED-00483
Model: BEDB-20-AS-2
Condition: New-In-Box
-
SKU: PED-00484
Model: BEDB-20-MN-2
Condition: New-In-Box
-
SKU: PED-00495
Model: BEDB-30-BK-2
Condition: New-In-Box
-
SKU: PED-00496
Model: BEDB-30-CH-2
Condition: New-In-Box
-
SKU: PED-02032
Model: TT-SFS-5-150-1
Condition: New-In-Box
-
SKU: PED-00450
Model: BEDS-3-BK-2
Condition: New-In-Box
-
SKU: PED-00451
Model: BEDS-3-AS-2
Condition: New-In-Box
-
SKU: PED-00452
Model: BEDS-6-BK-2
Condition: New-In-Box
-
SKU: PED-00454
Model: BEDS-6-MN-2
Condition: New-In-Box
-
SKU: PED-00455
Model: BEDS-10-BK-2
Condition: New-In-Box
-
SKU: PED-00470
Model: BEDBZ-20-BK-2
Condition: New-In-Box
-
SKU: PED-00471
Model: BEDBZ-20-AS-2
Condition: New-In-Box
-
SKU: PED-00202
Model: BCC-M-BK-1
Condition: New-In-Box
-
SKU: PED-00153
Model: CL-3
Condition: New-In-Box
-
SKU: PED-00163
Model: AL-4
Condition: New-In-Box
-
SKU: PED-00167
Model: PL D-2
Condition: New-In-Box
-
SKU: PED-01000
Model: BP-BL-1
Condition: New-In-Box
-
SKU: PED-01001
Model: BP-BR-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:
Condition: New-In-Box
-
SKU: PED-LENS KIT
Model: LC-N-1, LC-C-1, LC-S-1
Condition: New-In-Box
Available For: Canon EF, Nikon F, Sony E/FE
-
[Black, Sage]
SKU: PED-TRAVEL BACKPACK
Model: BTR-45-BK, BTR-45-SG-1-1
Condition: New-In-Box
-
[Charcoal, Heritage Tan, Ash, Black]
SKU: PED-FIELD POUCH
Model: BP-BL-1, BP-BR-1, BP-AS-1, BP-BK-1
Condition: New-In-Box
-
[Black, Sage]
SKU: Travel Duffle 35L
Model: BTRD-35L-BLK, BTRD-35L-SAGE
Condition: New-In-Box