SELECT a.Title, a.URI, IF (a.AdditionalField14 IS NOT NULL AND a.AdditionalField14!='' AND a.AdditionalField14!='undefined', a.AdditionalField14, "/media/images/Website/Images/logo_panpac.gif") AS brandLogo FROM articles a, artcatlink aclink WHERE aclink.CategoryID=1269 AND aclink.DocumentID=a.DocumentID AND a.TemplateID=4 AND (a.Language='English' OR a.Language='') AND a.WorkflowStageType="Publish" AND a.PublicationDate <= NOW() AND a.ExpiryDate > NOW() Contact Us Back to panpacific.com