SELECT campaign.CampaignID, RateTypeID, ClickRate, tbl_business_budget.CurrentBudget, running.balance,PageRateID,StatusID FROM tblad_campaign as campaign LEFT JOIN tblbusiness ON campaign.businessid=tblbusiness.businessid LEFT JOIN tbl_business_budget ON campaign.BusinessID = tbl_business_budget.BusinessID LEFT JOIN tblad_campaign_budget AS budget ON campaign.CampaignID = budget.CampaignID LEFT JOIN tblad_running_budget AS running On campaign.CampaignID = running.CampaignID WHERE (PageID = 103 OR PageID = 0) AND tblbusiness.SiteID = SITE_ID AND (StatusID=1 OR StatusID= 5) AND (tbl_business_budget.currentbudget >= 0 OR tbl_business_budget.currentbudget is null) ORDER BY ClickRate