Function QueryArray: ---SELECT RetailProducts.ID, RetailProducts.Name, RetailProducts.SKU, RetailProducts.ShortDescription, RetailProducts.ListPrice, RetailProducts.FeaturedCategory, RetailProducts.HotItem, RetailProducts.SalesSpecial, RetailProducts.CallForPricing, IF( RetailProductPictures.File IS NULL , (

SELECT `value`
FROM `RetailSettings`
WHERE `key` = 'ImageNA'
), RetailProductPictures.File ) AS `File` , IF( RetailProducts.FeaturedCategory = 'Y', 1, 0 ) AS `FeaturedOrder` , IF( RetailProducts.CallForPricing = 'Y', 'Call For Pricing', IF( RetailProducts.CostDrivenByOption = 'Y', IF( (

SELECT MIN( FORMAT(((0 * RetailProductsOptions.Cost) + RetailProductsOptions.Cost),2)) AS MinValue
FROM RetailProductsOptions
WHERE RetailProductsOptions.OptionID = RetailProducts.CostDriveByOptionID ) != (
SELECT MAX( FORMAT(((0 * RetailProductsOptions.Cost) + RetailProductsOptions.Cost),2)) AS MaxValue
FROM RetailProductsOptions
WHERE RetailProductsOptions.OptionID = RetailProducts.CostDriveByOptionID ) , CONCAT( '$', (

SELECT MIN( FORMAT(((0 * RetailProductsOptions.Cost) + RetailProductsOptions.Cost),2) + 0) AS MinValue
FROM RetailProductsOptions
WHERE RetailProductsOptions.OptionID = RetailProducts.CostDriveByOptionID ) , ' - ', '$', (

SELECT MAX( FORMAT(((0 * RetailProductsOptions.Cost) + RetailProductsOptions.Cost),2) + 0) AS MaxValue
FROM RetailProductsOptions
WHERE RetailProductsOptions.OptionID = RetailProducts.CostDriveByOptionID ) ) , CONCAT( '$', (

SELECT MIN( FORMAT(((0 * RetailProductsOptions.Cost) + RetailProductsOptions.Cost),2) ) AS MinValue
FROM RetailProductsOptions
WHERE RetailProductsOptions.OptionID = RetailProducts.CostDriveByOptionID )
)
), CONCAT( '$', FORMAT(((0 * RetailProducts.Cost) + RetailProducts.Cost),2) )
)
) AS `DisplayCost`
FROM `RetailCategoryRelation`
LEFT JOIN RetailProducts ON RetailProducts.ID = RetailCategoryRelation.ProductID
LEFT JOIN RetailProductPictures ON RetailProductPictures.ID = RetailProducts.DefaultPictureID
WHERE RetailCategoryRelation.CategoryID = '6'
AND RetailProducts.`Live` = 'Y'
ORDER BY `FeaturedOrder` DESC , RetailCategoryRelation.`Order` , RetailProducts.Name ASC
LIMIT  0, 16;--- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MaxValue
FROM RetailProductsOptions
WHERE RetailProductsOptions.OptionID = Ret' at line 11