Video Lighting

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 (593081, 588024, 578425, 535672, 535671, 533852, 533849, 533848, 533847, 71060, 17601, 17603, 17654, 17816, 18314, 18684, 19612, 20613, 20682, 20683, 23320, 39155, 77953, 89140, 91598, 200397, 200401, 200403, 204196, 227045)) 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,593081,588024,578425,535672,535671,533852,533849,533848,533847,71060,17601,17603,17654,17816,18314,18684,19612,20613,20682,20683,23320,39155,77953,89140,91598,200397,200401,200403,204196,227045)
View as Grid List

Items 1-30 of 114

Page
per page
Set Ascending Direction
  1. FS-150B Bi-Color AC LED Monolight
    Nanlite FS-150B Bi-Color AC LED Monolight
    USD $259.00
    SKU: NLT-FS150B
    Model: FS150B
    Condition: New-In-Box
  2. Pro SD300B Bi-Color LED Monolight
    GVM-LED Pro SD300B Bi-Color LED Monolight
    USD $389.00
    Out of stock
    SKU: GVM-PRO-SD300B
    Model: GVM-PRO-SD300B
    Condition: New-In-Box
  3. Ultrasoft US1014RGB RGBWW LED Light 10"x14"
    Promaster Ultrasoft US1014RGB RGBWW LED Light 10"x14"
    USD $249.95
    Out of stock
    SKU: PRO-67424
    Model: 67424
    Condition: New-In-Box
  4. 800D-RGB LED Light Panel (3-Light Kit)
    GVM-LED 800D-RGB LED Light Panel (3-Light Kit)
    USD $359.00
    SKU: GVM-800D-RGB-3L
    Model: 800D-RGB-3L
    Condition: New-In-Box
  5. 800D-RGB LED Light Panel (2-Light Kit)
    GVM-LED 800D-RGB LED Light Panel (2-Light Kit)
    USD $249.00
    Out of stock
    SKU: GVM-800D-RGB-2L
    Model: 800D-RGB-2L
    Condition: New-In-Box
  6. SD300D 300W LED Video Light
    GVM-LED SD300D 300W LED Video Light
    USD $499.00
    Out of stock
    SKU: GVM-SD300D
    Model: GVM-SD300D
    Condition: New-In-Box
  7. SD200D Bi-Color LED Video Spotlight Kit with Lantern Softbox
    SKU: GVM-SD200D-SET2
    Model: GVM-SD200D-SET2
    Condition: New-In-Box
  8. SD200D Bi-Color LED Video Spotlight
    GVM-LED SD200D Bi-Color LED Video Spotlight
    USD $299.00
    Out of stock
    SKU: GVM-SD200D
    Model: GVM-SD200D
    Condition: New-In-Box
  9. SD200S 200W LED Video Monolight
    GVM-LED SD200S 200W LED Video Monolight
    USD $269.00
    Out of stock
    SKU: GVM-SD200S
    Model: GVM-SD200S
    Condition: New-In-Box
  10. Surface Mount Technology LED Light 210 lux dimmable
    SKU: MAN-02499A
    Model: MLUMIEPL-BK
    Condition: New-In-Box
  11. CoolLED 200 LED Studio Light
    Dot Line Corp CoolLED 200 LED Studio Light
    USD $449.95
    Out of stock
    SKU: DOT-02588
    Model: RS-5620
    Condition: New-In-Box
  12. CooLED 50
    Dot Line Corp CooLED 50
    USD $199.00
    Out of stock
    SKU: DOT-02586
    Model: RS-5530
    Condition: New-In-Box
  13. Promaster LED80VT Camera/Camcorder Light
    USD $99.99
    Out of stock
    SKU: PRO-54115
    Model: 6483
    Condition: New-In-Box
  14. LG-1 LED Light Guide
    Olympus LG-1 LED Light Guide
    USD $40.99
    SKU: OLY-11600
    Model: V3271200W000
    Condition: New-In-Box
  15. FP-180 Bi-Colored LED On Camera and Studio Lighting
    SKU: TEC-00448
    Model: FP-180
    Condition: New-In-Box
  16. Promaster LED120SS Super Slim Rechargeable LED Light
    USD $99.95
    Out of stock
    SKU: PRO-54117A
    Model: 8289
    Condition: New-In-Box
  17. CooLED 20
    Dot Line Corp CooLED 20
    USD $179.99
    Out of stock
    SKU: DOT-01219
    Model: RS-5410
    Condition: New-In-Box
  18. Litepanels 1x1 Mono Daylight Flood
    USD $1,346.00
    Out of stock
    SKU: LIT-00141
    Model: 903-1006
    Condition: New-In-Box
  19. Litepanels 1x1 Mono Daylight Spot
    USD $1,346.00
    Out of stock
    SKU: LIT-00142
    Model: 903-1007
    Condition: New-In-Box
  20. Litepanels Sola 4
    USD $999.00
    Out of stock
    SKU: LIT-00162
    Model: 906-4004
    Condition: New-In-Box
  21. LUMIMUSE 8 Series Muse LED Light
    Manfrotto LUMIMUSE 8 Series Muse LED Light
    USD $104.99
    Out of stock
    SKU: MAN-02499B
    Model: MLUMIEMU-BK
    Condition: New-In-Box
  22. MFIC-PTL Dimmer Mini-Fill on Camera Light with 5000K LED Lamp and PT Connector
    SKU: TEC-00635
    Model: FRZ-MFIC-PTL
    Condition: New-In-Box
  23. V1000 LED Light
    Smith Victor Corporation V1000 LED Light
    USD $119.99
    Out of stock
    SKU: SMV-401600
    Model: 401600
    Condition: New-In-Box
  24. Mosaic2 Daylight LED Panel
    Limelight Mosaic2 Daylight LED Panel
    USD $839.99
    Out of stock
    SKU: LIM-01002
    Model: VB-1002
    Condition: New-In-Box
  25. Croma 2 LED Light
    Litepanels Croma 2 LED Light
    USD $451.25
    Out of stock
    SKU: LIT-00144
    Model: MLCROMA2
    Condition: New-In-Box
  26. LitraPro
    Litra LitraPro
    USD $219.95
    Out of stock
    SKU: LITR-LP1200
    Model: LP1200
    Condition: New-In-Box
  27. Onyx 30W Bi-Color 2-Point LED Light Kit with x 2 OYB240
    SKU: IKAN-00140
    Model: OYB240-2PT-KIT
    Condition: New-In-Box
  28. 15W Bi-Color 3200K-5600K Aluminum On-Camera LED Light
    SKU: IKAN-00144
    Model: OYB120
    Condition: New-In-Box
  29. Mobile LED light
    Promaster Mobile LED light
    USD $29.95
    Out of stock
    SKU: PRO-54109
    Model: 8471
    Condition: New-In-Box
  30. SL60W LED Daylight Balanced Video Light
    Godox SL60W LED Daylight Balanced Video Light
    USD $349.00
    Out of stock
    SKU: DOX-1226
    Model: SLB60W
    Condition: New-In-Box
View as Grid List

Items 1-30 of 114

Page
per page
Set Ascending Direction