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.it_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_it') WHERE country= 'India' AND county = 'Vienna' AND ( active = 1 OR active&17 = 17 ) AND hostelinfo.has_hw_availability = 1
|
||||||||||||||||||
|
||||||||||||||||||