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 = 1775 AND a.articlePublishDT < '2013-12-12 16:28:29' AND a.articleIsHidden = 0 GROUP BY at1.articleID, a.articleHeadline, a.articleLabel HAVING at1.articleID != 1775 ORDER BY COUNT(at1.tagID) DESC, a.articlePublishDT DESC
A warehouse control system that integrates voice-directed picking technology, a high-speed sortation system, and scanning technology streamlined party goods supplier Oriental Trading Company’s picking, packing, and shipping operations.
Companies choosing between voice-directed and pick-to-light technology often find that the right choice is a combination of both.
Slotting is the concept of using data analysis to assign every part a location based on its specific attributes. Determining the best type of storage equipment, stock quantity, and location for each stock keeping unit (SKU) yields more efficient picking operations, writes Christian Rueckerl.
Integrating voice-enabled logistics with hosted ERP solutions and warehouse management systems can improve productivity and accuracy.
Using colors, shapes, numbers, and mnemonics in warehouse signage can help reduce training and picking errors, while improving service.
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 (137)
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 (137)))ORDER BY profileName