Can not execute database query. Please contact site administrator.
2014-09-22T00:11:50+00:00

SELECT
Inno_products.*,
IF(Inno_products.url_custom='',Inno_products.url_default,Inno_products.url_custom) AS product_url,
Inno_catalog.name AS cat_name,
IF(Inno_catalog.url_custom='',Inno_catalog.url_default,Inno_catalog.url_custom) AS cat_url,
SUM(Inno_orders_content.admin_price * Inno_orders_content.admin_quantity) AS product_amount,
SUM(Inno_orders_content.admin_quantity) AS product_quantity
FROM Inno_orders_content
INNER JOIN Inno_orders ON Inno_orders.oid=Inno_orders_content.oid
INNER JOIN Inno_products ON Inno_products.pid = Inno_orders_content.pid

INNER JOIN Inno_catalog ON Inno_catalog.cid = Inno_products.cid
WHERE
Inno_catalog.key_name <> 'gift_cert' AND
Inno_products.is_visible='Yes' AND
DATE_ADD(Inno_orders.placed_date, INTERVAL 1 MONTH)>NOW() AND
Inno_orders.status='Completed' AND
Inno_orders.payment_status='Received'
GROUP BY Inno_orders_content.pid
ORDER BY
product_quantity DESC
LIMIT 7


Can't create/write to file '/tmp/#sql_19fd_0.MYI' (Errcode: 28)