SELECT SQL_CALC_FOUND_ROWS p.id, pt.name, p.slug, p.price, i.image, p.ref_num, pt.meta_description, p.promo, p.price_promo, p.created_at,
			pt.price as actual_price, pub.name as publisher, p.new, c.name as category, sc.name as subcategory
	     FROM products p
	     INNER JOIN products_text pt ON p.id = pt.product_id AND pt.language_id = 1
	     LEFT JOIN products_images i ON p.id = i.page_id
	     LEFT JOIN pages_text c ON p.category = c.page_id  AND c.language_id = 1
	     LEFT JOIN pages_text sc ON p.subcategory = sc.page_id AND sc.language_id = 1
	     LEFT JOIN pages_text pub ON p.publisher_id = pub.page_id AND pub.language_id = 1
	     WHERE p.top = 'yes'
	     AND p.status != 'deleted'
	     GROUP BY p.id
	     ORDER BY RAND()
	     LIMIT 6
	     
	    

Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")