SELECT pages_uris.id_pages, pages_uris.id_types
FROM descriptions, descriptions_data, pages_uris
WHERE descriptions_data.id_languages = '1'
AND descriptions_data.value = '/Suedeifel/'
AND descriptions.id = descriptions_data.id_descriptions
AND pages_uris.id_descriptions = descriptions.id
Weinhotels im Sauerland
