INVALID SQL: 1052 : Column 'avail' in where clause is ambiguous SQL QUERY FAILURE:SELECT xcart_manufacturers.*, xcart_images_M.image_path, xcart_images_M.image_x, xcart_images_M.image_y, 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 avail = 'Y' ORDER BY xcart_manufacturers.orderby, manufacturer LIMIT 0, 75 North Rock Gallery :: Manufacturers
Would you like to shop online and collect in the shop later?
We've set up our website so now you can. Order online as normal and type COLLECT in the coupon box at checkout and we'll pack your order ready for you to come along and collect next time you are in town!