<b>Fatal Error</b>: Error: Error writing file '/tmp/MYfd=120' (OS errno 28 - No space left on device)<br />Error No: 3<br />SELECT t.product_id, t.top_id, cd.name AS top_name
        FROM (
            SELECT p.product_id,
                MIN(COALESCE(
                    IF(c2.parent_id = 0, c2.category_id, NULL),
                    IF(c1.parent_id = 0, c1.category_id, NULL),
                    c0.category_id
                )) AS top_id
            FROM product p
            JOIN product_to_category p2c ON p.product_id = p2c.product_id
            JOIN category c0 ON p2c.category_id = c0.category_id
            LEFT JOIN category c1 ON c0.parent_id = c1.category_id AND c0.parent_id > 0
            LEFT JOIN category c2 ON c1.parent_id = c2.category_id AND c1.parent_id > 0
            WHERE p.attr_preventa_web = 1 AND p.status = 1
            GROUP BY p.product_id
        ) t
        JOIN category_description cd ON cd.category_id = t.top_id AND cd.language_id = 1
        ORDER BY top_name in <b>/var/www/bookish-org/system/database/mysql_i.php</b> on line <b>116</b><br/><br/>