| Describe: |
SELECT
tal_Index
, ct_Name
, tal_Source
, tal_Type
, tal_Type1
, tal_Priority
, tal_Status
, tal_Title
, tal_Todo
, tal_Description
, tal_DateCre
, tal_DateMod
, tal_DateDel
, tal_DateTask
, tal_DateAlarm
, tal_DateFin
, tal_DateBeg
, tal_DateEnd
, tal_Recurring
, av_Index
, tal_Email
, tal_EmailList
, tal_Address
, tal_Phone
, tal_Free
, tal_Cell
, tal_Fax
, tal1_Todo
, tal1_Interview
, tal1_Prospect
, tal1_Client
, tal1_Billing
, tal1_Followup
, tal1_Urgent
, tal1_CliOld
, tal1_Event
, tal1_Advert, tal_Lists, tal_List1, tal_Contact_List ,
User.u_Key as u_Key,
User.t_Key as t_Key,
Contact.ct_Key as ct_Key,
Contact.ct_Title as ct_Title,
Contact.ct_First_Name,
Contact.ct_Last_Name,
Company.c_Key as c_Key,
Company.c_Name as c_Name
FROM Task
join User on User.u_Key = Task.u_Key
left join Contact on Contact.ct_Key = Task.ct_Key
left join Company on Company.c_Key = Task.c_Key
where tal_Status = 'Active' and tal_DateDel = '0000-00-00' and User.t_Key = '1000000241131'
order by tal_DateMod desc
limit 0, 30 |