Got error 28 from storage engine [select bnb.*, options.*,
case when bnb.email != '' then bnb.email
else ' '
end as email,
case when member_type != 'associate' and member_type != 'non' then concat('http://www.', url)
when member_type = 'associate' then concat('http://www.bnb-network.com/bed-breakfast/', replace(replace(lower(county), '&', 'and'), ' ', '-'), '/', replace(replace(lower(town), '&', 'and'), ' ', '-'), '/', replace(replace(lower(bnb_name), ' ', '-'), '&', 'and') , '.html')
else ''
end as url
from bnb, options
where case when '' != '' then (bnb.country = '' or bnb.additional_search like '%')
else '' != 'Best'
end
and case when 'Armagh' != '' then (bnb.additional_search like '% Armagh' or bnb.additional_search like 'Armagh % ' or bnb.additional_search like '% Armagh% ' or bnb.county = 'Armagh')
else bnb.county != 'Best'
end
and case when 'Keady' != '' then (bnb.town = 'Keady' or additional_search like '%Keady%')
else bnb.town != 'Best'
end
and options.bnb_ref = bnb.bnb_id
and options.active = 'true'
and case when 'all' = 'premium+' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
when 'all' = 'members' then options.member_type != 'non'
when 'all' = 'all' then options.member_type != ''
when 'all' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
when 'all' = 'all-hostels' then bnb.type = 'hostel'
when 'all' = 'network-hotels' then bnb.type like '%hotel%' and options.member_type != 'non'
when 'all' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
when 'all' != '' and 'all' != 'all' and 'all' != 'members' then options.member_type = 'all'
else options.member_type != ''
end
order by options.member_type desc, bnb_name]Got error 28 from storage engine [select bnb.*, options.*,
case when bnb.email != '' then bnb.email
else ' '
end as email,
case when member_type != 'associate' and member_type != 'non' then concat('http://www.', url)
when member_type = 'associate' then concat('http://www.bnb-network.com/bed-breakfast/', replace(replace(lower(county), '&', 'and'), ' ', '-'), '/', replace(replace(lower(town), '&', 'and'), ' ', '-'), '/', replace(replace(lower(bnb_name), ' ', '-'), '&', 'and') , '.html')
else ''
end as url
from bnb, options
where case when '' != '' then (bnb.country = '' or bnb.additional_search like '%')
else '' != 'Best'
end
and case when 'Armagh' != '' then (bnb.additional_search like '% Armagh' or bnb.additional_search like 'Armagh % ' or bnb.additional_search like '% Armagh% ' or bnb.county = 'Armagh')
else bnb.county != 'Best'
end
and case when 'Keady' != '' then (bnb.town = 'Keady' or additional_search like '%Keady%')
else bnb.town != 'Best'
end
and options.bnb_ref = bnb.bnb_id
and options.active = 'true'
and case when 'all' = 'premium+' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
when 'all' = 'members' then options.member_type != 'non'
when 'all' = 'all' then options.member_type != ''
when 'all' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
when 'all' = 'all-hostels' then bnb.type = 'hostel'
when 'all' = 'network-hotels' then bnb.type like '%hotel%' and options.member_type != 'non'
when 'all' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
when 'all' != '' and 'all' != 'all' and 'all' != 'members' then options.member_type = 'all'
else options.member_type != ''
end
order by options.member_type desc, bnb_name]
B&B Accommodation in Keady, Armagh - family homes, hotels, B&B, guest houses, lodgings, ins, travel lodges all over Armagh