Continuous 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 (593101, 593100, 593098, 578431, 578430, 578428, 553139, 545725, 545340, 545339, 539114, 539112, 533869, 533865, 533841, 533790, 533785, 46519, 49575, 49583, 55438, 55439, 55440, 55441, 55919, 71159, 77727, 77786, 17600, 17603)) 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,593101,593100,593098,578431,578430,578428,553139,545725,545340,545339,539114,539112,533869,533865,533841,533790,533785,46519,49575,49583,55438,55439,55440,55441,55919,71159,77727,77786,17600,17603)
View as Grid List

Items 1-30 of 292

Page
per page
Set Ascending Direction
  1.  PavoSlim 120C 2x1 RGBWW LED Panel Light with CRMX
    SKU: NLT-PS120C
    Model: PS120C
    Condition: New-In-Box
  2. PavoSlim 120B 2x1 Bi-Color LED Panel Light
    Nanlite PavoSlim 120B 2x1 Bi-Color LED Panel Light
    USD $599.00
    Out of stock
    SKU: NLT-PS120B
    Model: PS120B
    Condition: New-In-Box
  3. PavoSlim 60B 1x1 Bi-Color LED Panel Light
    Nanlite PavoSlim 60B 1x1 Bi-Color LED Panel Light
    USD $399.00
    Out of stock
    SKU: NLT-PS60B
    Model: PS60B
    Condition: New-In-Box
  4. Chroma CL36RGB LED Light v3
    Promaster Chroma CL36RGB LED Light v3
    USD $99.95
    Out of stock
    SKU: PRO-67872
    Model: 67872
    Condition: New-In-Box
  5. Chroma CL33RGB Connect LED Light 2.0
    Promaster Chroma CL33RGB Connect LED Light 2.0
    USD $49.95
    SKU: PRO-67865
    Model: 67865
    Condition: New-In-Box
  6. Ultrasoft US1014RGB 2-Light Transport Kit - RGBWW 10"x14"
    SKU: PRO-67431
    Model: 67431
    Condition: New-In-Box
  7. Bi-Color LED Studio Video Spotlight SD80D
    GVM-LED Bi-Color LED Studio Video Spotlight SD80D
    USD $159.00
    Out of stock
    SKU: GVM-SD80D
    Model: GVM-SD80D
    Condition: New-In-Box
  8. MOLUS X100 Pro Kit
    Zhiyun-Tech MOLUS X100 Pro Kit
    USD $349.00
    Out of stock
    SKU: ZHI-00264
    Model: ZHYX100PRO
    Condition: New-In-Box
  9. MOLUS G60 (Combo Kit)
    Zhiyun-Tech MOLUS G60 (Combo Kit)
    USD $199.00
    SKU: ZHI-00252
    Model: ZHY10G60CB
    Condition: New-In-Box
  10. MOLUS G60 (Standard Kit)
    Zhiyun-Tech MOLUS G60 (Standard Kit)
    USD $199.00
    Out of stock
    SKU: ZHI-00250
    Model: ZHY10G60
    Condition: New-In-Box
  11. Amaran 300c
    Aputure Amaran 300c
    USD $569.00
    SKU: APU-00501
    Model: AP30011A10
    Condition: New-In-Box
  12. Amaran 150c
    Aputure Amaran 150c
    USD $359.00
    Out of stock
    SKU: APU-00500
    Model: AP30010A10
    Condition: New-In-Box
  13. MC Pro 8-Light Kit
    Aputure MC Pro 8-Light Kit
    USD $1,899.00
    Out of stock
    SKU: APU-00153
    Model: APA0229A11
    Condition: New-In-Box
  14. MC Pro mini LED
    Aputure MC Pro mini LED
    USD $199.00
    SKU: APU-00151
    Model: APA0229A10
    Condition: New-In-Box
  15. YU200R Bi-Color Studio LED Panel
    GVM-LED YU200R Bi-Color Studio LED Panel
    USD $999.99
    Out of stock
    SKU: GVM-YU200R
    Model: GVM-YU200R
    Condition: New-In-Box
  16. Nuada Ring 40C LED Light Go Kit
    Phottix Nuada Ring 40C LED Light Go Kit
    USD $99.95
    SKU: PTX-PH81492
    Model: PH81492
    Condition: New-In-Box
  17. Solar BG Magic Light Kit Set
    Phottix Solar BG Magic Light Kit Set
    USD $69.95
    SKU: PTX-PH81300
    Model: PH81300
    Condition: New-In-Box
  18. Worklight
    Ansmann Worklight
    USD $19.97
    Out of stock
    SKU: ANS-00200
    Model: 1600-0063
    Condition: New-In-Box
  19. Light Wand
    Promaster Light Wand
    USD $299.95
    SKU: PRO-53550
    Model: 3659
    Condition: New-In-Box
  20. 500 Watt LED Studio Light Kit
    Savage 500 Watt LED Studio Light Kit
    USD $135.99
    Out of stock
    SKU: SAV-LED60K-CP
    Model: LED60K
    Condition: New-In-Box
  21. K302 Lighting Kit (3x-P360EX)
    Fiilex K302 Lighting Kit (3x-P360EX)
    USD $2,849.00
    Out of stock
    SKU: FLX-00302
    Model: FLXK302
    Condition: New-In-Box
  22. S282 Mini All-Weather Interview Kit (2x-P180E)
    Fiilex S282 Mini All-Weather Interview Kit (2x-P180E)
    USD $995.00
    Out of stock
    SKU: FLX-01210
    Model: FLXS282
    Condition: New-In-Box
  23. K411 Lighting Kit (2x-P360, 2x-P180E)
    Fiilex K411 Lighting Kit (2x-P360, 2x-P180E)
    USD $1,995.00
    Out of stock
    SKU: FLX-00411
    Model: FLXK411
    Condition: New-In-Box
  24. K202 All-Weather Two Light Interview Kit
    Fiilex K202 All-Weather Two Light Interview Kit
    USD $1,995.00
    Out of stock
    SKU: FLX-01202
    Model: FLXK202
    Condition: New-In-Box
  25. 2000 Watt Location Light Kit
    Savage 2000 Watt Location Light Kit
    USD $599.99
    Out of stock
    SKU: SAV-LED2000K
    Model: LED2000K
    Condition: New-In-Box
  26. KT800U 3-Lights 1250 Total Watt with Umbrellas Thrifty Advanced Kit
    Smith Victor Corporation KT800U 3-Lights 1250 Total Watt with Umbrellas Thrifty Advanced Kit
    USD $242.95
    Out of stock
    SKU: SMV-401434
    Model: 401434
    Condition: New-In-Box
  27. MobiLED Lamphead
    broncolor MobiLED Lamphead
    USD $1,672.95
    Out of stock
    SKU: BRN-3201300
    Model: B-32.013.00
    Condition: New-In-Box
  28. P180E On-Camera LED Light
    Fiilex P180E On-Camera LED Light
    USD $495.00
    Out of stock
    SKU: FLX-01250
    Model: FLXP180
    Condition: New-In-Box
  29. 15,000 Lumen LED with Variable Color Temp
    Dot Line Corp 15,000 Lumen LED with Variable Color Temp
    USD $599.95
    Out of stock
    SKU: DOT-02590
    Model: RS-5710
    Condition: New-In-Box
  30. CooLED 50
    Dot Line Corp CooLED 50
    USD $199.00
    Out of stock
    SKU: DOT-02586
    Model: RS-5530
    Condition: New-In-Box
View as Grid List

Items 1-30 of 292

Page
per page
Set Ascending Direction