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 = '3' order by p.products_quantity desc
| |
Product Name+ |
Price |
|
 |
Product Title: HPQ MEMORY
MFG Part#: 500658-B21
Condition: New Retail
In Stock: Yes
HPQ 4GB 2RX4 PC3-10600R-9 MEM KIT |
$170.50 |
 |
 |
Product Title: HPQ MEMORY
MFG Part#: 593339-B21
Condition: New Retail
In Stock: Yes
HPQ 4GB 1RX4 PC3-10600R-9 MEM KIT |
$230.00
$193.60 |
|
| |
Product Title: IBM MEMORY
MFG Part#: 49Y1435
Condition: New Retail
In Stock: Yes
IBM 1X4GB 2RX4 1.5V PC3-10600 DDR3 RDIMM |
$235.00
$227.70 |
|
| |
Product Title: HPQ MEMORY
MFG Part#: 462967-B21
Condition: New Retail
In Stock: Yes
HPQ 512MB P-SERIES BBWC UPG |
$281.60 |
|
 |
Product Title: HPQ MEMORY
MFG Part#: 462968-B21
Condition: New Retail
In Stock: Yes
HPQ 256MB P-SERIES CACHE UPG |
$162.80 |
|
| |
Product Title: IBM MEMORY
MFG Part#: 49Y1436
Condition: New Retail
In Stock: Yes
IBM 1X8GB 2RX4 1.5V PC3-10600 DDR3 RDIMM |
$509.00
$493.90 |
|
 |
Product Title: HPQ MEMORY
MFG Part#: 413015-B21
Condition: New Retail
In Stock: Yes
HPQ 16GB (2X8GB) PC2-5300 MEMORY KIT |
$1,536.70 |
|
| |
Product Title: HPQ MEMORY
MFG Part#: 500656-B21
Condition: New Retail
In Stock: Yes
HPQ 2GB 2RX8 PC3-10600R-9 MEM KIT |
$77.22 |
|
| |
Product Title: HPQ MEMORY
MFG Part#: 516423-B21
Condition: New Retail
In Stock: Yes
HPQ 8GB 2RX4 PC3-8500R-7 MEM KIT |
$734.80 |
|
| |
Product Title: HPQ MEMORY
MFG Part#: 397415-B21
Condition: New Retail
In Stock: Yes
HPQ 8GB (2X4GB) PC2-5300 FBD MEMORY KIT |
$463.33 |
|
 |
Product Title: IBM MEMORY
MFG Part#: 44T1483
Condition: New Retail
In Stock: Yes
IBM 4GB (1X4GB) DUAL RANK PC3-10600 CL9 |
$227.70 |
|
| |
Product Title: HPQ MEMORY
MFG Part#: 534916-B21
Condition: New Retail
In Stock: Yes
HPQ 512MB FLASH BACKED WRITE CACHE |
$429.00
$319.00 |
|
 |
Product Title: HPQ MEMORY
MFG Part#: 397411-B21
Condition: New Retail
In Stock: Yes
HPQ 2GB (2X1GB) PC2-5300 MEMORY |
$114.75 |
|
 |
Product Title: IBM MEMORY
MFG Part#: 46C7420
Condition: New Retail
In Stock: Yes
IBM 8GB (2X4GB) PC2-5300 CL5 FB-DIMM |
$528.00 |
|
| |
Product Title: IBM MEMORY
MFG Part#: 49Y1430
Condition: New Retail
In Stock: Yes
IBM 4GBX1 2RX4 1.5V PC3-10600 1333MHZ |
$235.00
$313.50 |
|
| |
Product Title: IBM MEMORY
MFG Part#: 44T1480
Condition: New Retail
In Stock: Yes
IBM 1GB (1x1GB) PC3-10600 DDR3-1333 1RX8 |
$82.48 |
|
 |
Product Title: IBM MEMORY
MFG Part#: 44T1488
Condition: New Retail
In Stock: Yes
IBM 4GB (1X4GB) D-RANK PC3-10600 CL9 VLP |
$270.60 |
|
| |
Product Title: IBM MEMORY
MFG Part#: 49Y1434
Condition: New Retail
In Stock: Yes
IBM 2GB 1X2GB 1RX4 1.5V PC3-1060 1333MHz |
$125.00
$121.00 |
|
| |
Product Title: HPQ MEMORY
MFG Part#: 397413-B21
Condition: New Retail
In Stock: Yes
HPQ 4GB (2x2GB) PC2-5300 FBD MEMORY KIT |
$188.13 |
|
| |
Product Title: IBM MEMORY
MFG Part#: 49Y1433
Condition: New Retail
In Stock: Yes
IBM 1X2GB 2RX8 1.5V PC3-10600 DDR3 RDIMM |
$125.00
$127.60 |
|
