Pelican

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 (12066, 12081, 5528, 5531, 5535, 5546, 5551, 3368, 3376, 3383, 3384, 9312, 54475, 62159, 20510, 11109, 12041, 12044, 12046, 12065, 12068, 12070, 12072, 12074, 12076, 12082, 12083, 12084, 12088, 12089)) 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,12066,12081,5528,5531,5535,5546,5551,3368,3376,3383,3384,9312,54475,62159,20510,11109,12041,12044,12046,12065,12068,12070,12072,12074,12076,12082,12083,12084,12088,12089)
View as Grid List

Items 1-30 of 129

Page
per page
Set Ascending Direction
  1. 6 Piece Replacement Foam Set
    Pelican 6 Piece Replacement Foam Set
    USD $152.95
    SKU: PEL-00054D
    Model: PC1621
    Condition: New-In-Box
  2. Pelican Lid Organizer for 1660 Case
    USD $86.95
    SKU: PEL-00059E
    Model: PC1669
    Condition: New-In-Box
  3. 1401 Foam Set
    Pelican 1401 Foam Set
    USD $47.95
    SKU: PEL-00013
    Model: PC1401
    Condition: New-In-Box
  4. 1510 Carry On Case with Foam
    Pelican 1510 Carry On Case with Foam
    USD $252.95
    SKU: PEL-00033A
    Model: PC1510B
    Condition: New-In-Box
  5. 1525 Padded Divider Set
    Pelican 1525 Padded Divider Set
    USD $153.95
    SKU: PEL-00036E
    Model: PC1525
    Condition: New-In-Box
  6. 1615 Padded Divider Set
    Pelican 1615 Padded Divider Set
    USD $219.95
    SKU: PEL-00053E
    Model: PC1615
    Condition: New-In-Box
  7. Pelican 1660 Black Case
    USD $497.95
    SKU: PEL-00059
    Model: 1660
    Condition: New-In-Box
  8. 1301 Replacement Foam
    Pelican 1301 Replacement Foam
    USD $34.95
    SKU: PEL-00009
    Model: 1301
    Condition: New-In-Box
  9. 1521 Replacement Foam
    Pelican 1521 Replacement Foam
    USD $84.95
    SKU: PEL-00035A
    Model: PC1521
    Condition: New-In-Box
  10. 1650 Black Case
    Pelican 1650 Black Case
    USD $378.95
    SKU: PEL-00055
    Model: PC1650B
    Condition: New-In-Box
  11. 1651 Replacement Foam
    Pelican 1651 Replacement Foam
    USD $166.95
    SKU: PEL-00056
    Model: PC1651
    Condition: New-In-Box
  12. Pick N Pluck Sections for 1610 Case
    Pelican Pick N Pluck Sections for 1610 Case
    USD $118.95
    SKU: PEL-00053J
    Model: PC1612
    Condition: New-In-Box
  13. Lid Organizer for 1600, 1610, and 1620 Cases
    Pelican Lid Organizer for 1600, 1610, and 1620 Cases
    USD $62.95
    SKU: PEL-00053B
    Model: PC1609
    Condition: New-In-Box
  14. 1485 Air Case without Foam (Black)
    Pelican 1485 Air Case without Foam (Black)
    USD $184.95
    SKU: PEL-01485NFB
    Model: PC1485NFB
    Condition: New-In-Box
  15. Lid Organizer for 1560 Case
    Pelican Lid Organizer for 1560 Case
    USD $61.95
    SKU: PEL-00046
    Model: PC1569
    Condition: New-In-Box
  16. Pelican 1075 HardBack Case with Foam
    USD $83.95
    Out of stock
    SKU: PEL-00002E
    Model: PC1075B
    Condition: New-In-Box
  17. Pelican 3 Piece Foam Set for 1750 Case
    USD $119.95
    Out of stock
    SKU: PEL-00060E
    Model: PC1751
    Condition: New-In-Box
  18. 1010 Micro Case (Black)
    Pelican 1010 Micro Case (Black)
    USD $21.95
    Out of stock
    SKU: PEL-00002
    Model: PC1010SB
    Condition: New-In-Box
  19. 1400 Case with Foam (Orange) [Color Not Shown]
    Pelican 1400 Case with Foam (Orange) [Color Not Shown]
    USD $119.95
    Out of stock
    SKU: PEL-00011OR
    Model: PC1400O
    Condition: New-In-Box
  20. Lid Organizer for 1654 Case
    Pelican Lid Organizer for 1654 Case
    USD $64.95
    Out of stock
    SKU: PEL-00057A
    Model: PC1659
    Condition: New-In-Box
  21. 4 Piece Replacement Foam Set
    Pelican 4 Piece Replacement Foam Set
    USD $71.95
    Out of stock
    SKU: PEL-00033B
    Model: PC1511
    Condition: New-In-Box
  22. PeliLock
    Pelican PeliLock
    USD $21.95
    Out of stock
    SKU: PEL-00028
    Model: PC1506TSA
    Condition: New-In-Box
  23. Versabrite III LED Photo Light
    Pelican Versabrite III LED Photo Light
    USD $25.99
    Out of stock
    SKU: PEL-00068
    Model: PC2220
    Condition: New-In-Box
  24. 1490CC1 Large Deluxe Notebook Computer Case
    Pelican 1490CC1 Large Deluxe Notebook Computer Case
    USD $297.95
    Out of stock
    SKU: PEL-00020A
    Model: PC1490CC1
    Condition: New-In-Box
  25. Pelican 1495 Laptop Case
    USD $237.95
    Out of stock
    SKU: PEL-00020C
    Model: PC1495B
    Condition: New-In-Box
  26. Pelican 1690 Transport Case (Black)
    USD $557.95
    Out of stock
    SKU: PEL-00059H
    Model: PC1690B
    Condition: New-In-Box
  27. Pelican Lid Organizer for 1690 Transport Case
    USD $91.95
    Out of stock
    SKU: PEL-00059M
    Model: PC1699
    Condition: New-In-Box
  28. 1450 Case (Orange)
    Pelican 1450 Case (Orange)
    USD $162.95
    Out of stock
    SKU: PEL-00015C
    Model: PC1450O
    Condition: New-In-Box
  29. Pelican 1430 Top Loader Case - No Foam (Black)
    USD $84.97
    Out of stock
    SKU: PEL-00014
    Model: PC1430NFB
    Condition: New-In-Box
  30. Lid Organizer for 1430 Case
    Pelican Lid Organizer for 1430 Case
    USD $26.95
    Out of stock
    SKU: PEL-00014A
    Model: PC1439
    Condition: New-In-Box
View as Grid List

Items 1-30 of 129

Page
per page
Set Ascending Direction