Catamaran Croatia Search Results

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 ') group by yachts.id order by yachts.cijenamin asc, yachts.id asc' at line 11

Select yachts.id as brodident, yachts.id as brodid, yachts.charter, yachts.name, yachts.companyid, yachts.locationid, yachts.yachtcategoryid, yachts.yachtmodelname, yachts.yachtbuilderid, yachts.loa, yachts.cabins, yachts.cabinscrew, yachts.berthscabin, yachts.berthssalon, yachts.berthscrew, yachts.wc, yachts.wccrew, yachts.buildyear, yachts.aktivan, yachts.wifi, yachts.cijenamin, yachts.ac, yachts.popust, 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 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 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 yachts.yachtcategoryid = '2' and slike.type=1 and locations.regionid in (Bali, ) group by yachts.id order by yachts.cijenamin asc, yachts.id asc