|
| Product Name |
Model |
Price |
0 -
SELECT s.specials_new_products_price, p.products_id, p.products_model, p.products_price, pd.products_name FROM products p, products_description pd LEFT JOIN specials s ON p.products_id=s.products_id WHERE p.products_id = pd.products_id AND p.products_status = 1 AND pd.language_id = 1 ORDER BY pd.products_name
[TEP STOP]
| |