preload
Can't create/write to file '/tmp/#sql_5836_5.MYI' (Errcode: 28)
SELECT t1.*, t3.thumbnail FROM SC_products t1 LEFT JOIN SC_product_pictures t3 ON t1.default_picture=t3.photoID WHERE t1.enabled=1 AND t1.categoryID = 50455 AND t1.productID != 1196844 AND t1.default_picture IS NOT NULL AND t1.default_picture != 0 ORDER BY RAND() LIMIT 8