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
 
Exhibitions
GO
Design-led contemporary homeware and gifts
Login | Register | Need help?
YOUR BASKET
Items:
0
Total:
£0.00
 
  • GIFTS 
  • PRODUCT TYPE 
  • BY DESIGNER 
Latest News
Dec 08
Shop online and collect from the shop
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!  
Read More...
Oct 17
Christmas stock arriving

 We're busy unpacking lots of lovely new stock. the Maileg Mice are here and we are expecting new items in from ISAK, Superliving and Pluto Produkter this week!

  
Read More...
Jul 03
Celebrate Independents' Day with 10% off all purchases

 Celebrate Independents' Day with 10% off all purchases

  
Read More...

View All News

 

North Rock Gallery Accepts These Credit Cards Secured By Sage Pay
Home :: Manufacturers

Manufacturers

Manufacturers