Unknown MySQL server host 'insigaa2.memset.net' (1)
[select
event_id, name, venue, town, county, region, locality, country, description, category, annual,
case when char_length(url) < 5 then ' '
else url
end as url,
case when char_length(email) < 5 or email is null then ' '
else concat('www.irishdays.com/contact/', replace(lower(name), ' ', '-'), '.html')
end as contact,
case when char_length(accom_url) < 5 then concat('www.', lower(county), '-bnb.com')
else accom_url
end as accom_url,
case when month(start_date) = month(end_date) and day(start_date) = day(end_date) then date_format(start_date, '%e %b')
when month(start_date) = month(end_date) then concat(date_format(start_date, '%e'), ' - ', date_format(end_date, '%e'), '
', date_format(end_date, '%b'))
else concat(date_format(start_date, '%e %b'), '
-
', date_format(end_date, '%e %b'))
end as dates
from events
where name != ''
and case when 'Ireland' != '' then (country = 'Ireland' or region like '%Ireland')
else 'Ireland' != 'Best'
end
and case when 'Dublin' != '' then (region like '%Dublin%' or county = 'Dublin')
else county != 'Best'
end
and case when '' != '' then town = ''
else town != 'Best'
end
and active = 'true'
and case when 'exhibition' != 'all' then category = 'exhibition'
else category != ''
end
and year(end_date) >= year(current_date)
]Unknown MySQL server host 'insigaa2.memset.net' (1)
[select
event_id, name, venue, town, county, region, locality, country, description, category, annual,
case when char_length(url) < 5 then ' '
else url
end as url,
case when char_length(email) < 5 or email is null then ' '
else concat('www.irishdays.com/contact/', replace(lower(name), ' ', '-'), '.html')
end as contact,
case when char_length(accom_url) < 5 then concat('www.', lower(county), '-bnb.com')
else accom_url
end as accom_url,
case when month(start_date) = month(end_date) and day(start_date) = day(end_date) then date_format(start_date, '%e %b')
when month(start_date) = month(end_date) then concat(date_format(start_date, '%e'), ' - ', date_format(end_date, '%e'), '
', date_format(end_date, '%b'))
else concat(date_format(start_date, '%e %b'), '
-
', date_format(end_date, '%e %b'))
end as dates
from events
where name != ''
and case when 'Ireland' != '' then (country = 'Ireland' or region like '%Ireland')
else 'Ireland' != 'Best'
end
and case when 'Dublin' != '' then (region like '%Dublin%' or county = 'Dublin')
else county != 'Best'
end
and case when '' != '' then town = ''
else town != 'Best'
end
and active = 'true'
and case when 'exhibition' != 'all' then category = 'exhibition'
else category != ''
end
and year(end_date) >= year(current_date)
]
| Exhbitions & Conferences 0 of |
Using Google - search for:- Dublin events activities bed breakfast B&B Hotels lodgings