select "a-" as test,l.pubid,l.adid, l.startdate,DATE_ADD(l.enddate,INTERVAL 7 DAY) AS enddate,l.classid,l.text,ll.county,l.classid,substring_index(l.text,' ',50) AS groupText from ads.legals_location ll join ads.legals l on l.pubid = ll.pubid and CURDATE() BETWEEN l.startdate AND DATE_ADD(l.enddate,INTERVAL 7 DAY) where ll.county like '%king%' and l.adid like '%%' AND CURDATE() BETWEEN l.startdate AND DATE_ADD(l.enddate,INTERVAL 7 DAY) and l.pubid like '%mir%' group by groupText,l.startdate,l.enddate order by l.text;
Click on the headline or [Full Notice] link to view the entire notice.
Results: 1 found.
CITY OF MERCER ISLAND NOTICE OF SPECIAL MEETING – CITY COUNCIL ANNUAL PLANNING SESSION Notice is hereby given that the Mercer Island City Council will hold its annual planning session January 23-25, 2015 in the Calkins Room at the Mercer Island Community & Event Center (8236 SE 24th Street, Mercer... [Full Notice]
Latest King County business news.
The next Chamber After Hours is also the Valley Young Professionals Hangout, 6 to 9 p.m., Wednesday Jan. 28, at Snoqualmie Casino. Read More ›
A new program at Kirkland-based ATGStores.com offers students with a valid school email address a 10 percent site-wide discount on all purchases at any time of year, with limited manufacturer exclusions. Read More ›
Bartell Drugs supports American Heart Month during February with special offer for cholesterol screening - Redmond ReporterMonday January 26, 2015 at 03:00 PM
Bartell Drugs is spotlighting American Heart Month as the family-owned drugstore chain celebrates its 125th anniversary. High cholesterol is one of the major controllable risk factors for coronary heart disease, and locally-owned Bartell Drugs offers heart-healthy screenings at all 63 locations in King, Snohomish and Pierce counties. Read More ›
In a NerdWallet analysis, Redmond is the No. 1-ranked city in Washington that appeals most to millennial job seekers. Read More ›
Bellevue bests Seattle for top Washington cities for millenial job seekers, according to an analysis by consumer finance site NerdWallet, that population growing nearly 10.5 percent from 2010 to 2013. Read More ›
Alkire appointed clinical director of operations for Novelty Hill Physical Therapy - Redmond ReporterSaturday January 24, 2015 at 08:00 AM
Kendra Alkire, a doctor of physical therapy, has been appointed as the clinical director of operations for Novelty Hill Physical Therapy (NHPT) in Redmond. Read More ›