Error executing the SQL query:
select bnb.bnb_id, bnb.bnb_name, bnb.town, bnb.county, options.member_type, bnb.email, case when email != '' and member_type = 'non' then concat('/contact/', lower(replace(bnb.bnb_name, ' ', '-')), '_', lower(replace(bnb.town, ' ', '-')), '.html') when email != '' and (member_type = 'full' or member_type = 'premium') then concat('http://www.', bnb.url) when email != '' then concat('http://www.bnb-network.com/redirect.php?id=', bnb.bnb_id) else '' end as url, case when member_type = 'guesthouse' then 'z' when member_type = 'non' then 'a' else member_type end as memtype from bnb, options where options.active = 'true' and bnb.bnb_id = options.bnb_refbnb.county = 'Kerry' and (bnb.type = 'guesthouse' or bnb.type like '%hotel%') and country = 'Ireland' and bnb.town = 'Killarney' order by memtype desc, bnb_name limit 0,20
Unknown column 'options.bnb_refbnb.county' in 'where clause'