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 ( 91 ) AND
ART.deleted IS NULL AND
ARTISTS.deleted IS NULL
ORDER BY ART.id
Art | The Electric Gallery - Egallery - Fine Art - The Art Shopping Source