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 (386998, 389648, 389773, 393323, 393325, 393327, 393332, 393335, 393339, 393342, 393344, 327987, 334518, 337439, 338139, 338143, 338144, 338145, 338146, 338147, 338191, 338192, 338193, 338773, 348957, 348960, 348962, 360282, 361226, 361233)) 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,386998,389648,389773,393323,393325,393327,393332,393335,393339,393342,393344,327987,334518,337439,338139,338143,338144,338145,338146,338147,338191,338192,338193,338773,348957,348960,348962,360282,361226,361233)
View as Grid List

Items 91-120 of 303

per page
Set Ascending Direction
  1. INSTAX Wide Monochrome Film (10 Exposures)
    Fujifilm INSTAX Wide Monochrome Film (10 Exposures)
    USD $15.99
    SKU: FUJ-10008
    Model: 9071
    Condition: New-In-Box
  2. Daily Color 35mm - ISO 400 (27 Exposures)
    dubble film Daily Color 35mm - ISO 400 (27 Exposures)
    USD $14.99
    Out of stock
    SKU: DUB-DAILYCOLOR
    Model: DFDCO1
    Condition: New-In-Box
  3. Color 600 Film (Round Frame Edition)
    Polaroid Color 600 Film (Round Frame Edition)
    USD $21.99
    SKU: POL-004672
    Model: PRD6021
    Condition: New-In-Box
  4. APOLLO 400 - 35mm (36 Exposures)
    dubble film APOLLO 400 - 35mm (36 Exposures)
    USD $19.99
    SKU: DUB-APOLLO400
    Model: DFRAPO400
    Condition: New-In-Box
  5. JELLY 200 - 35mm (36 Exposures)
    dubble film JELLY 200 - 35mm (36 Exposures)
    USD $18.99
    SKU: DUB-JELLY200
    Model: DFRJEL1
    Condition: New-In-Box
  6. JELLY 400 - 35mm (36 Exposures)
    dubble film JELLY 400 - 35mm (36 Exposures)
    USD $19.99
    SKU: DUB-JELLY400
    Model: DFRJEL400
    Condition: New-In-Box
  7. SOLAR 200 - 35mm (36 Exposures)
    dubble film SOLAR 200 - 35mm (36 Exposures)
    USD $18.99
    SKU: DUB-SOLOAR200
    Model: DFRSOL1
    Condition: New-In-Box
  8. SOLAR 400 - 35mm (36 Exposures)
    dubble film SOLAR 400 - 35mm (36 Exposures)
    USD $19.99
    SKU: DUB-SOLAR400
    Model: DFRSOL400
    Condition: New-In-Box
  9. STEREO 400 - ISO 400 - 35mm (36 Exposures)
    dubble film STEREO 400 - ISO 400 - 35mm (36 Exposures)
    USD $19.99
    SKU: DUB-STEREO400
    Model: DFRSTE400
    Condition: New-In-Box
  10. BUBBLEGUM 200 - 35mm (36 Exposures)
    dubble film BUBBLEGUM 200 - 35mm (36 Exposures)
    USD $18.99
    SKU: DUB-BUBBLEGUM200
    Model: DFRBUB1
    Condition: New-In-Box
  11. BUBBLEGUM 400 - 35mm (36 Exposures)
    dubble film BUBBLEGUM 400 - 35mm (36 Exposures)
    USD $19.99
    SKU: DUB-BUBBLEGUM400
    Model: DFRBUB400
    Condition: New-In-Box
  12. Pro Image 100 C41 Color ISO 100 Negative Film (35mm) (36 exp)
    SKU: KOD-6034466S
    Model: 6034466
    Condition: New-In-Box
  13. 620 Basic Film B+W - ISO 100
    Film Photography Project 620 Basic Film B+W - ISO 100
    USD $14.99
    Out of stock
    SKU: FPP-620 FILM B&W
    Model: FPP1306
    Condition: New-In-Box
  14. Multigrade 5 RC Deluxe Pearl (8x10″) (25 sheets) and 2x Rolls of HP5 Plus Film Value Pack
    SKU: ILF-1180684
    Model: 1180684
    Condition: New-In-Box
  15. DF96 “Developer's Fix” B&W Monobath Single Step Solution Powder (1L)
    SKU: CINE-10210P
    Model: 10210P
    Condition: New-In-Box
  16. CS41 Color Stabilizer Final Rinse Bath (2oz)
    CineStill CS41 Color Stabilizer Final Rinse Bath (2oz)
    USD $3.99
    Out of stock
    SKU: CINE-01201
    Model: 045 01201
    Condition: New-In-Box
  17. CS41 Color Simplified 2-Bath Kit (Quart)
    CineStill CS41 Color Simplified 2-Bath Kit (Quart)
    USD $32.99
    SKU: CINE-101221
    Model: 101221
    Condition: New-In-Box
  18. CS41 Color Simplified 2-Bath Kit for Color Negative Film (1000ml)
    SKU: CINE-101231
    Model: 101231
    Condition: New-In-Box
  19. D6 DAYLIGHTCHROME 1st Developer Bath (1000ml)
    CineStill D6 DAYLIGHTCHROME 1st Developer Bath (1000ml)
    USD $14.99
    Out of stock
    SKU: CINE-10131
    Model: 10131
    Condition: New-In-Box
  20. 50D Fine Grain Daylight ISO 50 Color Film (120)
    CineStill 50D Fine Grain Daylight ISO 50 Color Film (120)
    USD $17.49
    SKU: CINE-50D120
    Model: 1179273
    Condition: New-In-Box
  21. 50D Fine Grain Daylight ISO 50 Color Film (35mm) (36 exp)
    SKU: CINE-50D36EXP
    Model: 1179264
    Condition: New-In-Box
  22. 800T High Speed Tungsten ISO 800 Color Film (120)
    SKU: CINE-800T120
    Model: 1179291
    Condition: New-In-Box
  23. 800T High Speed Tungsten ISO 800 Color Film (35mm) (36 exp)
    SKU: CINE-800T36EXP
    Model: 1179282
    Condition: New-In-Box
  24. BwXX (double-x)  ISO 250 Black & White Film (35mm) (36 exp)
    SKU: CINE-BWXX26
    Model: CINEBWXX36EXP
    Condition: New-In-Box
  25. Measuring Graduate (1200mL/42oz)
    Paterson Measuring Graduate (1200mL/42oz)
    USD $19.99
    SKU: PAT-PTP305
    Model: PTP305
    Condition: New-In-Box
  26. Funnel (4.25" / 11cm)
    Paterson Funnel (4.25" / 11cm)
    USD $9.99
    SKU: PAT-PTP306
    Model: PTP306
    Condition: New-In-Box
  27. Film Clip Set
    Paterson Film Clip Set
    USD $16.99
    SKU: PAT-PTP218
    Model: PTP218
    Condition: New-In-Box
  28. Changing Bag
    Paterson Changing Bag
    USD $30.89
    SKU: PAT-PTP125
    Model: PTP125
    Condition: New-In-Box
  29. 460nm Color Negative ISO 200 (35mm) (36 exp)
    Revolog 460nm Color Negative ISO 200 (35mm) (36 exp)
    USD $16.99
    Out of stock
    SKU: REV-460NM
    Model: 460NM
    Condition: New-In-Box
  30. 60nm Color Negative ISO 200 (35mm) (36 exp)
    Revolog 60nm Color Negative ISO 200 (35mm) (36 exp)
    USD $16.99
    Out of stock
    SKU: REV-600NM
    Model: 600NM
    Condition: New-In-Box
View as Grid List

Items 91-120 of 303

per page
Set Ascending Direction