Potter Strobes

Sort by:

Sorting

Best Selling

On Sale

select p.products_image, p.products_image_med, p.products_model, p.products_quantity, p.products_date_available, p.products_date_order_due, m.manufacturers_id, p.products_parent_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.vendors_prod_id, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products AS p INNER JOIN products_to_groups pg ON pg.products_id = p.products_id AND pg.group_code = 'G' INNER JOIN products_to_products_extra_fields AS p2pef ON p2pef.products_id = p.products_id INNER JOIN products_extra_fields AS pef ON p2pef.products_extra_fields_id = pef.products_extra_fields_id AND pef.products_extra_fields_status = 1 AND pef.products_extra_fields_facet = 1 AND pef.languages_id IN (0, 1) INNER JOIN products_to_categories AS ptc ON ptc.products_id = p.products_id left join products_description pd on p.products_id = pd.products_id AND pd.language_id = 1 left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on (s.products_id = p.products_id and s.status = 1) LEFT JOIN ( SELECT DISTINCT products_id, 1 AS is_featured_match FROM featured WHERE status = 1 AND featured_group_id = 6 AND f_categories_id = '1' ) feat ON feat.products_id = p.products_id WHERE p.is_active = 1 AND ptc.categories_id = '243' AND p.manufacturers_id = '5023'AND p.products_id IN ( SELECT ptpef1.products_id FROM products_to_products_extra_fields ptpef1 INNER JOIN products p2 ON p2.products_id = ptpef1.products_id LEFT JOIN products_description pd2 ON p2.products_id = pd2.products_id AND pd2.language_id = 1 LEFT JOIN manufacturers m2 ON p2.manufacturers_id = m2.manufacturers_id WHERE (ptpef1.products_extra_fields_id = 8 AND ptpef1.products_extra_fields_value = '16 - 33 VDC') GROUP BY ptpef1.products_id HAVING count(DISTINCT ptpef1.products_extra_fields_id) = 1 ) group by p.products_id ORDER BY CASE WHEN feat.is_featured_match = 1 THEN 0 ELSE 1 END, p.products_sort_order, p.products_date_available DESC, p.products_last_views DESC, pd.products_name

There are no products to list in this category.

Potter Strobes

Sorting

Need help finding a product? We'd like to know!

Contact information:

Our dedicated Silmar Team will contact you with information about your request. Thanks!

About Us

Customer Care

Our Policies

How do you want to process the order?
Pickup from Local Warehouse Ship from Miami via UPS

Language:
English Spanish
Don't show again