De volgende query heeft gefaald: '
SELECT
CASE WHEN webshop_products.special_price > 0 THEN webshop_products.special_price
ELSE webshop_products.price
END as price_sort,
content.title,content.text,webshop_products.lease,webshop_products.lease_price,content.parent_id,content.file_id,webshop_products.price,webshop_products.special_price,webshop_products.id,webshop_products.content_id, webshop_products.description_short, webshop_products.stock, webshop_products.badge_text, webshop_products.badge_color
FROM content
LEFT JOIN webshop_products ON content.id = webshop_products.content_id
LEFT JOIN webshop_product_category_order ON (webshop_products.id = webshop_product_category_order.product_id AND webshop_product_category_order.category_id = '6708')
WHERE (
content.parent_id IN (6708) OR content.id IN (SELECT p.content_id FROM webshop_product_category AS pc JOIN webshop_products AS p ON pc.product_id = p.id WHERE pc.category_id IN (6708))
)
AND content.status ='1'
AND content.type = 'product'
ORDER BY webshop_product_category_order.position
LIMIT 0, 3
'
. En gaf de volgende MySQL fout: Disk full (/tmp/#sql_d29_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")