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 = '18' order by p.products_quantity desc
| |
Product Name+ |
Price |
|
 |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PLL2PU-00701F
Condition: New Retail
In Stock: Yes
TOSHIBA ATOM NB255 1.66GHz/1GB/16GB |
$299.99
$302.50 |
 |
 |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLC8U-023010
Condition: New Retail
In Stock: Yes
TOSH SATELLITE L305D-S5890 NOTEBOOK |
$544.50 |
|
 |
Product Title: PANASONIC NOTEBOOK
MFG Part#: CF-19FDGAXCM
Condition: New Retail
In Stock: Yes
PANASONIC CF19 C2D/1.06 10.4DIG 1GB 80GB |
$3,160.30 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSPG8U-01X002
Condition: New Retail
In Stock: Yes
TOSHIBA T6600 2.2/4GB/500GB/DVD |
$949.99
$742.50 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLY0U-03F02F
Condition: New Retail
In Stock: Yes
TOSHIBA 900 2.2/3GB/250GB/DVD |
$510.99
$385.00 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLWJU-00H003
Condition: New Retail
In Stock: Yes
TOSHIBA i5-430M 2.26GHz/4GB/500GB/DVD-SM |
$799.99
$704.00 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PLL3AU-00F015
Condition: New Retail
In Stock: Yes
TOSHIBA N450 1.66/1GB/250GB/DVD |
$399.99
$379.50 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLM0U-00S009
Condition: New Retail
In Stock: Yes
TOSHIBA AMD RM-75 2.2/3072MB/320GB/DVD |
$572.00 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLV6U-03P02S
Condition: New Retail
In Stock: Yes
TOSHIBA AMD M100 2.0GHZ/2GB/250GB/DVD-SM |
$469.99
$451.00 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLV6U-04F02S
Condition: New Retail
In Stock: Yes
TOSHIBA AMD M520 2.3GHz/4GB/320GB/DVD-SM |
$629.99
$561.00 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PLL23U-00R01C
Condition: New Retail
In Stock: Yes
TOSHIBA ATOM N280 1.66GHz/1GB/250GB |
$399.99
$357.50 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLV6U-04X02S
Condition: New Retail
In Stock: Yes
TOSHIBA AMD M100 2.0GHZ/2GB/250GB/DVD-SM |
$459.99
$445.50 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLV6U-01C007
Condition: New Retail
In Stock: Yes
TOSHIBA AMD M300 2.0GHZ/3GB/320GB/DVD-SM |
$499.99
$484.00 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLY0U-01N024
Condition: New Retail
In Stock: Yes
TOSHIBA CELERON T3000 1.8/4096/250G/DVD |
$473.00 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLP0U-00K003
Condition: New Retail
In Stock: Yes
TOSHIBA AMD RM-74 2.2/4096MB/250GB/DVD |
$594.00 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSAT3U-011002
Condition: New Retail
In Stock: Yes
TOSHIBA P7450 CORE 2 DUO 2.13/1024MB/64G |
$1,028.50 |
|
 |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSAELU-038010
Condition: New Retail
In Stock: Yes
TOSH SAT A215-S6820 NOTEBOOK |
$859.32 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSU44U-029020
Condition: New Retail
In Stock: Yes
TOSH SATELLITE U405-ST550W NOTEBOOK |
$841.50 |
|
 |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSSBAU-00M006
Condition: New Retail
In Stock: Yes
TOSH SAT PRO S300-EZ1511 NOTEBOOK |
$430.99 |
|
| |
Product Title: TOSHIBA NOTEBOOKS
MFG Part#: PSLY0U-03E02G
Condition: New Retail
In Stock: Yes
TOSHIBA 900 2.2GHz/3GB/250GB/DVD-SM |
$385.00 |
|
