'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) ) OR ( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) ) OR ( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) ) OR ( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) ) OR ( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
'SELECT DISTINCT COUNT(*) As Records FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) ) OR ( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) ))'
'SELECT DISTINCT s.post_id, s.author_id, s.image_guid, s.image_id, s.artist_guid, s.artist_id, s.artist_slug, s.artist, s.post_title, s.pub_date, s.image_type_id as image_color_type_id, s.language_id, s.keywords, s.country, s.allowed_sites, s.file_name, s.format FROM dw_cci_search AS s WHERE (s.post_id IS NOT NULL) AND (s.language_id = 1 ) AND (( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}roofs{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) ) OR ( (s.post_title LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) OR (s.keywords LIKE \'{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\\"roofs\\"{f3843526615b4bc0259cd54e2a7cdf3db4d68f9c98b856ef933ac4a2accf537e}\' ) )) ORDER BY s.pub_date DESC, s.image_id DESC LIMIT 20;'
snow, ice, winter, freezing temperatures, cold, blizzard, record snow, roof collapse, damage, roofs, deep snow, record cold, deep freeze, long winter, old man winter, big foot, snowman, car accidents, snow removal, dpw, plowing, snowing, frigid
