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 = '10' order by p.products_quantity desc
| |
Product Name+ |
Price |
|
 |
Product Title: HPQ NIC
MFG Part#: 435508-B21
Condition: New Retail
In Stock: Yes
HPQ NC364T PCI-E 4PT GIGABIT SVR ADPT |
$405.77 |
 |
 |
Product Title: HPQ GBICS
MFG Part#: 412648-B21
Condition: New Retail
In Stock: Yes
HPQ NC360T PCI-E 2PT GIGBAIT SVR ADPT |
$229.00
$172.70 |
|
 |
Product Title: HPQ DVD/CD/FLOPPY
MFG Part#: 481043-B21
Condition: New Retail
In Stock: Yes
HPQ 8X DVD+/-RW SATA DRIVE DL120 G5 |
$102.96 |
|
 |
Product Title: HPQ NIC
MFG Part#: 458492-B21
Condition: New Retail
In Stock: Yes
HPQ NC382T PCI-E 2PT MULTFUNC SVR ADPT |
$199.00
$157.30 |
|
 |
Product Title: HPQ DVD/CD/FLOPPY
MFG Part#: 481041-B21
Condition: New Retail
In Stock: Yes
HPQ 8X 12.7MM SATA DVD-ROM DL120G5 |
$103.64 |
|
 |
Product Title: IBM NICS & TOKEN RING
MFG Part#: 39Y6136
Condition: New Retail
In Stock: Yes
IBM INTEL PRO/1000 PT QUAD PRT SRVR ADPT |
$376.25 |
|
| |
Product Title: IBM NICS & TOKEN RING
MFG Part#: 49Y4240
Condition: New Retail
In Stock: Yes
IBM INTEL ENET QUAD PORT I340-T4 ADAPTER |
$529.00
$478.50 |
|
 |
Product Title: HPQ DVD/CD/FLOPPY
MFG Part#: 532066-B21
Condition: New Retail
In Stock: Yes
HP DL360 SL 12.7MM SATA DVD |
$83.75 |
|
| |
Product Title: HPQ NIC
MFG Part#: 538696-B21
Condition: New Retail
In Stock: Yes
HPQ NC375T PCIE 4PT GETH SVR ADPTR |
$439.00
$396.00 |
|
 |
Product Title: IBM BLADE SPECIFIC OPTIONS
MFG Part#: 43W4395
Condition: New Retail
In Stock: Yes
IBM CISCO CATALYST SWCH MOD 3012 BLADEC |
$2,487.10 |
|
| |
Product Title: IBM BLADE SPECIFIC OPTIONS
MFG Part#: 44W4475
Condition: New Retail
In Stock: Yes
IBM ETHERNET EXPANSION CARD CIOV FOR BC |
$299.00
$198.00 |
|
| |
Product Title: IBM NICS & TOKEN RING
MFG Part#: 46M1076
Condition: New Retail
In Stock: Yes
IBM DUAL PORT 1GB ETHERNET DAUGHTER CARD |
$89.00
$71.50 |
|
 |
Product Title: IBM BLADE SPECIFIC OPTIONS
MFG Part#: 44W4483
Condition: New Retail
In Stock: Yes
IBM INTELLIGENT COPPER PASS-T MOD FOR BC |
$959.57 |
|
 |
Product Title: IBM BLADE SPECIFIC OPTIONS
MFG Part#: 43W4068
Condition: New Retail
In Stock: Yes
IBM SAS CONNECTIVITY CARD CIOV FOR HS22 |
$214.50 |
|
 |
Product Title: IBM BLADE SPECIFIC OPTIONS
MFG Part#: 44X1945
Condition: New Retail
In Stock: Yes
IBM QLOGIC 8GB FC EXP CARD FOR BC CIOV |
$882.20 |
|
| |
Product Title: HPQ BLADE SPECIFIC OPTIONS
MFG Part#: 409513-B22
Condition: New Retail
In Stock: Yes
HPQ 4GB VIRTUAL CONNECT FC MODULE BLC |
$9,499.00
$8,275.30 |
|
 |
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: IBM BLADE SPECIFIC OPTIONS
MFG Part#: 46M6065
Condition: New Retail
In Stock: Yes
IBM QLOGIC 4GB FC EXPANSION CARD CIOV |
$496.10 |
|
 |
Product Title: IBM BLADE SPECIFIC OPTIONS
MFG Part#: 44W4479
Condition: New Retail
In Stock: Yes
IBM 2/4 PORT ENET EXP CARD CFFH FOR BC |
$581.49 |
|
| |
Product Title: HPQ BLADE SPECIFIC OPTIONS
MFG Part#: 456204-B21
Condition: New Retail
In Stock: Yes
HPQ C7000 ONBOARD ADMIN WITH KVM |
$899.00
$783.20 |
|
