Column 'hostelnumber' in field list is ambiguousSELECT position, hostelnumber, hostelname, address1, address2, county, country, yha, release, currency, review_avg, property_type, short_intro, (select Text from SuppInfo where HostelNumber = hostelinfo.HostelNumber and SuppInfo.Type = "Rating" limit 1) as Star, hostelinfo.fr_intro AS LanguageIntro, has_package, hostelinfo.has_hw_availability, hostelinfo.max_pax , SuppInfo.text as shortLangDescription FROM hostelinfo LEFT JOIN SuppInfo ON (SuppInfo.HostelNumber = hostelinfo.hostelnumber AND SuppInfo.type = 'INTRO_fr') WHERE country= 'Cote d' AND county = 'Krakow' AND ( active = 1 OR active&17 = 17 ) AND hostelinfo.has_hw_availability = 1
![]() |
![]() |
| switzerlandhotels.ch |
|