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 'order by type asc limit 1' at line 1select distinct yachts.id as brodident, yachts.name, yachts.yachtmodelname, yachts.cabins, yachts.cabinscrew, yachts.berthscabin, yachts.berthssalon, yachts.maxpersons,
yachts.popust, yachts.berthscrew, yachts.wc, yachts.wccrew, yachts.buildyear, yachts.wifi, yachts.cijenamin, yachts.ac, yachts.generator, slike.local, slike.url, locations.nameen as lokacija from danielis_baza3rdn.brodovi yachts inner join danielis_baza3rdn.charteri charteri on yachts.companyid=charteri.id
inner join danielis_baza3rdn.lokacije locations on yachts.locationid=locations.id
left join danielis_baza3rdn.regije regije on locations.regionid=regije.id
left join (Select * from danielis_baza3rdn.slike where type=1 group by yachtid) slike on slike.yachtid=yachts.id
where 1 and yachts.aktivan=1 and charteri.online=1 and yachts.cijenamin>0 and regije.countryid = 100116 and slike.type=1 order by yachts.cijenamin asc limit xx offset xx