  |
|
||||||
|
||||||
|
||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||
|
SELECT wArtists.*, webworks.*, WorkImages.*, webworks.OriginalWorkNumber AS thework FROM (wArtists INNER JOIN webworks ON wArtists.ArtistNumber = webworks.ArtistNumber) INNER JOIN WorkImages ON webworks.OriginalWorkNumber = WorkImages.OriginalWorkNumber WHERE (((Right(ucase(WorkImages.Image),7))='_SM.JPG') AND ((trim(webworks.numerator)='1') or (trim(webworks.numerator)='')) AND (wartists.artistnumber=8) AND (webworks.exhibonly=0) ) order by webworks.customsort; |
||||||||||||||||||||||||||||||||||||||||
