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 ]