SELECT a.articleHeadline, a.articleLabel, at1.articleID, COUNT(at2.tagID) AS common_tag_count FROM articles AS a INNER JOIN articleTags AS at1 ON at1.articleID = a.articleID INNER JOIN tags AS t1 ON t1.tagID = at1.tagID INNER JOIN articleTags AS at2 ON at2.tagID = t1.tagParentID WHERE at2.articleID = 178 AND a.articlePublishDT < '2013-12-13 00:08:55' AND a.articleIsHidden = 0 GROUP BY at1.articleID, a.articleHeadline, a.articleLabel HAVING at1.articleID != 178 ORDER BY COUNT(at1.tagID) DESC, a.articlePublishDT DESC
Regulatory compliance is top supply chain challenge for healthcare executives; Ohio’s transportation funding plan pays dividends with bridge repair program; GM saves $40 million a year by co-locating stamping and assembly facilities; Collaboration is the key to sustained procurement savings; U.S. domestic intermodal surpasses international as growth driver.
The automotive aftermarket’s logistics trends, challenges, and best practices give shippers a wild ride.
Vehicle glass manufacturer Safelite increased distribution efficiency, enhanced customer service, and lowered costs by transforming its supply chain.
Tomato canner Red Gold achieves 99-percent inventory accuracy with QuikTrac data collection software from Integrated Barcoding Systems.
To roll out a supply chain overhaul, truck and engine manufacturer Navistar chose third-party logistics provider Menlo as its strategic partner. Ed Melching, director, Global Logistics, describes the project.
Ford revamped its service parts network, processes, and technologies to boost efficiency and set the stage for global service parts logistics management.
Linking bar-coded pharmaceuticals and electronic patient records using Zebra Technologies solutions helps the Sisters of Mercy Health System streamline supply chain operations.
SELECT DISTINCT CONCAT(catName,' web sites') AS headline, CONCAT('/cms/web-cite-city/',catLabel,'/') AS url FROM cats INNER JOIN catTags ON catTags.catID = cats.catID WHERE tagID IN (99,124)
SELECT planner_profiles.*, groupLabel FROM planner_profiles INNER JOIN planner_groups ON planner_groups.groupID = planner_profiles.groupID WHERE groupIsActive = 1 AND profileID IN (SELECT profileID FROM planner_profileCats WHERE catID IN (SELECT catID FROM catTags WHERE tagID IN (99,124)))ORDER BY profileName