GREŠKA: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '19%' order by available asc, (CASE WHEN dostupnost.discountedprice>0 ...' at line 20

Select DISTINCT yachts.id as brodident, yachts.deposit, yachts.charter, yachts.name, yachts.companyid, yachts.locationid, yachts.yachtcategoryid, yachts.yachtmodelname, yachts.yachtbuilderid, yachts.loa, yachts.beam, yachts.cabins, yachts.cabinscrew, yachts.cabinsext, yachts.berthscabin, yachts.berthssalon, yachts.berthscrew, yachts.wc, yachts.wccrew, yachts.buildyear, yachts.aktivan, yachts.wifi, yachts.cijenamin, yachts.ac, yachts.motor, yachts.popust, yachts.engines, yachts.enginepower, slike.local, slike.url, slike.type, charteri.id as charterid, charteri.online, charteri.dohvati, locations.id as locationid, locations.regionid, locations.nameen as lokacija, regije.id as regijaid, regije.countryid, regije.nameen as regijanaziv, builderi.name as buildernaziv , ( CASE WHEN dostupnost.available is null then 1 WHEN dostupnost.available <= 2 then 1 WHEN dostupnost.available >=10 then 10 ELSE 10 END ) as available, dostupnost.price as price, dostupnost.discountedprice as discountedprice, cjenik.price as c_price from danielis_baza3rdn.brodovi yachts inner join danielis_baza3rdn.cjenik cjenik on yachts.id=cjenik.yachtid and cjenik.datefrom<=CAST('2026-06-06' AS DATE) and cjenik.type='WEEKLY' and cjenik.dateto>=CAST('2026-06-13' AS DATE) left join danielis_baza3rdn.dostupnost dostupnost on yachts.id=dostupnost.yachtid and dostupnost.datefrom=CAST('2026-06-06' AS DATE) and dostupnost.dateto=CAST('2026-06-13' AS DATE) inner join danielis_baza3rdn.charteri charteri on yachts.companyid=charteri.id inner join danielis_baza3rdn.lokacije locations on yachts.locationid=locations.id inner join danielis_baza3rdn.brod_buileri builderi on yachts.yachtbuilderid=builderi.id left join danielis_baza3rdn.regije regije on locations.regionid=regije.id left join danielis_baza3rdn.slike slike on slike.yachtid=yachts.id where 1 and yachts.aktivan=1 and (charteri.dohvati=1 or charteri.online=1) and yachts.cijenamin>0 and regije.countryid = 1 and slike.type=1 and yachts.yachtcategoryid = '1' and locations.regionid = '2' and yachts.cabins = 5 and yachts.yachtmodelname like '%Bavaria 51 BT '19%' order by available asc, (CASE WHEN dostupnost.discountedprice>0 THEN dostupnost.discountedprice WHEN yachts.popust>0 THEN c_price * (1-(yachts.popust/100)) ELSE c_price END) asc limit 50 offset 0