Warning:  [mysql error 1021] Disk full (/tmp/#sql-temptable-acb-39bced-158e4f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SELECT
    c.*,
    user_representative_picture_id,
    nb_images,
    date_last,
    max_date_last,
    count_images,
    nb_categories,
    count_categories
  FROM piwigo_categories c
    INNER JOIN piwigo_user_cache_categories ucc
    ON id = cat_id
    AND user_id = 2
  WHERE id_uppercat is NULL
      
  ORDER BY `rank` in /var/www/vhosts/scoutingbrigitta.nl/foto.scoutingbrigitta.nl/include/dblayer/functions_mysqli.inc.php on line 847