SELECT
tblhosting.userid,
tblhosting.packageid,
tblhosting.regdate,
tblhosting.termination_date,
tblhosting.dedicatedip,
tblhosting.assignedips,
tblclients.firstname,
tblclients.lastname,
tblclients.email,
tblclients.phonenumber,
tblproducts.name
FROM tblhosting
LEFT JOIN tblclients ON tblclients.id=tblhosting.userid
LEFT JOIN tblproducts ON tblproducts.id=tblhosting.packageid
WHERE tblhosting.domainstatus = 'Terminated'
AND tblhosting.packageid IN ('1' , '2' , '3');