Gary Fong

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 (15038, 8773, 5463, 5464, 3260, 15813, 15814, 20838, 20839, 20840, 21141, 21995, 104313)) 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,15038,8773,5463,5464,3260,15813,15814,20838,20839,20840,21141,21995,104313)
View as Grid List

13 Items

per page
Set Ascending Direction
  1. Gary Fong Puffer for Sony/Minolta Flash
    USD $23.71
    Out of stock
    SKU: OME-00311
    Model: GFPUFSONY
    Condition: New-In-Box
  2. Gary Fong Light Sphere Universal Basic Kit
    USD $124.15
    Out of stock
    SKU: OME-00327
    Model: GFLSUBASIC
    Condition: New-In-Box
  3. Gary Fong Chromedome for Lightsphere II
    USD $53.95
    Out of stock
    SKU: OME-00316
    Model: CHRDOM
    Condition: New-In-Box
  4. LightSphere Collapsible
    Gary Fong LightSphere Collapsible
    USD $59.95
    Out of stock
    SKU: OME-00328
    Model: GFLSCSM
    Condition: New-In-Box
  5. AmberDome
    Gary Fong AmberDome
    USD $21.55
    Out of stock
    SKU: OME-00314
    Model: AMBDOM
    Condition: New-In-Box
  6. Gary Fong Gel Filter Set for LightSphere Collapsible
    USD $16.15
    Out of stock
    SKU: OME-00334
    Model: GFLSGELRYGB
    Condition: New-In-Box
  7. Lightsphere Collapsible Snoot with PowerGrid
    Gary Fong Lightsphere Collapsible Snoot with PowerGrid
    USD $64.75
    Out of stock
    SKU: OME-00336
    Model: GFLSCSNOOTG
    Condition: New-In-Box
  8. Gary Fong Puffer Plus Warming Shield
    USD $14.95
    Out of stock
    SKU: OME-00305
    Model: GFPUFPLUSWS
    Condition: New-In-Box
  9. Puffer Plus for Nikon/Pentax/Panasonic Lumix/Samsung
    SKU: OME-00306
    Model: GFPUFPLUS
    Condition: New-In-Box
  10. Puffer Plus for Sony/Konica Minolta
    Gary Fong Puffer Plus for Sony/Konica Minolta
    USD $20.47
    Out of stock
    SKU: OME-00308
    Model: GFPUFPLUSC
    Condition: New-In-Box
  11. Lightsphere Collapsible G5 Lighting Kit: Wedding and Event
    SKU: OME-00338
    Model: GFLSCSMWE
    Condition: New-In-Box
  12. Lightsphere Collapsible G5 Lighting Kit: Fashion and Commercial
    SKU: OME-00329
    Model: GFLSCSMFC
    Condition: New-In-Box
  13. Speed Snoot Collapsible
    Gary Fong Speed Snoot Collapsible
    USD $64.75
    Out of stock
    SKU: OME-00355
    Model: GFSSNOOT
    Condition: New-In-Box
View as Grid List

13 Items

per page
Set Ascending Direction