Film & Home Development

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 (592575, 592467, 590670, 589544, 589308, 589278, 589233, 588799, 588798, 588569, 588532, 588524, 588512, 588509, 588379, 586771, 586767, 586351, 584852, 584850, 584761, 574353, 574227, 574224, 574108, 572078, 572077, 572061, 572006, 572005)) 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,592575,592467,590670,589544,589308,589278,589233,588799,588798,588569,588532,588524,588512,588509,588379,586771,586767,586351,584852,584850,584761,574353,574227,574224,574108,572078,572077,572061,572006,572005)
View as Grid List

Items 31-60 of 303

per page
Set Ascending Direction
  1. DELTA 400 PROFESSIONAL Black and White ISO 400 Film (Bulk) (100ft)
    SKU: ILF-01126
    Model: 1765829
    Condition: New-In-Box
  2. Portra 160 Color Film - ISO 160
    Kodak Portra 160 Color Film - ISO 160
    USD $14.99
    Your Choice Of: 35mm, 120
    SKU: KOD-PORTRA 160
    Model: 8120529, 1808674, 6031959-1, 6031959
    Condition: New-In-Box
  3. Measuring Graduate
    Paterson Measuring Graduate
    USD $6.95
    Sizes: 45ml, 150ml
    SKU: PAT-GRADUATE
    Model: PTP301, PTP302
    Condition: New-In-Box
  4. Redscale 35mm - ISO 25 (24 Exposures)
    Film Photography Project Redscale 35mm - ISO 25 (24 Exposures)
    USD $16.99
    SKU: FPP-1332
    Model: FPP1332
    Condition: New-In-Box
  5. Redscale XR Film - ISO 50-200
    Lomography Redscale XR Film - ISO 50-200
    USD $15.90
    Your Choice Of: 35mm, 120
    SKU: LOM-REDSCALE XR
    Model: F136XR3, F136XR3-SINGLE, F1120XR3, F1120XR3-SINGLE
    Condition: New-In-Box
  6. Color Negative Film - ISO 800
    Lomography Color Negative Film - ISO 800
    USD $13.90
    Your Choice Of: 35mm, 120
    SKU: LOM-COLOR NEGATIVE 800
    Model: F836C3, F836C3-SINGLE, F8120C3, F8120C3-SINGLE
    Condition: New-In-Box
  7. Color Negative Film - ISO 400
    Lomography Color Negative Film - ISO 400
    USD $13.90
    Your Choice Of: 35mm, 120
    SKU: LOM-COLOR NEGATIVE 400
    Model: F436C3, F436C3-SINGLE, F4120C3, F4120C3-SINGLE
    Condition: New-In-Box
  8. Film Container 120
    ars-imago Film Container 120
    USD $5.99
    Out of stock
    SKU: ARS-AV3005
    Model: AV3005
    Condition: New-In-Box
  9. Film Container 135
    ars-imago Film Container 135
    USD $5.99
    SKU: ARS-AV3006
    Model: AV3006
    Condition: New-In-Box
  10. Color Negative Film - ISO 100
    Lomography Color Negative Film - ISO 100
    USD $11.90
    Your Choice Of: 35mm, 120
    SKU: LOM-COLOR NEGATIVE 100
    Model: F3361, F3361-SINGLE, F1120C3, F1120C3-SINGLE
    Condition: New-In-Box
  11. Lady Gray Black & White Film - ISO 400
    Lomography Lady Gray Black & White Film - ISO 400
    USD $9.90
    Your Choice Of: 35mm, 120
    SKU: LOM-LADY GREY
    Model: F436BW3, F436BW3-SINGLE, F4120BW3, F4120BW3-SINGLE
    Condition: New-In-Box
  12. 2021 LomoChrome Purple Petillant Film - ISO 100-400 Your Choice Of: 35mm, 120
    SKU: LOM-PURPLE PETILLANT
    Model: F436LC21, F4120LC21
    Condition: New-In-Box
  13. Earl Gray B&W Film - ISO 100
    Lomography Earl Gray B&W Film - ISO 100
    USD $8.90
    Your Choice Of: 35mm, 120
    SKU: LOM-EARL GRAY
    Model: F136BW3, F136BW3-SINGLE, F1121BW3, F1121BW3-SINGLE
    Condition: New-In-Box
  14. Redscale XR Film - ISO 50-200 (35mm) (36 Exposures) Your Choice Of: 1 Roll, 3 Rolls
    SKU: Redscale XR Film - ISO 50-200 (35mm) (36 Exposures)
    Model: F136XR3, F136XR3-SINGLE
    Condition: New-In-Box
  15. Potsdam Kino Black & White Film - ISO 100
    Lomography Potsdam Kino Black & White Film - ISO 100
    USD $6.90
    Your Choice Of: 35mm, 120
    SKU: LOM-POTSDAM KINO 100 BW
    Model: F1120BWCINE, F1120BWCINE
    Condition: New-In-Box
  16. Infrared Black and White 35mm - ISO 200 (24 Exposures)
    Film Photography Project Infrared Black and White 35mm - ISO 200 (24 Exposures)
    USD $12.99
    SKU: FPP-1330
    Model: FPP1330
    Condition: New-In-Box
  17. Color - ISO 125 (35mm) (24 Exposures)
    Film Photography Project Color - ISO 125 (35mm) (24 Exposures)
    USD $14.99
    SKU: FPP-1331
    Model: FPP1331
    Condition: New-In-Box
  18. Gold 200 C41 ISO 200 Color Negative Film (120) Your Choice Of: 1 Roll, 5 Rolls
    SKU: KOD- GOLD 200 120
    Model: 1075597
    Condition: New-In-Box
  19. SOFORT Neo Gold Color Film Pack (10 Pack)
    Leica SOFORT Neo Gold Color Film Pack (10 Pack)
    USD $15.99
    SKU: LEI-19678
    Model: 19678
    Condition: New-In-Box
  20. SOFORT Warm White Color Film Pack (10 Pack)
    SKU: LEI-19677
    Model: 19677
    Condition: New-In-Box
  21. Gold 200 Color ISO 200 Negative Film (35mm) (36 exp) (3-Pack)
    SKU: KOD-11024A
    Model: 1880806
    Condition: New-In-Box
  22. Pan 400 - ISO 400 Black & White Film (35mm)
    Kentmere Pan 400 - ISO 400 Black & White Film (35mm)
    USD $6.21
    Your Choice Of: 24 Exposures, 36 Exposures, Bulk
    SKU: ILF-KENTMERE PAN 400 35MM
    Model: 6012379, 6010476, 6012599
    Condition: New-In-Box
  23. Professional T-MAX 100 Black and White ISO 100 Film (120)
    SKU: KOD-T-MAX 100 120
    Model: 8572273, 8572273S
    Condition: New-In-Box
  24. Professional T-MAX 100 Black and White ISO 100 Film (35mm) Your Choice Of: 24 Exposures, 36 Exposures
    SKU: KOD-T-MAX 100
    Model: 8532848, 8292443
    Condition: New-In-Box
  25. 100 Pan ISO 100 Black & White Film (35mm)
    Kentmere 100 Pan ISO 100 Black & White Film (35mm)
    USD $6.21
    Your Choice Of: 24 Exposures, 36 Exposures, Bulk
    SKU: ILF-KENTMERE 100
    Model: 6012368, 6010465, 6012588
    Condition: New-In-Box
  26. SFX 200 BLACK AND WHITE EXTENDED RED SENSITIVITY ISO 200 FILM
    SKU: ILF-SFX 200
    Model: 1829189, 1901029
    Condition: New-In-Box
  27. ColorPlus 200 Color Negative Film ISO 200 Film (35mm) (24 Exposures)
    SKU: KOD-6031470
    Model: 6031470
    Condition: New-In-Box
  28. Professional T-Max 400 Black & White Film - ISO 400 (120) (Single)
    SKU: KOD-13050
    Model: 143876
    Condition: New-In-Box
  29. Ektachrome E100 Color Transparency Film (35mm) (36 Exposures)
    SKU: KOD-11025
    Model: 1884576
    Condition: New-In-Box
  30. FUJICHROME Provia 100F ISO 100 RDP-III Color Transparency Film (35mm) (36 Exposures)
    SKU: FUJ-12055
    Model: 16326028
    Condition: New-In-Box
View as Grid List

Items 31-60 of 303

per page
Set Ascending Direction