select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(p.products_price_override, p.products_price_override, p.products_price * (1 + p.products_markup)) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_quantity > 0 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '14' order by p.products_quantity desc
| |
Product Name+ |
Price |
|
 |
Product Title: HPQ HBAS
MFG Part#: AE312A
Condition: New Retail
In Stock: Yes
HPQ FC1242SR FC HBA 4GB 2P PCI-E |
$1,094.35 |
 |
 |
Product Title: HPQ HBAS
MFG Part#: AE311A
Condition: New Retail
In Stock: Yes
HPQ FC1142SR 4GB PCI-E HBA |
$700.90 |
|
 |
Product Title: EMULEX HBAS
MFG Part#: LPE11000-M4
Condition: New Retail
In Stock: Yes
EMULEX PCI-E 4GB 1PT HBA |
$741.75 |
|
 |
Product Title: EMULEX HBAS
MFG Part#: LPE11002-E
Condition: New Retail
In Stock: Yes
EMULEX DUAL PT 4GB PCIE |
$1,645.00
$1,064.80 |
|
 |
Product Title: IBM HBAS
MFG Part#: 42C2069
Condition: New Retail
In Stock: Yes
IBM EMULEX 4GB FC SINGLE PORT PCI-E HBA |
$1,006.20 |
|
 |
Product Title: IBM HBAS
MFG Part#: 39R6527
Condition: New Retail
In Stock: Yes
IBM QLOGIC 4GBPS FC DUAL PORT PCI-E HBA |
$1,571.65 |
|
 |
Product Title: IBM HBAS
MFG Part#: 39R6525
Condition: New Retail
In Stock: Yes
IBM QLOGIC 4GBPS FC SINGLE PORT PCI-E HB |
$1,006.20 |
|
| |
Product Title: IBM HBAS
MFG Part#: 39Y6146
Condition: New Retail
In Stock: Yes
IBM QLOGIC ISCSI 1PT PCIE HBA SYSTEM X |
$815.00
$788.70 |
|
| |
Product Title: HPQ HBAS
MFG Part#: AJ763A
Condition: New Retail
In Stock: Yes
HP 82E 8GB FC HBA 2PT PCIE EMULEX CHIPSE |
$2,250.00
$1,655.50 |
|
 |
Product Title: HPQ HBAS
MFG Part#: 403619-B21
Condition: New Retail
In Stock: Yes
HPQ FC HBA QLOGIC QMH2462 BL460 BL465 BL |
$481.80 |
|
 |
Product Title: HPQ HBAS
MFG Part#: 403621-B21
Condition: New Retail
In Stock: Yes
HPQ FC HBA EMULEX LPE1105 BL460C BL465C |
$749.00
$470.85 |
|
 |
Product Title: IBM HBAS
MFG Part#: 42D0501
Condition: New Retail
In Stock: Yes
IBM QLOGIC 8GB FC SINGLE PORT PCI-E HBA |
$1,057.10 |
|
 |
Product Title: HPQ HBAS
MFG Part#: 412911-B21
Condition: New Retail
In Stock: Yes
HPQ SC11XE HOST BUS ADAPTER |
$202.10 |
|
 |
Product Title: EMULEX HBAS
MFG Part#: LPE11000-E
Condition: New Retail
In Stock: Yes
EMULEX PCI-E 4GB 1PT HBA EMC FIRMWARE |
$742.83 |
|
 |
Product Title: HPQ HBAS
MFG Part#: AJ762A
Condition: New Retail
In Stock: Yes
HPQ SW 81E 8GB FC HBA 1PT PCIE |
$962.50 |
|
 |
Product Title: IBM HBAS
MFG Part#: 44X1940
Condition: New Retail
In Stock: Yes
IBM QLOGIC ENET 8GB FC EXP CARD CFFH |
$996.60 |
|
| |
Product Title: EMULEX HBAS
MFG Part#: LPE12000-E
Condition: New Retail
In Stock: Yes
EMULEX SINGLE PORT 8GB FC PCI EXPRESS |
$1,245.00
$804.10 |
|
| |
Product Title: HPQ HBAS
MFG Part#: AJ764A
Condition: New Retail
In Stock: Yes
HPQ 82Q 8GB FC HBA 2PT PCIE QLOGIC |
$2,250.00
$1,415.70 |
|
| |
Product Title: HPQ HBAS
MFG Part#: AP770A
Condition: New Retail
In Stock: Yes
HPQ 82B PCIE 8GB FC DUAL PORT HBA |
$2,185.00
$1,797.40 |
|
 |
Product Title: EMULEX HBAS
MFG Part#: LP11000-E
Condition: New Retail
In Stock: Yes
EMULEX PCI-X 4GB 1PT HBA EMC FIRMWARE |
$741.75 |
|
| Displaying 1 to 20 (of 20 products) |
Result Pages: 1 |
|
