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

now in your cart 0 items
Categories
Heading LeftHeading Right
Spacer

Energizer

Energizer
Spacer

Energizer manufacturer section added on Tuesday 23 March, 2010 with products in our miscellaneous batteries, battery chargers, discontinued, aa batteries, and aaa-aaaa a total of 6 categories.

Heading LeftHeading Right
SpacerElectronics Castle » Energizer
Show: 
Content Wrapper BL
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 = '304' order by pd.products_name limit 0, 99

[TEP STOP]