select t.id,t.nazov,t.meno,t.dlzka,t.dc,studio.meno from (select p.id as id,p.nazov as nazov,skupina.meno as meno, p.dlzka as dlzka, cd.nazov as cd p.studio_id as st_id from (select * from piesen ordrred by id asc limit 50 offset 900000) p
join cd on cd.id=p.cd_id
join skupina on skupina.id=cd.skupina_id
where p.nazov like '%' and skupina.meno like '%') t
join studio on studio.id = t.st_id