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=148 AND aclink.DocumentID=a.DocumentID AND a.TemplateID=4
AND (a.Language='Japanese' OR a.Language='') AND a.WorkflowStageType="Publish" AND a.PublicationDate <= NOW() AND a.ExpiryDate > NOW()
panpacific.comに戻る
