|
|
⁄ ⁄ |
|
LCD Monitor,
Hi DEF TFTs, widescreen TFTs -
Top brands, low prices
LCD Monitor
Screen from as low as £104.58. |
|
 |
|
0 -
SELECT distinct products.products_id, products.products_image, products.products_price, products.products_ordered,products_description.products_short_description, products_description.products_description, products_description.products_name FROM products Inner Join products_description ON products.products_id = products_description.products_id Inner Join products_to_categories ON products.products_id = products_to_categories.products_id Inner Join categories ON products_to_categories.categories_id = categories.categories_id and categories.categories_id > 271 WHERE products.products_status = '1' AND products.products_id NOT IN (3630,1520,4362,4450,4363,2217,3607)AND categories.categories_id IN() OR categories.parent_id IN ( ) and products.products_price > 0 ORDER BY products.products_id DESC LIMIT 10
[TEP STOP]
| | |