how can i shorten this query
SELECT DISTINCT IF(Isnull(overallstatus), 'Submitted',
IF(overallstatus = "pending", "submitted"
, overallstatus)) AS rem,
IF(Isnull(mapprostatusid), 1, mapprostatusid)
AS ID,
vwproposalret.proposalid,
vwproposalret.probatchno,
Month(validfrom)
AS strMonth,
Year(validfrom)
AS strYear,
Concat(Month(validfrom), "/1/", Year(validfrom))
AS finalDate,
vwproposalret.proposedcoastaldiscount *
vwproposalret.committedvolltrs AS
ActualCoastal,
vwmapsitedetails.arnoc,
vwmapsitedetails.sitename,
vwmapsitedetails.type,
vwmapsitedetails.nhpdealer,
vwmapsitedetails.plant,
vwproposalret.productid,
map_product.rsop_prod,
vwmapsitedetails.cluster,
vwmapsitedetails.zonecode,
vwmapsitedetails.districtcode,
vwmapsitedetails.pa_code,
vwproposalret.soldto,
vwproposalret.shiptocode,
vwproposalret.proposedcoastaldiscount,
vwproposalret.committedvolltrs,
vwproposalret.maxvol,
vwproposalret.fleetcustomer,
vwcustomer.accountid,
vwcustomer.customername
AS accountName,
IF(parentid = proposalid
OR Isnull(parentid)
OR parentid = 0, lastupdate, validfrom)
AS vFrom,
vwproposalret.validto,
vwproposalret.retjustification,
vwproposalret.retsubmissiondate,
tblproposalstatus.overallremarks
AS rtmComment,
tblmapsplit.origproid,
IF(parentid = proposalid
OR Isnull(parentid)
OR parentid = 0, "no", "yes")
AS previouslyApproved,
tblmapsplit.parentid,
tblproposalstatus.overallremarks
FROM (((((vwproposalret
INNER JOIN vwcustomer
ON vwproposalret.customerid = vwcustomer.accountid)
INNER JOIN map_product
ON vwproposalret.productid = map_product.mapprodid)
INNER JOIN vwmapsitedetails
ON ( vwproposalret.productid = vwmapsitedetails.productid )
AND ( vwproposalret.shiptocode =
vwmapsitedetails.shiptocode ))
LEFT JOIN tblproposalstatus
ON vwproposalret.proposalid = tblproposalstatus.proid)
LEFT JOIN map_proposalstatus
ON tblproposalstatus.overallstatus =
map_proposalstatus.proposalstatus)
LEFT JOIN tblmapsplit
ON vwproposalret.proposalid = tblmapsplit.newproid
WHERE ( ( ( IF(Isnull(overallstatus), 'Submitted',
IF(overallstatus = "pending", "submitted"
, overallstatus)) ) = "resubmission" )
AND ( ( vwproposalret.isdeleted ) = 0 )
AND ( ( map_product.isdeleted ) = 0 )
AND ( ( tblmapsplit.category ) <> "renew" ) )
OR ( ( ( IF(Isnull(overallstatus), 'Submitted',
IF(overallstatus = "pending", "submitted"
, overallstatus)) ) = "resubmission" )
AND ( ( vwproposalret.isdeleted ) = 0 )
AND ( ( map_product.isdeleted ) = 0 )
AND ( ( tblmapsplit.category ) IS NULL ) );