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 ('Camcorders','Digital Cameras','Film Cameras','PC & Web Cameras','Imaging 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 '%Cameras' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Cameras' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Cameras' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Cameras"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Cameras"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Cameras"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Cameras"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Cameras' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Cameras',`category_4` ='Cameras') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Cameras,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Cameras', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Cameras

Refine Search

  GO
 
Brand

Canon(3)

GBC(3)

Logitech(3)

Panasonic(3)

Learning Resources(1)

Spracht(1)

 
Color

White(4)

Blue(2)

Red(2)

Black(1)

 
Height

5.5"(3)

2.3"(3)

16.9"(1)

18.5"(1)

22"(1)

9.3"(1)

 
Depth

1.9"(3)

0.8"(3)

2.4"(1)

 
Manufacturer Part Number

IVYCLIQBLUE(1)

IVYCLIQRED(1)

IVYCLIQWHIT(1)

DCV10001(1)

DCV10004(1)

DCV10009(1)

960-000622(1)

960-000714(1)

960-000732(1)

4427(1)

DMC-TS30A(1)

DMCTS30K(1)

DMC-TS30/R(1)

CC-2020(1)

 
Country of Origin

China(4)

Vietnam(3)

 
Width

4.5"(3)

4.1"(3)

4.8"(1)

7.1"(1)

7.9"(1)

2.4"(1)

 
Limited Warranty

5 Year(3)

2 Year(3)

 
Weight (Approximate)

5.01 oz(3)

1.01 lb(1)

 
Length

4.8"(1)

7"(1)

9.9"(1)

 
Durability

Freeze Proof(3)

Water Proof(3)

Shock Proof(3)

 
Device Supported

Computer(3)

 
Widescreen

Yes(2)

 
USB

Yes(4)

 
Aspect Ratio

16:9(3)

 
Microphone

Yes(3)

 
Display Screen Type

LCD(3)

 
Screen Size

2.7"(3)

 
Host Interface

USB 2.0(4)

 
Memory Card Supported

SD(3)

SDHC(3)

SDXC(3)

 
Touchscreen

No(3)

 
Digital Zoom

4x(3)

 
HDMI

Yes(3)

No(3)

 
Maximum Video Resolution

1280 x 720(5)

1920 x 1080(2)

 
Focus Modes

Auto-focus(2)

Auto(1)

Fixed Focus(1)

 
Image Stabilization

Optical(3)

 
Image Formats

JPEG(3)

 
GPS

No(3)

 
HD Movie Mode

Yes(3)

 
Effective Camera Resolution

5 Megapixel(3)

8 Megapixel(3)

16 Megapixel(3)

2 Megapixel(1)

 
Exposure Control

Programmed Auto(3)

 
Focal Length

4.50 mm to 18 mm(3)

 
Image Sensor Size

1/2.33" (0.24" x 0.18")(3)

 
Autofocus

Yes(3)

 
External Flash

No(3)

 
Viewfinder Type

No(3)

 
Product Type

Document Camera(4)

Instant Digital Camera(3)

Webcam(3)

Compact Camera(3)

Video Conferencing Camera(1)

 
Packaged Quantity

1 Each(6)

1(4)

 
Assembly Required

No(4)

 
Product Model

TS30(3)

1100(1)

3000(1)

3100(1)

C310(1)

C525(1)

C615(1)

 
Product Line

IVY CLIQ+(3)

Discovery(3)

Lumix(3)

Aura Video Mate(1)

 
Optical Zoom

4x(3)