Expression #1 of ORDER BY clause is not in SELECT list, references column 'mbox9501_jdjl.category_filters.sequence' which is not in SELECT list; this is incompatible with DISTINCT--select distinct category_filters.title,prod_name from prod_filters,category_filters,products where prod_filters.cat_filter_id = category_filters.id and prod_filters.prod_id = products.id and products.id in (88) and category_filters.active = 1 group by category_filters.id order by category_filters.sequence