1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by fabric)' at line 1
in:
[(select color_name, color_def, fabric from category_colors where category = order by fabric)]
in:
[(select color_name, color_def, fabric from category_colors where category = order by fabric)]