Unknown MySQL server host 'insigaa2.memset.net' (1)
[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.continent = '' or bnb.additional_search like '%')
else '' != 'Best'
end
and case when 'Northern Ireland' != '' then (bnb.country = 'Northern Ireland' or bnb.additional_search like '%Northern Ireland')
else 'Northern Ireland' != 'Best'
end
and case when 'Down' != '' then (bnb.additional_search like '% Down %' or bnb.additional_search like '% Down' or bnb.additional_search like 'Down %' or bnb.additional_search = 'Down' or bnb.county = 'Down')
else bnb.county != 'Best'
end
and case when 'Northern Ireland' = '' and 'Down' = '' and '' != '' then (town like '%' or additional_search like '%%')
when '' != '' then (bnb.town = '' or additional_search like '%%')
else bnb.town != 'Best'
end
and options.bnb_ref = bnb.bnb_id
and options.active = 'true'
and case when 'bed-breakfast' = 'premium+' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
when 'bed-breakfast' = 'bed-breakfast' then options.member_type != 'non' and member_type !='nad'
when 'bed-breakfast' = 'accommodation' then options.member_type != ''
when 'bed-breakfast' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
when 'bed-breakfast' = 'hostels-accommodation' then bnb.type = 'hostel'
when 'bed-breakfast' = 'premium' then (options.member_type = 'premium' or options.member_type = 'guesthouse' or options.member_type = 'premium+')
when 'bed-breakfast' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
when 'bed-breakfast' != '' and 'bed-breakfast' != 'accommodation' and 'bed-breakfast' != 'accommodation' then options.member_type = 'bed-breakfast'
else options.member_type != ''
end
]Unknown MySQL server host 'insigaa2.memset.net' (1)
[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.continent = '' or bnb.additional_search like '%')
else '' != 'Best'
end
and case when 'Northern Ireland' != '' then (bnb.country = 'Northern Ireland' or bnb.additional_search like '%Northern Ireland')
else 'Northern Ireland' != 'Best'
end
and case when 'Down' != '' then (bnb.additional_search like '% Down %' or bnb.additional_search like '% Down' or bnb.additional_search like 'Down %' or bnb.additional_search = 'Down' or bnb.county = 'Down')
else bnb.county != 'Best'
end
and case when 'Northern Ireland' = '' and 'Down' = '' and '' != '' then (town like '%' or additional_search like '%%')
when '' != '' then (bnb.town = '' or additional_search like '%%')
else bnb.town != 'Best'
end
and options.bnb_ref = bnb.bnb_id
and options.active = 'true'
and case when 'bed-breakfast' = 'premium+' then (options.member_type = 'guesthouse' or options.member_type like 'premium%')
when 'bed-breakfast' = 'bed-breakfast' then options.member_type != 'non' and member_type !='nad'
when 'bed-breakfast' = 'accommodation' then options.member_type != ''
when 'bed-breakfast' = 'hostels' then bnb.type = 'hostel' and options.member_type != 'non'
when 'bed-breakfast' = 'hostels-accommodation' then bnb.type = 'hostel'
when 'bed-breakfast' = 'premium' then (options.member_type = 'premium' or options.member_type = 'guesthouse' or options.member_type = 'premium+')
when 'bed-breakfast' = 'network-guesthouses' then bnb.type like '%guesthouse%' and options.member_type != 'non'
when 'bed-breakfast' != '' and 'bed-breakfast' != 'accommodation' and 'bed-breakfast' != 'accommodation' then options.member_type = 'bed-breakfast'
else options.member_type != ''
end
]