Adapters

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 (593040, 540996, 14146, 14221, 14597, 12980, 13493, 13495, 13496, 13866, 12172, 4017, 4865, 4866, 4867, 4868, 4994, 4998, 2681, 2682, 2703, 2707, 2708, 128, 1482, 367962, 367970, 367978, 385025, 389649)) 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,593040,540996,14146,14221,14597,12980,13493,13495,13496,13866,12172,4017,4865,4866,4867,4868,4994,4998,2681,2682,2703,2707,2708,128,1482,367962,367970,367978,385025,389649)
View as Grid List

Items 1-30 of 109

Page
per page
Set Ascending Direction
  1. PavoTube Transparent Polycarbonate Clip and Mini Ball Head
    SKU: NLT-HD-T12+BH
    Model: HD-T12+BH
    Condition: New-In-Box
  2. Paint Pole Adapter
    Westcott Paint Pole Adapter
    USD $24.90
    SKU: WES-4739
    Model: 4739
    Condition: New-In-Box
  3. AD91 Mounting Kit
    Photogenic AD91 Mounting Kit
    USD $215.00
    Out of stock
    SKU: PHG-956073
    Model: 956073
    Condition: New-In-Box
  4. Tilting Umbrella Adapter  with KG000912 and KG001112 Studs
    SKU: KUPO-KG007012
    Model: KG007012
    Condition: New-In-Box
  5. Adapter Spigot 3/8" + 1/4'
    Manfrotto Adapter Spigot 3/8" + 1/4'
    USD $9.99
    Out of stock
    SKU: MAN-00261
    Model: 147
    Condition: New-In-Box
  6. SKU: MAN-00272
    Model: 153
    Condition: New-In-Box
  7. Hex Stud 3/8"-16 M and 1/4"-20 M
    Kupo Hex Stud 3/8"-16 M and 1/4"-20 M
    USD $7.49
    SKU: KUPO-KG000812
    Model: KG000812
    Condition: New-In-Box
  8. Camera Hex Stud 1/4"-20 Male
    Kupo Camera Hex Stud 1/4"-20 Male
    USD $6.39
    SKU: KUPO-KG002612
    Model: KG002612
    Condition: New-In-Box
  9. Kupo 3/8"-16 F to 1/4"-20 M Adapter
    USD $5.39
    SKU: KUPO-KG003912
    Model: KG003912
    Condition: New-In-Box
  10. Avenger MP Eye Coupler with 1 1/8" Spigot
    USD $37.00
    Out of stock
    SKU: AVE-00262
    Model: C4461
    Condition: New-In-Box
  11. Unified Handle Assembly For Use with Setti, Euro, and Mantti Reflectors
    SKU: MOLA-03100
    Model: SWH001
    Condition: New-In-Box
  12. Lastolite Professional Tilthead Shoe Lock
    USD $49.99
    Out of stock
    SKU: LAS-00001MC
    Model: LL LA2422
    Condition: New-In-Box
  13. 3/8 Female to 1/4 Male Adapter
    Manfrotto 3/8 Female to 1/4 Male Adapter
    USD $8.99
    Out of stock
    SKU: MAN-00033
    Model: 015
    Condition: New-In-Box
  14. Broncolor Adapter, Converts 5/8" Female-3/8" Tip with 12mm Shaft
    SKU: MAN-00035
    Model: 016 (3100)
    Condition: New-In-Box
  15. Counterweight Only (10 Lbs) As Supplied with 024B Boom
    SKU: MAN-00042
    Model: 023
    Condition: New-In-Box
  16. Lite-Tite Swivel Aluminium Umbrella Adapter
    Manfrotto Lite-Tite Swivel Aluminium Umbrella Adapter
    USD $49.95
    SKU: MAN-00048
    Model: 026
    Condition: New-In-Box
  17. Manfrotto 5/8" Female Adapter
    USD $19.99
    Out of stock
    SKU: MAN-00282
    Model: 158 (3101)
    Condition: New-In-Box
  18. Manfrotto 175F Spring Clamp with Flash Shoe
    USD $78.00
    Out of stock
    SKU: MAN-00300A
    Model: 175F-1
    Condition: New-In-Box
  19. Rapid Adapter Converts 5/8" Stud-17mm Long 1/4"-20m
    SKU: MAN-00029
    Model: 014-14
    Condition: New-In-Box
  20. Rapid Adapt. Converts 5/8" Light Stand Tip-17Mm 3/8"M Thread
    SKU: MAN-00031
    Model: 014-38 (3102)
    Condition: New-In-Box
  21. Adapter 1/4-20 to 3/8 with Flange
    Manfrotto Adapter 1/4-20 to 3/8 with Flange
    USD $19.99
    Out of stock
    SKU: MAN-00186
    Model: 088LBP (3367)
    Condition: New-In-Box
  22. Universal Long Male Spigot Adapter
    Manfrotto Universal Long Male Spigot Adapter
    USD $8.99
    Out of stock
    SKU: MAN-00212
    Model: 118 (3107)
    Condition: New-In-Box
  23. Universal Long Female Spigot Adapter
    Manfrotto Universal Long Female Spigot Adapter
    USD $8.99
    SKU: MAN-00214
    Model: 119 (3108)
    Condition: New-In-Box
  24. Avenger Stand Adaptor
    USD $32.99
    Out of stock
    SKU: AVE-00402
    Model: E200
    Condition: New-In-Box
  25. Grip Head Adapter For Strobe And Video Pro Speed Rings
    SKU: CHI-00147
    Model: 3770
    Condition: New-In-Box
  26. Small Thread Adapter (3/8"-16 female to 1/4"-20 male)
    SKU: PRO-66021
    Model: 1026
    Condition: New-In-Box
  27. 5/8" Receiver to 1/4"-20 Male Thread
    Promaster 5/8" Receiver to 1/4"-20 Male Thread
    USD $9.95
    SKU: PRO-66022
    Model: 1029
    Condition: New-In-Box
  28. 5/8" Receiver to 3/8"-16 Male Thread
    Promaster 5/8" Receiver to 3/8"-16 Male Thread
    USD $9.95
    Out of stock
    SKU: PRO-66023
    Model: 1032
    Condition: New-In-Box
  29. Forza 60 Bowens Mount Adapter
    Nanlite Forza 60 Bowens Mount Adapter
    USD $12.99
    SKU: NLT-ASBAFZ60
    Model: AS-BA-FZ60
    Condition: New-In-Box
  30. Rock Solid Hot Shoe 1/4″-20 Adapter
    Tether Tools Rock Solid Hot Shoe 1/4″-20 Adapter
    USD $9.99
    Out of stock
    SKU: TETH-00570
    Model: RS713
    Condition: New-In-Box
View as Grid List

Items 1-30 of 109

Page
per page
Set Ascending Direction