facebook
 
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_name` IN ('Camera Films','Camera Focusing Screens','Camera/Camcorder Accessory Kits','Camera/Camcorder Batteries','Camera/Camcorder Cases & Bags','Camera/Camcorder Chargers','Camera/Camcorder Docking Stations','Camera/Camcorder Lens Caps','Camera/Camcorder Lens Hoods','Camera/Camcorder Lenses & Filters','Camera/Camcorder Power Adapters','Camera/Camcorder Screen Hoods','Camera/Camcorder Tripods','Eyecups','Flash/Video Lights & IR Illuminators','Shoe Adapters','Photo Albums/Scrapbooks & Accessories','Photo Sheets','Camera/Camcorder Cradles','Camera/Camcorder Cleaning Kits')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%CameraCamcorderAccessories' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('CameraCamcorderAccessories' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+CameraCamcorderAccessories' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"CameraCamcorderAccessories"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"CameraCamcorderAccessories"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"CameraCamcorderAccessories"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"CameraCamcorderAccessories"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+CameraCamcorderAccessories' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='CameraCamcorderAccessories',`category_4` ='CameraCamcorderAccessories') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'CameraCamcorderAccessories,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('CameraCamcorderAccessories', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Camera Camcorder Accessories

Refine Search

  GO
 
Brand

Energizer(12)

Educational Insights(1)

 
Recycled

No(12)

 
Manufacturer Part Number

1233(1)

EL123APB2(1)

EL123APB2CT(1)

EL123APBP(1)

EL123APBPCT(1)

EL1CR2BP(1)

EL1CR2BPCT(1)

EL223APBP(1)

EL223APBPCT(1)

EL2CR5BP(1)

EL2CR5BPCT(1)

ELCRV3BP2(1)

ELCRV3BP2CT(1)

 
Country of Origin

United States(10)

China(2)

Indonesia(1)

 
Width

48"(1)

 
Material

Fabric(1)

 
Weight (Approximate)

1.60 oz(1)

0.58 oz(1)

0.39 oz(1)

1.31 oz(1)

1.41 oz(1)

1.13 oz(1)

 
Length

24"(1)

 
Battery Size

CR123A(2)

CR2(1)

CR223(1)

2CR5(1)

CRV3(1)

 
Output Voltage

3 V DC(8)

6 V DC(4)

 
Battery Capacity

1300 mAh(4)

3000 mAh(1)

 
Battery Chemistry

Lithium (Li)(11)

 
Product Type

Battery(12)

Color Filter(1)

 
Packaged Quantity

24 / Carton(4)

2 / Pack(2)

48 / Carton(2)

1 / Pack(2)

3 / Pack(1)

1 Pack(1)

 
Product Model

EL123APBP(1)

EL1CR2BP(1)

EL223APBP(1)

 
Product Line

e2(10)