Query: DESCRIBE `magnik_products` 

Warning (512): SQL Error: 1030: Got error 122 from storage engine [CORE/cake/libs/model/datasources/dbo_source.php, line 463]


Warning (2): Invalid argument supplied for foreach() [CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 175]

Query: DESCRIBE `magnik_categories`

Query: DESCRIBE `magnik_categories`

Query: DESCRIBE `magnik_categories`

Query: DESCRIBE `magnik_categories`

Query: SELECT `Category`.`, `Category`.`id` FROM `magnik_categories` AS `Category` WHERE parent_id=0 

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`.`id` FROM `magnik_categories` AS `Category`   WHERE parent_id=0' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 463]

Query: SELECT `Category`.` FROM `magnik_categories` AS `Category` WHERE parent_id=0 

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` AS `Category`   WHERE parent_id=0' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 463]

Query: SELECT `Category`.`, `Category`.`id` FROM `magnik_categories` AS `Category` WHERE `Category`.`id` = 1104 LIMIT 1 

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`.`id` FROM `magnik_categories` AS `Category`   WHERE `Category`.`id` =  1104   ' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 463]

Query: SELECT `Category`.`, `Category`.`id` FROM `magnik_categories` AS `Category` WHERE `Category`.`id` = 1104 LIMIT 1

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1115) 

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`.`category_id` FROM `magnik_products` AS `Product`   WHERE `Product`.`category_' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 463]

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1110)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1105)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1106)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1111)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1107)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1112)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1113)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1108)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1109)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1118)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1117)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1114)

Query: SELECT `Product`.`, `Product`.`category_id` FROM `magnik_products` AS `Product` WHERE `Product`.`category_id` IN (1116)

Nikon 55-200mm f/4-5.6G ED IF AF-S DX VR Zoom Nikkor Lens from US Camera Co.
Nikon 55-200mm
 

Nikon 55-200mm f/4-5.6G ED IF AF-S DX VR Zoom Nikkor Lens

Nikon 55-200mm f/4-5.6G ED IF AF-S DX VR Zoom Nikkor Lens

Customer Rating: 
Total Reviews: 181

Best Offer: $180.00
By Supplier: -dawnnah-

Availability: Usually ships in 1-2 business days

Feedback  |  Description/Reviews  |  Offers  |  Accessories
1 | 2 | 3 | 4 | 5 | 6 | 7 
Love it
I bought this as a compliment to my 18-55 kit lens. So far I haven't had an excuse to switch back to the kit lens. The VR option is wonderful. And I've had a few friends with similar Canon lenses remark how much clearer my photos are compared to theirs.
2008-08-27
Great Value!
The short story here is the lens can pack some great image quality, particularly for the cost and size. Small means portable... I had it in my pocket on my last shoot. Stop it down a bit and the sharpness is right there. The negatives (noisy focus, low light, etc) are easily forgiven for the short money. Add VR and it's a 5-star.
2008-08-22
UH-Mazing
We are "new" to the DSLR world, but I have to say that this lens is amazing. Really helps with amateurs and pros with the vibration reduction side. My dad is infamous for blurry pictures. With this VR lens, he finally took GOOD pictures!

Was at a Yankee game in the upper deck and took some great pics fully zoomed of hitters. You would think I was MUCH closer.

Thinking about purchasing another VR lens to accompany this.
2008-08-22
nikon lens
love the lens, much less money for quality lens than wholesale...my son-in-law bought an off brand for about the same cost...not near the quality. arrived quickly. thanks.
2008-08-12
4.5 Stars, Really: Nice Lens, but...
This is a reasonably nice lens for the price, and I've gotten some fantastic pictures using it. Some people don't like the "plastic" feel of the lens, but I appreciate the fact that it is so light.

Pros:
-55-200mm is a nice zoom range
-VR is great when it works, and can do wonders with panning
-light weight (light enough to carry around all day as a tourist)
-fairly short, compared to older lenses of this focal length
-lens hood is included

Cons:
-I find the VR sometimes takes time to "lock" onto the image- if it isn't ready, the image will "stutter"
-"plastic feel" if you care about such things

I'd just like to mention that I really like VR: it works most of the time without a problem, and the effect on moving objects when panning is stunning. It's just that once in a while, low contrast or less distinct targets seem to confuse it.
2008-08-06
1 | 2 | 3 | 4 | 5 | 6 | 7  





Warning (2): Unknown: write failed: Disk quota exceeded (122) [Unknown, line ??]

Warning (2): Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/home/uscameraco/public_html/store/app/tmp/sessions) [Unknown, line ??]