Banner1 Banner1
 
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') 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

Logitech(4)

Canon(3)

GBC(3)

Panasonic(3)

OneScreen(1)

Learning Resources(1)

Spracht(1)

 
Color

White(4)

Black(3)

Blue(2)

Red(2)

 
Packaged Quantity

1 Each(6)

1(6)

 
Assembly Required

No(6)

 
Limited Warranty

5 Year(3)

2 Year(3)

 
Weight (Approximate)

5.01 oz(3)

1.01 lb(1)

 
Compatibility

  • Laptops
  • LCD Screens
  • CRT Monitors
(3)

Laptops, LCD or CRT Monitors

(1)

 
Durability

Freeze Proof(3)

Water Proof(3)

Shock Proof(3)

 
Device Supported

Computer(4)

 
USB

Yes(4)

 
Display Screen Type

LCD(3)

 
Host Interface

USB 2.0(5)

USB 3.0(1)

 
Memory Card Supported

SD(3)

SDHC(3)

SDXC(3)

 
HDMI

Yes(3)

No(3)

 
Maximum Video Resolution

1280 x 720(6)

1920 x 1080(3)

 
Optical Zoom

4x(3)

 
Focus Modes

Auto-focus(2)

Auto(1)

Fixed Focus(1)

 
Image Stabilization

Optical(3)

 
Image Formats

JPEG(3)

 
GPS

No(3)

 
Focal Length

4.50 mm to 18 mm(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)

 
Image Sensor Size

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

 
Autofocus

Yes(3)

 
External Flash

No(3)

 
Viewfinder Type

No(3)

 
Manufacturer Part Number

IVYCLIQBLUE(1)

IVYCLIQRED(1)

IVYCLIQWHIT(1)

PTZCAM(1)

DCV10001(1)

DCV10004(1)

DCV10009(1)

960-000622(1)

960-000694(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(6)

Vietnam(3)

 
Height

5.5"(3)

2.3"(3)

6.1"(1)

16.9"(1)

18.5"(1)

22"(1)

9.3"(1)

 
Width

4.5"(3)

4.1"(3)

5.1"(1)

4.8"(1)

7.1"(1)

7.9"(1)

2.4"(1)

 
Depth

1.9"(3)

0.8"(3)

4.6"(1)

2.4"(1)

 
Length

4.8"(1)

7"(1)

9.9"(1)

 
Screen Size

2.7"(3)

 
Widescreen

Yes(3)

 
Microphone

Yes(4)

 
Aspect Ratio

16:9(3)

 
Touchscreen

No(3)

 
Digital Zoom

4x(3)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved