SELECT ART.id AS art_id, ART.title, ART.subtitle, ART.media, ART.year, ART.size, ART.extra, ART.artist_notes, ART.shop_noexport, ART.shop_description, ART.keywords, ART.created, UNIX_TIMESTAMP(ART.modified)as modified, GROUPS.name AS group_name, GROUPS.id as group_id, ARTISTS.name AS artist_name, ARTISTS.lastname AS artist_lastname, ARTISTS.id AS artist_id, COLLECTIONS.name AS collection_name, COLLECTIONS.id AS collection_id, COLLECTIONS.nickname AS collection_nickname FROM tblArtists ARTISTS, tblCollections COLLECTIONS, tblArt ART LEFT JOIN tblGroups GROUPS ON ART.group_id = GROUPS.id WHERE ARTISTS.id = ART.artist_id AND COLLECTIONS.id = ARTISTS.collection_id AND ART.id IN ( 953 ) AND ART.deleted IS NULL AND ARTISTS.deleted IS NULL ORDER BY ART.id
The artwork you requested was not found. |