Self Catering Holiday Homes

Host 'insigaa1.memset.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
[select property.name, property.town, property.county, property.description, property.sleeps, property.picture, concat('http://www.irishholidayrentals.com/', lower(property.county), '/', lower(replace(property.town, ' ', '-')), '/', lower(replace(replace(property.name, "\'", '_'), ' ', '-')), '.html') as url, options.*, days.rate as rate, '' as rooms from property, options, days where case when 'Ireland' != '' then (property.country = 'Ireland' or property.additional_search like '%Ireland') else 'Ireland' != 'Best' end and case when 'Kerry' != '' then (property.additional_search like '% Kerry %' or property.additional_search like '% Kerry' or property.additional_search like 'Kerry %' or property.additional_search = 'Kerry' or property.county = 'Kerry') else property.county != 'Best' end and case when 'Ireland' = '' and 'Kerry' = '' and 'Waterville' != '' then (town like 'Waterville%' or additional_search like '%Waterville%') when 'Waterville' != '' then (property.town = 'Waterville' or additional_search like '%Waterville%') else property.town != 'Best' end and options.prop_id = property.prop_id and options.active = 'true' and days.prop_id = property.prop_id AND (@dayYear := if(`day` < date_format(current_date, '%j'), year(current_date) + 1, year(current_date))) is not null AND (@dayDate := if(1, date_add(concat(@dayYear, '01', '01'), interval `day` - 1 day), current_date)) is not null AND date_format(@dayDate, '%w') = 6 AND @dayDate between current_date and date_add(current_date, interval 7 day) ]error: Host 'insigaa1.memset.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
[select property.name, property.town, property.county, property.description, property.sleeps, property.picture, concat('http://www.irishholidayrentals.com/', lower(property.county), '/', lower(replace(property.town, ' ', '-')), '/', lower(replace(replace(property.name, "\'", '_'), ' ', '-')), '.html') as url, options.*, days.rate as rate, '' as rooms from property, options, days where case when 'Ireland' != '' then (property.country = 'Ireland' or property.additional_search like '%Ireland') else 'Ireland' != 'Best' end and case when 'Kerry' != '' then (property.additional_search like '% Kerry %' or property.additional_search like '% Kerry' or property.additional_search like 'Kerry %' or property.additional_search = 'Kerry' or property.county = 'Kerry') else property.county != 'Best' end and case when 'Ireland' = '' and 'Kerry' = '' and 'Waterville' != '' then (town like 'Waterville%' or additional_search like '%Waterville%') when 'Waterville' != '' then (property.town = 'Waterville' or additional_search like '%Waterville%') else property.town != 'Best' end and options.prop_id = property.prop_id and options.active = 'true' and days.prop_id = property.prop_id AND (@dayYear := if(`day` < date_format(current_date, '%j'), year(current_date) + 1, year(current_date))) is not null AND (@dayDate := if(1, date_add(concat(@dayYear, '01', '01'), interval `day` - 1 day), current_date)) is not null AND date_format(@dayDate, '%w') = 6 AND @dayDate between current_date and date_add(current_date, interval 7 day) ]