SELECT a.articleHeadline, a.articleLabel, at1.articleID, COUNT(at1.tagID) AS tag_count FROM articles AS a INNER JOIN articleTags AS at1 ON at1.articleID = a.articleID WHERE at1.tagID IN (55) AND a.articlePublishDT < '2013-12-05 21:16:28' AND a.articleIsHidden = 0 GROUP BY at1.articleID, a.articleHeadline, a.articleLabel ORDER BY COUNT(at1.tagID) DESC, a.articlePublishDT DESC
The Panama Canal expansion, to be completed in 2015, will impact global commerce and affect trade patterns to the U.S. East Coast. Ports such as PortMiami are preparing themselves to accept the new class of mega cargo ships, says Bill Johnson of PortMiami.
As Panama Canal expansion nears completion, global shippers gain a viable alternative for shipping ocean cargo from Asia to U.S. East Coast and Gulf Coast ports.
Looking out to 2015, anticipation is swirling about the Panama Canal's expansion and impact on U.S. trade. Among southeastern ports and shippers, that wave of anticipation has already made landfall.
The upcoming Panama Canal expansion will have a substantial impact on the U.S. supply chain and its efficiencies, writes Gary Forger, Material Handling Industry of America.
News briefs: U.S. Ports Dig Panama Gold, Reducing the Carton Footprint, SaaS to the Rescue, BNSF Brings Shortlines On Line, Truckers Tackle Credit Crunch
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 (55)
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 (55)))ORDER BY profileName