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,content.parent,content.image,webshop_products.in_stock,webshop_products.stock,webshop_products.price,webshop_products.is_new,webshop_products.badge,webshop_products.special_price,webshop_products.id,webshop_products.relation_id, webshop_products.description_short, webshop_products.stock
FROM content
LEFT JOIN webshop_products ON content.id = webshop_products.relation_id
WHERE (
content.parent IN (28) OR content.id IN (SELECT p.relation_id FROM webshop_product_category AS pc JOIN webshop_products AS p ON pc.product_id = p.id WHERE pc.category_id IN (28))
)
AND content.status ='1'
AND content.type = 'product'
ORDER BY price_sort ASC
LIMIT 0, 24
'
. En gaf de volgende MySQL fout: Disk full (/tmp/#sql_d29_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")