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 (610608, 607348, 607347, 607340, 607336, 607333, 607331, 607324, 607320, 607317, 607316, 607314, 607305, 607303, 607288, 607287, 607286, 607283, 607282, 607280, 596914, 596899, 595657, 595090, 594978, 592910, 592877, 592660, 592575, 592467)) 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,610608,607348,607347,607340,607336,607333,607331,607324,607320,607317,607316,607314,607305,607303,607288,607287,607286,607283,607282,607280,596914,596899,595657,595090,594978,592910,592877,592660,592575,592467)
View as Grid List

Items 1-30 of 299

Page
per page
Set Ascending Direction
  1. Quick Pic
    Flic Film Quick Pic
    USD $9.99
    SKU: FLIC-00302
    Model: FF01493F
    Condition: New-In-Box
  2. Bulk Film Loader
    Flic Film Bulk Film Loader
    USD $59.00
    SKU: FLIC-00082
    Model: FF00830F
    Condition: New-In-Box
  3. ECN-2 Home Processing Kit for 8 Rolls (0.5L)
    Flic Film ECN-2 Home Processing Kit for 8 Rolls (0.5L)
    USD $25.88
    SKU: FLIC-00272
    Model: FF38080C
    Condition: New-In-Box
  4. 3 Bath Dry Chemical C-41 Kit for 8 Rolls (500mL)
    SKU: FLIC-00270
    Model: FF00571C
    Condition: New-In-Box
  5.  Sepia Toner (Low Odor)
    Flic Film Sepia Toner (Low Odor)
    USD $20.17
    SKU: FLIC-00264
    Model: FF00694B
    Condition: New-In-Box
  6. Copper Toner
    Flic Film Copper Toner
    USD $17.47
    SKU: FLIC-00262
    Model: FF00687B
    Condition: New-In-Box
  7. Blue Toner
    Flic Film Blue Toner
    USD $17.47
    SKU: FLIC-00260
    Model: FF00670B
    Condition: New-In-Box
  8. Hypo-Check
    Flic Film Hypo-Check
    USD $10.19
    SKU: FLIC-00248
    Model: FF00656B
    Condition: New-In-Box
  9. Hypo-Clearing Agent (1L)
    Flic Film Hypo-Clearing Agent (1L)
    USD $8.99
    SKU: FLIC-00244
    Model: FF00052B
    Condition: New-In-Box
  10. Slick-200 Wetting Agent (250mL)
    Flic Film Slick-200 Wetting Agent (250mL)
    USD $9.39
    Out of stock
    SKU: FLIC-00240
    Model: FF38561B
    Condition: New-In-Box
  11. Allergen Free Fixer (1L)
    Flic Film Allergen Free Fixer (1L)
    USD $9.30
    SKU: FLIC-00236
    Model: FF00526B
    Condition: New-In-Box
  12. Quick Fixer (1L)
    Flic Film Quick Fixer (1L)
    USD $14.32
    SKU: FLIC-00228
    Model: FF38196B
    Condition: New-In-Box
  13.  Classic MQ Black & White Developer (1L)
    Flic Film Classic MQ Black & White Developer (1L)
    USD $8.88
    SKU: FLIC-00220
    Model: FF38110B
    Condition: New-In-Box
  14. Cyanotype Printing Kit
    Flic Film Cyanotype Printing Kit
    USD $26.00
    SKU: FLIC-00214
    Model: FF01158A
    Condition: New-In-Box
  15. Cyanotype Transparency Film (20 Sheets)
    Flic Film Cyanotype Transparency Film (20 Sheets)
    USD $17.29
    SKU: FLIC-00212
    Model: FF00823A
    Condition: New-In-Box
  16. Tannic Acid Toner (50g)
    Flic Film Tannic Acid Toner (50g)
    USD $9.99
    SKU: FLIC-00210
    Model: FF00786A
    Condition: New-In-Box
  17. Cyanotype Paper (A4, 30 Sheets)
    Flic Film Cyanotype Paper (A4, 30 Sheets)
    USD $13.69
    SKU: FLIC-00208
    Model: FF38950A
    Condition: New-In-Box
  18. Cyanotype Bleach
    Flic Film Cyanotype Bleach
    USD $6.55
    Out of stock
    SKU: FLIC-00206
    Model: FF38424A
    Condition: New-In-Box
  19. Cyanotype  8 Liter Kit
    Flic Film Cyanotype 8 Liter Kit
    USD $247.52
    SKU: FLIC-00204
    Model: FF00298A
    Condition: New-In-Box
  20. Cyanotype 400ml Kit
    Flic Film Cyanotype 400ml Kit
    USD $18.05
    Out of stock
    SKU: FLIC-00202
    Model: FF00076A
    Condition: New-In-Box
  21. LomoChrome Color '92 Film - ISO 400
    Lomography LomoChrome Color '92 Film - ISO 400
    USD $11.90
    Your Choice Of: 35mm, 120
    SKU: LomoChrome Color '92 Film - ISO 400
    Model: f436color, f4120color
    Condition: New-In-Box
  22. 2021 LomoChrome Turquoise Color Film - ISO 100-400 Your Choice Of: 35mm, 120
    SKU: LOM-TURQUOISE 2021
    Model: F136TQ1, F1120TQ1
    Condition: New-In-Box
  23. Phoenix 200 Color Film (35mm) (36 Exposures)
    HARMAN PHOTO Phoenix 200 Color Film (35mm) (36 Exposures)
    USD $13.99
    SKU: ILF-1182094
    Model: 1182094
    Condition: New-In-Box
  24. Neopan 100 Acros II Black and White ISO 100 Film Your Choice Of: 35mm, 120
    SKU: FUJ-NEOPAN 100
    Model: 16648282, 16648294
    Condition: New-In-Box
  25. FUJICHROME Velvia 50 Color Slide ISO 50 Film Your Choice Of: 35mm, 120
    SKU: FUJ-VELVIA 50
    Model: 16329161, 16329185, 16329185-1
    Condition: New-In-Box
  26. Portra 800 Color ISO 800 Negative Film
    Kodak Portra 800 Color ISO 800 Negative Film
    USD $18.99
    Your Choice Of: 35mm, 120
    SKU: KOD-PORTRA 800
    Model: 1451855, 8127946
    Condition: New-In-Box
  27. Professional Tri-X 400 Black and White ISO 400 Film Your Choice Of: 35mm, 120
    SKU: KOD-TRI-X 400
    Model: 1590652, 1153659, 1153659-1
    Condition: New-In-Box
  28. T-MAX 400 Black and White Film - ISO 400 (35mm) Your Choice Of: 24 Exposures, 36 Exposures
    SKU: KOD-T-MAX 400
    Model: 8947947, 8521114
    Condition: New-In-Box
  29. DELTA 400 PROFESSIONAL Black and White ISO 400 Film (Bulk) (100ft)
    SKU: ILF-01126
    Model: 1765829
    Condition: New-In-Box
  30. 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
View as Grid List

Items 1-30 of 299

Page
per page
Set Ascending Direction