SELECT * FROM twistProjectRETranResSale AS ptrs JOIN twistProject AS proj ON ptrs.projectRETranResSaleID = proj.projectID

ACTIVE

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectCompletedDate = "0000-00-00" AND proj.projectCancelledDate = "0000-00-00"

ASSIGNMENT PENDING

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectAssignedDate !='0000-00-00' AND (proj.projectAcceptedDate='0000-00-00' OR proj.projectAcceptedDate < proj.projectAssignedDate)  

CANCELLED

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectCancelledDate != "0000-00-00"

COMPLETED

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectCompletedDate != "0000-00-00"

DELETED

	proj.deletedDateTime != "0000-00-00 00:00:00"

FOLLOW-UP BLANK

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectFollowUpDate = "0000-00-00" AND proj.projectCompletedDate = "0000-00-00" AND proj.projectCancelledDate = "0000-00-00"

FOLLOW-UP FUTURE

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectFollowUpDate != "0000-00-00" AND proj.projectFollowUpDate > curdate()

FOLLOW-UP LATE

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectFollowUpDate != "0000-00-00" AND proj.projectFollowUpDate < curdate()

FOLLOW-UP TODAY

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectFollowUpDate != "0000-00-00" AND proj.projectFollowUpDate = curdate()

HOLD

	proj.deletedDateTime = "0000-00-00 00:00:00" AND proj.projectHoldDate != "0000-00-00" AND proj.projectCompletedDate = "0000-00-00" AND proj.projectCancelledDate = "0000-00-00"