Roberts and UsedPhotoPro will be closed Monday December 25th. Online orders may still be placed but won't process to ship until we open again at 9am December 26th.
Get the perfect light quality for your shoot from a range of over 70 Rosco gels, a dozen California Sunbounce reflectors, and diffusers up to 144 square feet in size for the ultimate in soft natural light. If mixed lighting sources are ruining your images, then a lighting modifier will come to the rescue. Change the mood to suit your needs, or simply attenuate bright lights with an ND gel – whatever your requirements may be you can be sure Roberts Camera stocks the right gel for you.
The perfect light is just a click away with our large range of light modifiers. From grids, barn doors, reflectors and softboxes, to gels and diffusers, they are all an important part of any visual production – begin molding the light with a product from our range below.
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 (91049, 91050, 91051, 91055, 109698)) 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,91049,91050,91051,91055,109698)