product_name  attribute_name attribute_value
----------------------------------------------------------
     test1           catname        abc
     test2           catname        ccc
     test3           catname        ###
     test4           catname        bbb

ORDER BY if(attribute_value = '' or attribute_value is null,1,0),attribute_value ,product_name