Фотографии товара:
Все Компрессоры и аксессуары Coltri-sub (Италия)

Каталог товаров Coltri-sub (Италия)
Артикул: CS 6-01-006
3640 руб
Купить в 1 клик Нашли дешевле?
Описание товара
Производитель: Coltri-sub (Италия)
Ошибка DB:

Can't create/write to file '/tmp/#sql_21e3_1.MYI' (Errcode: 28 - No space left on device)

SELECT c.*, ROUND(IF(c.old_price > 0, c.price, c.price-((c.price/100)*f.discount))*cr.val) as price, ROUND(IF(c.old_price > 0, c.old_price, IF(f.discount > 0, c.price, c.old_price))*cr.val) as old_price FROM mp_catalog as c LEFT JOIN mp_firms as f ON f.id=c.firm_id LEFT JOIN mp_currency as cr ON cr.code=f.currency WHERE f.active=1 AND is_discont!=1 AND c.active=1 AND c.id IN ( SELECT distinct(item_id) FROM mp_orders_items WHERE order_id IN ( SELECT order_id FROM mp_orders_items WHERE item_id = 2873 ) AND item_id != 2873 ) ORDER BY RAND() LIMIT 9