Warning:  [mysql error 1021] Disk full (/tmp/#sql_489_0); waiting for someone to free some space...
SELECT i.latitude, i.longitude,
    IFNULL(i.name, '') AS `name`,
    TRIM(LEADING '.' FROM IF(i.representative_ext IS NULL,
        CONCAT(LEFT(i.path,LENGTH(i.path)-1-LENGTH(SUBSTRING_INDEX(i.path, '.', -1 ))), '-sq.', SUBSTRING_INDEX(i.path, '.', -1 )),
            REPLACE(i.path, TRIM(TRAILING '.' FROM SUBSTRING_INDEX(i.path, '/', -1 )),
                CONCAT('pwg_representative/',
                    CONCAT(
                        TRIM(TRAILING '.' FROM SUBSTRING_INDEX( SUBSTRING_INDEX(i.path, '/', -1 ) , '.', 1 )),
                        CONCAT('-sq.', i.representative_ext)
                    )
                )
            )
    )) AS `pathurl`,
    TRIM(TRAILING '/' FROM CONCAT( i.id, '/category/', IFNULL(ic.category_id, '') ) ) AS `imgurl`,
    IFNULL(i.comment, '') AS `comment`,
    IFNULL(i.author, '') AS `author`,
    i.width
        FROM piwigo_images AS i
            INNER JOIN (piwigo_image_category AS in /var/www/html/photos/include/dblayer/functions_mysqli.inc.php on line 845