[SELECT DISTINCT(UCASE(SUBSTRING(category,1,1))) as letter FROM `products` WHERE domen='dk' ORDER BY category][Expression #1 of ORDER BY clause is not in SELECT list, references column 'gran.products.category' which is not in SELECT list; this is incompatible with DISTINCT] Kategori A-Z

Shopin