SELECT  IF(_aList IS NOT NULL, 62,-1) AS _xAttachment,
CASE
WHEN _ELNtype = 'EMail' THEN
  IF(_InOutInd = 'M«' THEN 146 ELSE 105)
WHEN _ELNType = 'Project' THEN 36
WHEN _ELNType = 'Note' THEN 36
WHEN _ELNType = 'Meeting' THEN 148
WHEN _ELNType = 'eShot' THEN 150
WHEN _ELNType = 'Fax' THEN 147
WHEN _ELNType = 'Letter' THEN 61
WHEN _ELNType = 'Mailshot' THEN 149
WHEN _ELNType = 'CC' THEN 152
WHEN _ELNType = 'Bcc' THEN 151 ELSE -1  END AS _xELNType,
(SELECT _Surname+' '+_Forename  FROM Contacts WHERE _ID = _fkContacts) AS _xContact, 
(SELECT _Name FROM Companies WHERE _ID = _fkCompanies) AS _xCompany,
IF(CURRENT_DATE - CAST(_Timestamp AS DATE) <= 30,TRUE,FALSE) AS _xRecent,
CAST(_Comments + ' ' + _Subject AS VARCHAR(210)) AS _xSubject,
CAST(_Timestamp AS VARCHAR(10)) AS _xTimestamp,
*
FROM ELN WHERE _fkContacts = :_fkContacts ORDER BY _TimeStamp DESC