SQLize Online / PHPize Online  /  SQLtest Online

create table links_data ( id int, userURL1 int, partnerURL1 int, userURL2 int, partnerURL2 int ); insert into links_data values (1, 1, 2, 3, 4), (2, 4, 3, 2, 1); create table links_extra ( id int, url varchar(255) ); insert into links_extra values (1, 'link1'),(2, 'link2'),(3, 'link3'),(4, 'link4'); select ld.*, GROUP_CONCAT(le.url order by ld.userURL1=le.id desc, ld.partnerURL1=le.id desc, ld.partnerURL2=le.id desc, ld.userURL2=le.id ) as urls from links_data as ld inner join links_extra as le on ld.userURL1=le.id or ld.partnerURL1=le.id or ld.partnerURL2=le.id or ld.userURL2=le.id group by id, userURL1, partnerURL1, userURL2, partnerURL2 ;