FUNCTION sugarserials.ANY_VALUE does not exist SELECT ANY_VALUE(americanPsychoText.text) AS text, americanPsychoText.tweetGroup AS apTtweetGroup, americanPsychoImages.tweetGroup AS apItweetGroup, ANY_VALUE(americanPsychoImages.imageID) AS apIimageID, ANY_VALUE(americanPsychoUsedImages.imageID) AS apUIimageID, ANY_VALUE(americanPsychoImages.internalURL) AS internalURL, ANY_VALUE(americanPsychoImages.legacyURL) AS legacyURL, ANY_VALUE(americanPsychoImages.redirectTweetGroupID) AS redirectTweetGroupID, ANY_VALUE(americanPsychoUsedImages.imageID) AS apUIimageID, ANY_VALUE(americanPsychoUsedImages.imageURLFull) AS image, ANY_VALUE(americanPsychoUsedImages.owner) AS owner, ANY_VALUE(americanPsychoUsedImages.externalURL) AS externalURL FROM americanPsychoText, americanPsychoImages, americanPsychoUsedImages WHERE americanPsychoImages.legacyURL = 'ap_0000000706' AND americanPsychoText.tweetGroup = americanPsychoImages.tweetGroup AND americanPsychoImages.imageID = americanPsychoUsedImages.imageID GROUP BY aptTweetGroup ORDER BY apTtweetGroup ASC