Mice

You have an error in your SQL syntax

1030 - Got error 28 from storage engine

select p.shipping_deal, p.products_image, p.products_quantity, if(length(pd1.products_name), pd1.products_name, pd.products_name) as products_name, if(length(pd1.products_description_short), pd1.products_description_short, pd.products_description_short) as products_description_short, if(length(pd.products_description), pd.products_description, pd1.products_description) as products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(sp.specials_new_products_price IS NULL or sp.specials_new_products_price=-2, IF(s.specials_new_products_price IS NOT NULL, s.specials_new_products_price*1.00, NULL ),IF(sp.specials_new_products_price=-1,NULL,sp.specials_new_products_price) ) as specials_new_products_price, ROUND(IF((IF(sp.specials_new_products_price IS NULL or sp.specials_new_products_price=-2, IF(s.specials_new_products_price IS NOT NULL, s.specials_new_products_price*1.00, NULL ),IF(sp.specials_new_products_price=-1,NULL,sp.specials_new_products_price) )) IS NOT NULL AND (IF(sp.specials_new_products_price IS NULL or sp.specials_new_products_price=-2, IF(s.specials_new_products_price IS NOT NULL, s.specials_new_products_price*1.00, NULL ),IF(sp.specials_new_products_price=-1,NULL,sp.specials_new_products_price) )) BETWEEN 0 AND (IF(pp.products_group_price IS NULL or pp.products_group_price=-2, p.products_price*1.00, pp.products_group_price)), (IF(sp.specials_new_products_price IS NULL or sp.specials_new_products_price=-2, IF(s.specials_new_products_price IS NOT NULL, s.specials_new_products_price*1.00, NULL ),IF(sp.specials_new_products_price=-1,NULL,sp.specials_new_products_price) )), IF(pp.products_group_price IS NULL or pp.products_group_price=-2, p.products_price*1.00, pp.products_group_price))*(CASE products_tax_class_id WHEN '2' THEN 1.21 WHEN '3' THEN 1.06 WHEN '4' THEN 1 ELSE 1 END),2) as final_price from products_description pd, products_to_categories p2c, products p LEFT join products_to_affiliates p2a on p.products_id = p2a.products_id and p2a.store_product_status=1 and p2a.affiliate_id = '0' left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='6' and pd1.affiliate_id = '0' left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id and s.status=1 left join specials_prices sp on s.specials_id = sp.specials_id and sp.groups_id = '1' and sp.currencies_id = '2' left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '1' and pp.currencies_id = '2' /*{{prop from*//*prop from}}*/ where p.products_status = 1 and if(pp.products_group_price is null, 1, pp.products_group_price != -1 ) and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '6' and pd.affiliate_id = 0 and p2a.affiliate_id is not null and p2c.categories_id = '25'/*{{prop where*//*prop where}}*/ /*{{price where*/ /*price where}}*/ order by p.sort_order, IF(p.products_quantity>0 /*OR p.products_stock_indication=1*/, 1, CASE p.products_stock_indication WHEN 1 THEN 1 WHEN 2 THEN 2 WHEN 3 THEN 3 WHEN 4 THEN 4 WHEN 5 THEN 7 WHEN 6 THEN 6 WHEN 7 THEN 5 ELSE 3 END) , products_name limit 0, 21

Filename: /templates/gamegear/product_listing.tpl.php
Line: 80

Shop By Price

Top News