Questions or need help ordering? Call free on 0800 012 2602 (Mon-Fri, 8-6)
   Log in | Create account | £ GBP United Kingdom
Search Search
1030 - Got error 28 from storage engine

SELECT SQL_CALC_FOUND_ROWS p.products_recent_sales, pt.*, m.manufacturers_name, m.manufacturers_image, p.products_image, p.products_bimage,p.products_price1,p.products_price7, p.manufacturers_id, p.products_price, p.products_tax_class_id, (p.products_price) as final_price, p.product_lowest_price, pd.products_name, pd.products_subheading, UNIX_TIMESTAMP(p.products_date_added) AS unix_date_added, p.products_so_text, p.products_feat_text, p.products_est_delivery, p.vendors_prod_id, p.products_show_stock FROM products_tags pt, products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c WHERE pt.products_id = p.products_id AND pt.products_id = p2c.products_id AND p.products_status='1' AND p.store_id = 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_sort_order