Electronics Castle Contact MethodsElectronics Castle Payment MethodsCOMODO Secured Seal
Shopping Cart:

now in your cart 0 items
Categories
Heading LeftHeading Right
Spacer

JVC America

JVC America
Spacer

JVC America manufacturer section added on Tuesday 23 March, 2010 with products in our headphones wired, discontinued, headphones wireless, ipod docks-speakers, and camera batteries a total of 6 categories.

Heading LeftHeading Right
SpacerElectronics Castle » JVC America
Show: 
Content Wrapper BL
Displaying 1 to 99 (of 136 products)Result Pages:  1  2  [Next >>] 
1030 - Got error 122 from storage engine

select p.products_image, pd.products_name, c.parent_id, cd.categories_name, cd.categories_id, p2c.categories_id as catid, p2c.products_id, p.products_id, m.manufacturers_name, pd.products_description_short, pd.products_description, p.manufacturers_id, products_weight, p.products_quantity, p.products_dandh, p.products_msrp, products_weight, p.products_quantity, p.products_dandh, p.products_model, p.products_upc, p.products_vnd_num, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m, products_to_categories p2c, categories c, categories_description cd where p.products_status = '1' and p.products_id = p2c.products_id and cd.categories_id = p2c.categories_id and c.categories_id = cd.categories_id and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '145' order by pd.products_name limit 0, 99

[TEP STOP]