select * from `filmy`
left join `filmy_tagi` on `filmy`.`id`=`filmy_tagi`.`filmID`
where `status`='1' and `tytul` like '%Ev'ry%' or `status`='1' and `opis` like '%Ev'ry%' or `status`='1' and `tag` like '%Ev'ry%' group by `filmy`.`id` order by `filmy`.`id` desc
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ry%' or `status`='1' and `opis` like '%Ev'ry%' or `status`='1' and `tag` lik' at line 3