Matthews Studio Equipment

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 (11125, 8863, 8864, 8865, 8866, 8867, 8868, 238826, 238835, 194965, 195045, 195046, 195047, 195048, 195049, 195050, 195054, 195055, 195056, 195057, 195058, 195059, 195060, 195061, 195062, 195063, 195064, 195065, 195067, 195068)) 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,11125,8863,8864,8865,8866,8867,8868,238826,238835,194965,195045,195046,195047,195048,195049,195050,195054,195055,195056,195057,195058,195059,195060,195061,195062,195063,195064,195065,195067,195068)
View as Grid List

Items 1-30 of 83

Page
per page
Set Ascending Direction
  1. Matthews Studio Equipment Chain Vice Grip with Two 5/8" Pins
    USD $90.00
    Out of stock
    SKU: MAT-429039
    Model: 429039
    Condition: New-In-Box
  2. Matthews Studio Equipment MAT-299888
    USD $74.00
    Out of stock
    SKU: MAT-299888
    Model: 299888
    Condition: New-In-Box
  3. Matthews Studio Equipment Roadrags Kit (18"x24")
    USD $281.00
    Out of stock
    SKU: MAT-350595
    Model: 350595
    Condition: New-In-Box
  4. Matthews Studio Equipment Minigrip Mounting Kit
    USD $225.00
    Out of stock
    SKU: MAT-350598
    Model: 350598
    Condition: New-In-Box
  5. Matthews Studio Equipment 6" Pin with Collar
    USD $14.00
    Out of stock
    SKU: MAT-429599
    Model: 429599
    Condition: New-In-Box
  6. Matthews Studio Equipment 5/8" Baby Pin with 3/8" Tread
    USD $13.00
    Out of stock
    SKU: MAT-429779
    Model: 429779
    Condition: New-In-Box
  7. 2-4' Lightweight Telescoping Hanger with Pipe Clamp
    Matthews Studio Equipment 2-4' Lightweight Telescoping Hanger with Pipe Clamp
    USD $135.00
    Out of stock
    SKU: MAT-B429722
    Model: B429722
    Condition: New-In-Box
  8. Junior Stand Triple Rolling Riser
    Matthews Studio Equipment Junior Stand Triple Rolling Riser
    USD $450.00
    Out of stock
    SKU: MAT-H386033
    Model: H386033
    Condition: New-In-Box
  9. Hollywood Baby Jr. Double Riser
    Matthews Studio Equipment Hollywood Baby Jr. Double Riser
    USD $346.00
    Out of stock
    SKU: MAT-H386025
    Model: H386025
    Condition: New-In-Box
  10. Back Light Stand
    Matthews Studio Equipment Back Light Stand
    USD $69.00
    Out of stock
    SKU: MAT-339763
    Model: 339763
    Condition: New-In-Box
  11. 18" x 24" Double Open End Scrim (Black)
    Matthews Studio Equipment 18" x 24" Double Open End Scrim (Black)
    USD $67.00
    Out of stock
    SKU: MAT-149061
    Model: 149061
    Condition: New-In-Box
  12. 18" x 24" Single Open End Scrim (Black)
    Matthews Studio Equipment 18" x 24" Single Open End Scrim (Black)
    USD $51.00
    Out of stock
    SKU: MAT-149066
    Model: 149066
    Condition: New-In-Box
  13. Floppy Cutter (24" x 72")
    Matthews Studio Equipment Floppy Cutter (24" x 72")
    USD $175.00
    Out of stock
    SKU: MAT-169029
    Model: 169029
    Condition: New-In-Box
  14. Mini Meat Axe Flag (24" x 48")
    Matthews Studio Equipment Mini Meat Axe Flag (24" x 48")
    USD $87.00
    Out of stock
    SKU: MAT-169030
    Model: 169030
    Condition: New-In-Box
  15. Flag (18" x 24")
    Matthews Studio Equipment Flag (18" x 24")
    USD $42.00
    Out of stock
    SKU: MAT-169059
    Model: 169059
    Condition: New-In-Box
  16. Flag (24" x 36")
    Matthews Studio Equipment Flag (24" x 36")
    USD $51.00
    Out of stock
    SKU: MAT-169062
    Model: 169062
    Condition: New-In-Box
  17. 10" x 12" Flex Scrims (1/4 Stop) (Silk White)
    Matthews Studio Equipment 10" x 12" Flex Scrims (1/4 Stop) (Silk White)
    USD $27.95
    Out of stock
    SKU: MAT-238126
    Model: 238126
    Condition: New-In-Box
  18. 10" x 12" Flex Scrims (China Silk White)
    Matthews Studio Equipment 10" x 12" Flex Scrims (China Silk White)
    USD $39.95
    Out of stock
    SKU: MAT-238127
    Model: 238127
    Condition: New-In-Box
  19. Auger Spike
    Matthews Studio Equipment Auger Spike
    USD $49.00
    Out of stock
    SKU: MAT-249566
    Model: 249566-1
    Condition: New-In-Box
  20. Apple Box (1/2)
    Matthews Studio Equipment Apple Box (1/2)
    USD $47.00
    Out of stock
    SKU: MAT-259536
    Model: 259536
    Condition: New-In-Box
  21. Apple Box (1/4)
    Matthews Studio Equipment Apple Box (1/4)
    USD $40.00
    Out of stock
    SKU: MAT-259537
    Model: 259537
    Condition: New-In-Box
  22. Apple Box (1/8)
    Matthews Studio Equipment Apple Box (1/8)
    USD $31.00
    Out of stock
    SKU: MAT-259538
    Model: 259538
    Condition: New-In-Box
  23. Cordura Sandbag (Orange) (25 lbs)
    Matthews Studio Equipment Cordura Sandbag (Orange) (25 lbs)
    USD $38.00
    Out of stock
    SKU: MAT-299552
    Model: 299552
    Condition: New-In-Box
  24. Cordura 15 lbs Sandbag (Orange) (Empty)
    Matthews Studio Equipment Cordura 15 lbs Sandbag (Orange) (Empty)
    USD $22.00
    Out of stock
    SKU: MAT-29955E
    Model: 229955E
    Condition: New-In-Box
  25. Saddle Sandbag (20 lbs)
    Matthews Studio Equipment Saddle Sandbag (20 lbs)
    USD $33.00
    Out of stock
    SKU: MAT-299700
    Model: 299700
    Condition: New-In-Box
  26. Saddle Sandbag (35 lbs)
    Matthews Studio Equipment Saddle Sandbag (35 lbs)
    USD $39.00
    Out of stock
    SKU: MAT-299705
    Model: 299705
    Condition: New-In-Box
  27. Boa Bag (10 lbs)
    Matthews Studio Equipment Boa Bag (10 lbs)
    USD $53.00
    Out of stock
    SKU: MAT-299887
    Model: 299887
    Condition: New-In-Box
  28. Rag Bag (Medium)
    Matthews Studio Equipment Rag Bag (Medium)
    USD $33.00
    Out of stock
    SKU: MAT-309212
    Model: 309212
    Condition: New-In-Box
  29. Spring Loaded Turtle Base Only
    Matthews Studio Equipment Spring Loaded Turtle Base Only
    USD $136.00
    Out of stock
    SKU: MAT-339759
    Model: 339759
    Condition: New-In-Box
  30. Hollywood Grip Head (Chrome)
    Matthews Studio Equipment Hollywood Grip Head (Chrome)
    USD $39.00
    Out of stock
    SKU: MAT-350580
    Model: 350580
    Condition: New-In-Box
View as Grid List

Items 1-30 of 83

Page
per page
Set Ascending Direction