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 = 1869 AND a.articlePublishDT < '2013-12-07 20:07:49' AND a.articleIsHidden = 0 GROUP BY at1.articleID, a.articleHeadline, a.articleLabel HAVING at1.articleID != 1869 ORDER BY COUNT(at1.tagID) DESC, a.articlePublishDT DESC
Companies that limit their use of EDI to fundamental transactions, such as purchase orders and invoices, are missing an opportunity to strengthen their customer service and overall competitiveness, writes Chad Collins, HighJump Software.
Companies in last-mile logistics need to make the most of their data assets to power real-time exchange between data in core systems to the diverse systems of customers and partners. Ensenda’s Rob Howard explains how trading partners can streamline their data exchange.
As volumes increase and deadlines get shorter, it’s imperative that logistics software systems have out-of-the-box communication with other companies using the same system, and easy setup of communications with companies using other systems.
Electronic data interchange (EDI) technology and infrastructure is adapting to help businesses more quickly and accurately share information within the corporation and across the supply chain.
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 (42)
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 (42)))ORDER BY profileName