Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
select id, status, datedone
join statuses on items.status_id = statuses.status_id
where closed = 0
and ((items.status_id = 14 and items.datedone is not null) or items.status_id <> 14)
Open in new window
SELECT id, status, datedone
FROM items i
INNER JOIN statuses s ON i.status_id=s.status_id
AND NOT (i.status_id=14 AND i.datedone IS NOT NULL)
As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.