Ecopack
-
1030 - Got error 28 from storage engine
select distinct p.products_id,p.products_model,p.products_brand_name, pd.products_name,p.products_image, p.products_weight, pd.products_description,pd.products_feature, pd.products_simpledescription, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,p.products_price,products_msrp from products_description pd, products p left join specials s on p.products_id = s.products_id ,categories_description cd,products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and cd.categories_id = p2c.categories_id and pd.language_id = '1' and (p2c.categories_id=2 or p2c.categories_id = '8' or p2c.categories_id = '50' or p2c.categories_id = '51' or p2c.categories_id = '52' or p2c.categories_id = '53' or p2c.categories_id = '54' or p2c.categories_id = '55' or p2c.categories_id = '56' or p2c.categories_id = '57' or p2c.categories_id = '58' or p2c.categories_id = '59' or p2c.categories_id = '60' or p2c.categories_id = '61' or p2c.categories_id = '62' or p2c.categories_id = '63' or p2c.categories_id = '64' or p2c.categories_id = '65' or p2c.categories_id = '66' or p2c.categories_id = '67' or p2c.categories_id = '68' or p2c.categories_id = '129' or p2c.categories_id = '9' or p2c.categories_id = '82' or p2c.categories_id = '83' or p2c.categories_id = '84' or p2c.categories_id = '85' or p2c.categories_id = '86' or p2c.categories_id = '88' or p2c.categories_id = '10' or p2c.categories_id = '89' or p2c.categories_id = '90' )order by p.products_sort_order ,p.products_id desc limit 75, 15
[TEP STOP]