Go back to John Temple Gallery home page Image Gallery Special Exhibition New Images Send Free Post Card Contact us and gallery location About John Temple
  John Temple Gallery » Collections » Mountains » T0385 My Account  |  Cart Contents  |  Checkout   
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'johntemp_jtgdb.popt.sortString' which is not in SELECT list; this is incompatible with DISTINCT

select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes_classes patrib,products_to_attribute_classes ptoa where ptoa.product_id=' 311' and patrib.class_name_id=ptoa.class_id and patrib.options_id=popt.products_options_id and popt.language_id = '1' order by popt.sortString ASC