Warning x

 

We are unable to serve your request at this time. Please try again or contact [email protected]. The error message was: StatementCallback; SQL [ SELECT artist.artist_Forename, artist.artist_Surname, media_library.media_library_File, artwork.artwork_ID, artwork.artwork_Title, artwork.artwork_Category, artwork.artwork_YearStart, lot.lot_ID, lot.lot_LotNo, lot.lot_Sublot, lot.lot_Status, lot.lot_EstimateLow, lot.lot_EstimateHigh, lot.lot_EstimateLowUSD, lot.lot_EstimateHighUSD, lot.lot_SalePrice, lot.lot_SalePriceUSD, auction.auction_AuctionNo, auction.auction_SaleCode, auction.auction_Title, auction.auction_SaleStart, auction.auction_CurrencyCode, auction.auction_PriceType, auction_house.auction_house_ID, auction_house.auction_house_Title, auction_house.auction_house_Location, auction_house.auction_house_DimUnit, auction_house.auction_house_CurrencyCode, auction_company.auction_company_ID, auction_company.auction_company_Title, auction_company.auction_company_Rank, auction_company.auction_company_StockSymbol, auction_company.auction_company_BuyersPremium, auction_company.auction_company_Rating, xref_artwork_artist.xrefaa_NameQualifier, artwork.artwork_yearstartqualifier, artwork.artwork_Height, artwork.artwork_Depth, artwork.artwork_MarkSigned, artwork.artwork_MarkDated, artwork.artwork_Markings, artwork.artwork_Width, artwork.artwork_medium, artwork.artwork_Description, nationality.nationality_Nationality, artist.artist_YearBirth, artist.artist_YearDeath, artwork.artwork_Provenance, artwork.artwork_Condition, artwork.artwork_Exhibition, artwork.artwork_Literature, artwork.artwork_Edition, artwork.artwork_SizeDesc, artist.artist_ID, artwork.artwork_YearEnd, artwork.artwork_YearStartPC, artwork.artwork_YearEndPC, artwork.artwork_yearstartqualifierpc, artwork.artwork_yearendqualifierpc, DATEDIFF(auction.auction_SaleStart, CURDATE()) AS left_days, lookup_rate.lookup_rate_Day, ROUND((MAX(CASE WHEN lookup_rate.lookup_rate_Code = auction.auction_CurrencyCode THEN lookup_rate.lookup_rate_Rate END ) * lot.lot_SalePrice ), 0 ) AS rate_convertedUSD, ROUND((MAX(CASE WHEN lookup_rate.lookup_rate_Code = auction.auction_CurrencyCode THEN lookup_rate.lookup_rate_Rate END) * lot.lot_SalePrice ) / MAX(CASE WHEN lookup_rate.lookup_rate_Code = 'GBP' THEN lookup_rate.lookup_rate_Rate END),0) AS rate_convertedGBP, ROUND(((MAX(CASE WHEN lookup_rate.lookup_rate_Code = auction.auction_CurrencyCode THEN lookup_rate.lookup_rate_Rate END ) * lot.lot_SalePrice ) / MAX(CASE WHEN lookup_rate.lookup_rate_Code = 'EUR' THEN lookup_rate.lookup_rate_Rate END )), 0 ) AS rate_convertedEUR, ROUND(MAX(CASE WHEN auction.auction_CurrencyCode = 'USD' THEN lot.lot_SalePrice END), 0 ) AS rate_USD, ROUND((MAX(CASE WHEN auction.auction_CurrencyCode = 'USD' THEN lot.lot_SalePrice END)) / MAX(CASE WHEN lookup_rate.lookup_rate_Code = 'GBP' THEN lookup_rate.lookup_rate_Rate END),0) AS rate_GBP, ROUND((MAX(CASE WHEN auction.auction_CurrencyCode = 'USD' THEN lot.lot_SalePrice END)) / MAX(CASE WHEN lookup_rate.lookup_rate_Code = 'EUR' THEN lookup_rate.lookup_rate_Rate END ), 0 ) AS rate_EUR FROM lot INNER JOIN auction ON auction.auction_AuctionNo = lot.lot_AuctionNo INNER JOIN auction_admin ON auction_admin.auction_admin_AuctionNo = auction_auctionno INNER JOIN auction_house ON auction_house.auction_house_ID = auction_auctionhouseid INNER JOIN auction_company ON auction_house.auction_house_CompanyID = auction_company.auction_company_ID INNER JOIN xref_artwork_lot ON lot.lot_ID = xrefla_lotid INNER JOIN artwork ON xref_artwork_lot.xrefla_ArtworkID = artwork_id INNER JOIN xref_artwork_artist ON artwork.artwork_ID = xrefaa_artworkid INNER JOIN artist ON xref_artwork_artist.xrefaa_ArtistID = artist_id LEFT JOIN xref_artwork_media ON xref_artwork_media.xrefakm_ArtworkID = artwork.artwork_ID LEFT JOIN media_library ON xref_artwork_media.xrefakm_MediaID = media_library.media_library_ID INNER JOIN nationality ON nationality.nationality_ArtistID = artist.artist_ID, lookup_rate WHERE (artist_id = '271609') AND (lot_ID = '7915882') and (lookup_rate_Day = auction.auction_SaleStart or lookup_rate_Day = (select lookup_rate_Day from lookup_rate where lookup_rate_Day != '' and lookup_rate_Day > '2019-01-01' limit 1))GROUP BY lookup_rate.lookup_rate_Day UNION SELECT artist.artist_Forename, artist.artist_Surname, media_library.media_library_File, artwork.artwork_ID, artwork.artwork_Title, artwork.artwork_Category, artwork.artwork_YearStart, lot.lot_ID, lot.lot_LotNo, lot.lot_Sublot, lot.lot_Status, lot.lot_EstimateLow, lot.lot_EstimateHigh, lot.lot_EstimateLowUSD, lot.lot_EstimateHighUSD, lot.lot_SalePrice, lot.lot_SalePriceUSD, auction.auction_AuctionNo, auction.auction_SaleCode, auction.auction_Title, auction.auction_SaleStart, auction.auction_CurrencyCode, auction.auction_PriceType, auction_house.auction_house_ID, auction_house.auction_house_Title, auction_house.auction_house_Location, auction_house.auction_house_DimUnit, auction_house.auction_house_CurrencyCode, auction_company.auction_company_ID, auction_company.auction_company_Title, auction_company.auction_company_Rank, auction_company.auction_company_StockSymbol, auction_company.auction_company_BuyersPremium, auction_company.auction_company_Rating, xref_artwork_artist.xrefaa_NameQualifier, artwork.artwork_yearstartqualifier, artwork.artwork_Height, artwork.artwork_Depth, artwork.artwork_MarkSigned, artwork.artwork_MarkDated, artwork.artwork_Markings, artwork.artwork_Width, artwork.artwork_medium, artwork.artwork_Description, nationality.nationality_Nationality, artist.artist_YearBirth, artist.artist_YearDeath, artwork.artwork_Provenance, artwork.artwork_Condition, artwork.artwork_Exhibition, artwork.artwork_Literature, artwork.artwork_Edition, artwork.artwork_SizeDesc, artist.artist_ID, artwork.artwork_YearEnd, artwork.artwork_YearStartPC, artwork.artwork_YearEndPC, artwork.artwork_yearstartqualifierpc, artwork.artwork_yearendqualifierpc, DATEDIFF(auction.auction_SaleStart, CURDATE()) AS left_days, lookup_rate.lookup_rate_Day, 0 AS rate_convertedUSD, 0 AS rate_convertedGBP, 0 AS rate_convertedEUR, 0 AS rate_USD, 0 AS rate_GBP, 0 AS rate_EUR FROM lot INNER JOIN auction ON auction.auction_AuctionNo = lot.lot_AuctionNo INNER JOIN auction_admin ON auction_admin.auction_admin_AuctionNo = auction_auctionno INNER JOIN auction_house ON auction_house.auction_house_ID = auction_auctionhouseid INNER JOIN auction_company ON auction_house.auction_house_CompanyID = auction_company.auction_company_ID INNER JOIN xref_artwork_lot ON lot.lot_ID = xrefla_lotid INNER JOIN artwork ON xref_artwork_lot.xrefla_ArtworkID = artwork_id INNER JOIN xref_artwork_artist ON artwork.artwork_ID = xrefaa_artworkid INNER JOIN artist ON xref_artwork_artist.xrefaa_ArtistID = artist_id LEFT JOIN xref_artwork_media ON xref_artwork_media.xrefakm_ArtworkID = artwork.artwork_ID LEFT JOIN media_library ON xref_artwork_media.xrefakm_MediaID = media_library.media_library_ID INNER JOIN nationality ON nationality.nationality_ArtistID = artist.artist_ID, lookup_rate WHERE (artist_id = '271609') AND (lot_ID != '7915882') limit 9'2.5E9' in column '12' is outside valid range for the datatype INTEGER.; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '2.5E9' in column '12' is outside valid range for the datatype INTEGER.