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, 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_nl') WHERE county='Linz' AND ( active = 1 OR active&17 = 17 ) AND hostelinfo.has_hw_availability = 1
![]() |
|
|||||||
Hostels | Tours | Railpasses | Podcasts |
|
|||||||
| Austria
Hostels |
||
Belgium
Hostels |
||
Bulgaria
Hostels |
||
Croatia
Hostels |
||
Czech
Republic Hostels |
||
| |
Denmark
Hostels |
|
England
Hostels |
||
Estonia
Hostels |
||
| |
Finland
Hostels |
|
France
Hostels |
Avignon, Biarritz, Bordeaux, Cannes, Lyon, Nice, Paris, Strasbourg, Toulouse |
|
Germany
Hostels |
Berlin, Cologne, Dresden, Frankfurt, Hamburg, Heidelberg, Munich |
|
Greece
Hostels |
Athens, Corfu, Crete, Ios, Mykonos, Olympia, Paros, Santorini |
|
Hungary
Hostels |
||
Iceland
Hostels |
||
Ireland
Hostels |
||
Italy
Hostels |
Amalfi, Bologna, Capri, Cinque Terre, Florence, Milan, Naples, Rome, Siena, Venice |
|
Latvia
Hostels |
||
Lithuania
Hostels |
||
Luxembourg
Hostels |
||
Netherlands
Hostels |
||
Northern
Ireland Hostels |
||
Norway
Hostels |
||
Poland
Hostels |
||
Portugal
Hostels |
||
Romania
Hostels |
||
Scotland
Hostels |
||
Slovakia
Hostels |
||
Slovenia
Hostels |
||
Spain
Hostels |
Barcelona, Cordoba, Costa del Sol, Granada, Ibiza, Madrid, San Sebastian, Seville |
|
Sweden
Hostels |
||
Switzerland
Hostels |
Bern, Geneva, Grindelwald, Interlaken, Lauterbrunnen, Lucerne, Montreaux, Zurich |
|
Wales
Hostels |