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.
Studio equipment essentials from green screens, lighting rails and stands, still-life tables and seamless backgrounds are available in the studio section below. A green screen backdrop will allow easy replacement of the background to make your subject appear in a location of your choice. Or, if you prefer, there are a range of printed backgrounds and backdrops in themes from storm clouds, bracken brown, sandstorm, plain white or a hundred others are available in from the studio section below.
Also take your pick of the bits and pieces that hold your studio together such as trolley castor wheels, screws, hex studs, fuses, collars and light bulbs.
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 (618729, 616792, 608698, 588403, 573365, 565661, 555234, 549001, 540989, 12569, 12573, 12575, 12635, 12662, 12672, 12673, 12675, 12965, 13663, 13664, 13665, 11255, 11256, 11257, 11468, 11986, 11987, 12204, 3782, 3814)) 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,618729,616792,608698,588403,573365,565661,555234,549001,540989,12569,12573,12575,12635,12662,12672,12673,12675,12965,13663,13664,13665,11255,11256,11257,11468,11986,11987,12204,3782,3814)