Фирма производитель:
Сортировать по цене:
      От: До:

Ошибка DB:

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

SELECT SQL_CALC_FOUND_ROWS c.id, c.*, f.name as firm, 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, f.discount, IF(cpv.id IS NOT NULL, 1, 0) as is_from_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 LEFT JOIN mp_catalog_params as cp ON cp.item_id=c.id LEFT JOIN mp_catalog_params_values as cpv ON cpv.param_id=cp.id AND cpv.margin > 0 WHERE c.cat_id IN (320) AND c.active=1 AND f.active=1 AND is_discont!=1 GROUP BY c.id HAVING 1 ORDER BY c.stock_empty, price ASC