Asus US manufacturer section added on Tuesday 23 March, 2010 with products in our discontinued, routers-gateways, adapters pc card, video cards- pci-e ati chipset, sound cards, server boards amd, lcd panels- 20" to 28", adapters usb, lcd panels- 19", video cards- pci-e nvidia, desktop all-in-one pcs, blu-ray drives, lga1155 boards, video cards- pci-e ati, integrated servers socket 1155, digital media players, lcd panels- 20" to 29", adapters pci, raid- ata-sas controllers, aps bridges-switches, socket am3 boards, accessories, lga2011 desktop, lga2011 server, dvd-recorders external, dvd-recorders internal, lga2011 boards, integrated servers socket 1366, headphones wireless, integrated server socket 1156, lcd panels 20" to 29", lcd projectors, desktop pcs, lcd panels 19", integrated server socket 1366, mini-itx, server board 1155-pin, lcd panels 17" or less, server comp. power supplies, branded server accessories, desktops all-in-one, socket fm2 boards, integrated server socket 1155, adapter cards, server board 2011-pin, integrated server socket 2011, server comp. add-in cards, and headset-mic combos a total of 49 categories.
1030 - Got error 122 from storage engine
|Displaying 1 to 99 (of 391 products)||Result Pages: 1 |
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 = '96' order by pd.products_name limit 0, 99