An Error Was Encountered
Error Number: 1064
You have an error in your SQL syntax near '? AND p.product_type <> 'C' AND p.forsale <> 'B' AND xcart_quick_prices.priceid ' at line 1
SELECT p.*, p.avail AS avail, MIN(xcart_pricing.price) as price , xcart_manufacturers.manufacturer, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_quick_prices.priceid, xcart_categories.cdseo_url as category_url, xcart_categories.category FROM xcart_pricing, xcart_products p LEFT JOIN xcart_manufacturers ON xcart_manufacturers.manufacturerid = p.manufacturerid LEFT JOIN xcart_quick_prices ON p.productid = xcart_quick_prices.productid LEFT JOIN xcart_quick_flags ON p.productid = xcart_quick_flags.productid LEFT JOIN xcart_products_categories ON p.productid = xcart_products_categories.productid LEFT JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid WHERE p.cdseo_url = ? AND p.product_type <> 'C' AND p.forsale <> 'B' AND xcart_quick_prices.priceid = xcart_pricing.priceid AND xcart_products_categories.main = 'Y' GROUP BY p.productid