Notice: Error: Incorrect key file for table '/tmp/#sql_784b_1.MYI'; try to repair it
Error No: 126
SELECT IF(t1.cprice>t1.price,1,-1)*(t1.cprice-t1.price),t1.rnd,t1.product_id,name,text,t2.attribute_id FROM (SELECT RAND() as rnd,pa2.product_id,pr.price,cpr.price as cprice,count(pa2.attribute_id) as quan FROM oc_product_attribute pa1 INNER JOIN oc_product_attribute pa2 ON (pa1.attribute_id = pa2.attribute_id and pa1.text = pa2.text and pa2.product_id <> pa1.product_id and pa1.language_id = pa2.language_id) INNER JOIN oc_product pr ON (pa2.product_id = pr.product_id and pr.status = 1) LEFT JOIN oc_product cpr ON (pa1.product_id = cpr.product_id) WHERE pa1.product_id = '149103' AND pa1.language_id = '1' AND (pa2.attribute_id = '64075') GROUP BY pa2.product_id,pr.price,cpr.price having quan >= 1) t1 LEFT JOIN oc_product_attribute t2 ON (t2.product_id = t1.product_id) LEFT JOIN oc_attribute_description ad ON (ad.attribute_id = t2.attribute_id) INNER JOIN oc_product_to_category cat on(t1.product_id = cat.product_id) WHERE (0=1 OR t2.attribute_id = '64075') AND cat.category_id IN (130,131,129,128,140,143,142,139,132,137) GROUP BY t1.product_id,t1.price,t1.cprice,name,text,t2.attribute_id ORDER BY t1.rnd, t1.product_id LIMIT 12 in /var/www/www-root/data/www/ on line 50