Warning:  [mysql error 1021] Disk full (/tmp/#sql-temptable-390-3b72fa3-bc7b.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/ftp/kammel/cannescorporate.com/gallery/include/dblayer/functions_mysqli.inc.php on line 845