Disk full (/tmp/#sql_42b_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT discussions.Author as Author, discussions.Body as Body, discussions.rating as rating, product.slug as slug, product.enabled as enabled, product.productID as productID, product.categoryID as categoryID, product.name_ru as product_name, category.slug as category_slug, pictures_s.filename as picture_s, pictures.filename as picture FROM SC_discussions as discussions LEFT JOIN SC_products as product ON(product.productID=discussions.productID) LEFT JOIN SC_categories as category ON(category.categoryID=product.categoryID) LEFT JOIN SC_product_pictures as pictures ON(pictures.productID=product.productID && pictures.priority = 1) LEFT JOIN SC_product_pictures as pictures_s ON(pictures_s.productID=product.productID && pictures_s.priority = 0) WHERE discussions.is_active=1 and product.enabled=1 and product.categoryID<>1 ORDER BY rand() ASC LIMIT 4