Error: Error writing file '/tmp/#sql-temptable-c234c-9adcb7-a14271.MAD' (Errcode: 28 "No space left on device")
Error No: 3
SELECT MAX(a.attribute_id) attribute_id, MAX(ad.name) attribute_name, MAX(pa.text) value, COUNT(*) total FROM `oc_product` p LEFT JOIN `oc_product_attribute` pa ON (p.product_id = pa.product_id) LEFT JOIN `oc_attribute` a ON (a.attribute_id = pa.attribute_id) LEFT JOIN `oc_attribute_description` ad ON (ad.attribute_id = a.attribute_id) LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.product_id) LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id) LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '2' AND pa.language_id = '2' AND ad.language_id = '2' GROUP BY lower(pa.text), a.attribute_id HAVING COUNT(*) > 0 : in /home/bhs.lv/public_html/system/library/db/mysqli.php on line 76