Leica

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 (17336, 17523, 17524, 17526, 17527, 21308, 21309, 21310, 21744, 21752, 21754, 21780, 21781, 21782, 21784, 21789, 21956, 23902, 24568, 25639, 25641, 26067, 38562, 38563, 38564, 41643, 82854, 97847, 97848, 97849)) 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,17336,17523,17524,17526,17527,21308,21309,21310,21744,21752,21754,21780,21781,21782,21784,21789,21956,23902,24568,25639,25641,26067,38562,38563,38564,41643,82854,97847,97848,97849)
View as Grid List

Items 121-150 of 189

per page
Set Ascending Direction
  1. Leica APO-TELYT-M Manual Focus 135mm f/3.4
    USD $4,595.00
    Out of stock
    SKU: LEI-30290
    Model: 11889
    Condition: New-In-Box
    Mount Type: Leica M
  2. T [TYP 701] (Black)
    Leica T [TYP 701] (Black)
    USD $1,629.00
    Out of stock
    SKU: LEI-30600
    Model: 18180
    Condition: New-In-Box
    Mount Type: Leica T
  3. T [TYP 701] (Silver)
    Leica T [TYP 701] (Silver)
    USD $1,629.00
    Out of stock
    SKU: LEI-30602
    Model: 18181
    Condition: New-In-Box
    Mount Type: Leica T
  4. Summicron-TL 23 mm f/2 ASPH
    Leica Summicron-TL 23 mm f/2 ASPH
    USD $2,195.00
    Out of stock
    SKU: LEI-30750
    Model: 11081
    Condition: New-In-Box
    Mount Type: Leica T
  5. Vario-Elmar-TL 18-56 mm f/3.5–5.6 ASPH
    Leica Vario-Elmar-TL 18-56 mm f/3.5–5.6 ASPH
    USD $1,995.00
    Out of stock
    SKU: LEI-30740
    Model: 11080
    Condition: New-In-Box
    Mount Type: Leica T
  6. Leica Ever Ready Small Case (Cognac)
    USD $450.00
    Out of stock
    SKU: LEI-30402
    Model: 14549
    Condition: New-In-Box
  7. Ever Ready Large Case  (Cognac)
    Leica Ever Ready Large Case (Cognac)
    USD $450.00
    Out of stock
    SKU: LEI-30404
    Model: 14550
    Condition: New-In-Box
  8. Multifunctional Handgrip M
    Leica Multifunctional Handgrip M
    USD $895.00
    Out of stock
    SKU: LEI-30406
    Model: 14495
    Condition: New-In-Box
  9. Lens not included
    SKU: LEI-30162
    Model: 10772
    Condition: New-In-Box
  10. Lens not included
    SKU: LEI-30163
    Model: 10773
    Condition: New-In-Box
  11. 8x42 Ultravid HD+ Binocular
    Leica 8x42 Ultravid HD+ Binocular
    USD $2,399.00
    Out of stock
    SKU: LEI-80129
    Model: 40093
    Condition: New-In-Box
  12. Leica Summilux-M 35mm f/1.4 ASPH (Silver)
    USD $6,195.00
    Out of stock
    SKU: LEI-30240
    Model: 11675
    Condition: New-In-Box
    Mount Type: Leica M
  13. Summarit-M 35mm f/2.4 ASPH Lens (Black)
    Leica Summarit-M 35mm f/2.4 ASPH Lens (Black)
    USD $2,495.00
    Out of stock
    SKU: LEI-30247N
    Model: 11671
    Condition: New-In-Box
    Mount Type: Leica M
  14. Summarit-M 35mm f/2.4 ASPH Lens (Silver)
    Leica Summarit-M 35mm f/2.4 ASPH Lens (Silver)
    USD $2,195.00
    Out of stock
    SKU: LEI-30247S
    Model: 11679
    Condition: New-In-Box
    Mount Type: Leica M
  15. 50mm f/0.95 Noctilux-M ASPH Lens (Silver)
    Leica 50mm f/0.95 Noctilux-M ASPH Lens (Silver)
    USD $13,095.00
    Out of stock
    SKU: LEI-30255
    Model: 11667
    Condition: New-In-Box
    Mount Type: Leica M
  16. Leica Summicron-M 50mm f/2 Manual Focus Lens [E39]
    USD $2,895.00
    Out of stock
    SKU: LEI-30260
    Model: 11826
    Condition: New-In-Box
    Mount Type: Leica M
  17. Camera not included
    SKU: LEI-29990
    Model: 14872
    Condition: New-In-Box
  18. BP-SCL2 Li-ion Battery
    Leica BP-SCL2 Li-ion Battery
    USD $215.00
    Out of stock
    SKU: LEI-30322
    Model: 14499
    Condition: New-In-Box
  19. SUMMILUX-M 28mm f/1.4 ASPH Lens
    Leica SUMMILUX-M 28mm f/1.4 ASPH Lens
    USD $7,795.00
    Out of stock
    SKU: LEI-30233
    Model: 11668
    Condition: New-In-Box
    Mount Type: Leica M
  20. Leica Visoflex [Typ 020] (Black)
    USD $660.00
    Out of stock
    SKU: LEI-30802
    Model: 18767
    Condition: New-In-Box
  21. BP-DC13 Li-Ion Battery (Black)
    Leica BP-DC13 Li-Ion Battery (Black)
    USD $110.00
    Out of stock
    SKU: LEI-30850
    Model: 18773
    Condition: New-In-Box
  22. Q [TYP 116] (Black)
    Leica Q [TYP 116] (Black)
    USD $4,495.00
    Out of stock
    SKU: LEI-30720
    Model: 19000
    Condition: New-In-Box
  23. SL [Typ 601] (Body Only)
    Leica SL [Typ 601] (Body Only)
    USD $5,995.00
    Out of stock
    SKU: LEI-20010
    Model: 10850
    Condition: New-In-Box
    Mount Type: L Mount
  24. Vario-Elmarit-SL 24-90mm f/2.8-4 ASPH
    Leica Vario-Elmarit-SL 24-90mm f/2.8-4 ASPH
    USD $5,795.00
    Out of stock
    SKU: LEI-30230
    Model: 11176
    Condition: New-In-Box
    Mount Type: L Mount
  25. APO Vario-Emarit-SL 90-280mm f/2.8-4
    Leica APO Vario-Emarit-SL 90-280mm f/2.8-4
    USD $7,295.00
    Out of stock
    SKU: LEI-20225
    Model: 11175
    Condition: New-In-Box
    Mount Type: L Mount
  26. M [Typ 262] Digital Rangefinder Camera (Body Only)
    SKU: LEI-30161
    Model: 10947
    Condition: New-In-Box
    Mount Type: Leica M
  27. Summilux-SL 50mm f/1.4 ASPH
    Leica Summilux-SL 50mm f/1.4 ASPH
    USD $6,595.00
    Out of stock
    SKU: LEI-30257
    Model: 11180
    Condition: New-In-Box
    Mount Type: L Mount
  28. Thread Adapter
    Leica Thread Adapter
    USD $110.00
    Out of stock
    SKU: LEI-30172
    Model: 24001
    Condition: New-In-Box
  29. Battery Charger BC-SCL 5
    Leica Battery Charger BC-SCL 5
    USD $180.00
    Out of stock
    SKU: LEI-30173
    Model: 24002
    Condition: New-In-Box
  30. Lithium-Ion Battery BP-SCL5
    Leica Lithium-Ion Battery BP-SCL5
    USD $200.00
    Out of stock
    SKU: LEI-30174
    Model: 24003
    Condition: New-In-Box
View as Grid List

Items 121-150 of 189

per page
Set Ascending Direction