SecurityMetrics for PCI Compliance, QSA, IDS, Penetration Testing, Forensics, and Vulnerability Assessment AsTec Models RC Boats and Trucks
click here for EU cookie policy information
My Account  Cart Contents  Checkout  
  Top » Catalogue » Printable Catalog My Account  |  Cart Contents  |  Checkout   
AsTec Models RC Boats and Trucks
AsTec Models,
6 Stickland,
Clevedon,
North Somerset,
BS21 5EX UK,
Phone +44 (0)1275 878125
Email: catalog@astecmodels.com
Note: All prices are subject to change without notice. All products will be billed in our shop Currency only.
          The Currency feature is just for your convenience. This catalog is current on the day of printing.
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join categories_description cd on p2c.categories_id = cd.categories_id left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and cd.language_id = '1' order by cd.categories_name, pd.products_name

[TEP STOP]

 
 
Image
Sort Asending
Sort Desending
Manufacturer
Sort Asending
Sort Desending
Name
Sort Asending
Sort Desending
Description
Sort Asending
Sort Desending
Category
Sort Asending
Sort Desending
Price