create table tmpa  
(  
   tmpaId           bigint not null auto_increment,  
   clrGroupId           bigint,  
   sort                 bigint,  
   name                 varchar(128),  
   primary key (tmpaId)  
); 

create table tmpb  
(  
   tmpbId           bigint not null auto_increment,  
   tmpaId           bigint,  
   sort                 bigint,  
   name                 varchar(128),  
   alias                varchar(128),  
   C                    decimal(8,5),  
   M                    decimal(8,5),  
   Y                    decimal(8,5),  
   K                    decimal(8,5),  
   R                    decimal(8,5),  
   G                    decimal(8,5),  
   B                    decimal(8,5),  
   Hex                  varchar(128),  
   ColorId              varchar(128),  
   primary key (tmpbId)  
); 

select * from tmpa as t1,  
(  
  (select * from tmpb where `sort` = 0) as c1,  
  (select * from tmpb where `sort` = 1) as c2,  
  (select * from tmpb where `sort` = 2) as c3,  
  (select * from tmpb where `sort` = 3) as c4,  
  (select * from tmpb where `sort` = 4) as c5  
) where  
  t1.tmpaId = c1.tmpaId  
  and t1.tmpaId = c2.tmpaId  
  and t1.tmpaId = c3.tmpaId  
  and t1.tmpaId = c4.tmpaId  
  and t1.tmpaId = c5.tmpaId  
  order by t1.clrGroupId, t1.sort asc;