INVALID SQL: 1054 : Unknown column 'xcart_products.forsale' in 'where clause'
SQL QUERY FAILURE:SELECT xcart_manufacturers.* , IF(xcart_images_M.id IS NULL, '', 'Y') as is_image , xcart_images_M.image_path , IFNULL(xcart_manufacturers_lng.manufacturer , xcart_manufacturers.manufacturer) as manufacturer , IFNULL(xcart_manufacturers_lng.descr, xcart_manufacturers.descr) as descr FROM xcart_manufacturers LEFT JOIN xcart_manufacturers_lng ON xcart_manufacturers.manufacturerid = xcart_manufacturers_lng.manufacturerid AND xcart_manufacturers_lng.code = 'en' LEFT JOIN xcart_images_M ON xcart_manufacturers.manufacturerid = xcart_images_M.id WHERE xcart_manufacturers.avail = 'Y' AND xcart_products.forsale = 'Y' GROUP BY xcart_manufacturers.manufacturerid ORDER BY xcart_manufacturers.manufacturer
The Clay Pot :: Designers
The Clay Pot / Designers