SELECT termekek.id, termek_tul.name, termekek.jog, termekek.csop, termek_tul.description FROM termekek left join termek_tul on termekek.id = termek_tul.termek_id WHERE parent='2' AND lang = 'en' AND termek_tul.enabled = 'enabled' ORDER BY sorrend

Ágnes Daróczi	Ceija Stojka	Nicolae Gheorghe
Hans Caldaras	Romani Rose	Rosa Taikon
Sandra Jayat