How to add condition to SQL query?

Question

SQL

Query displays new videos

SELECT A.*,B.UID,B.username 
FROM video A, signup B 
WHERE A.UID=B.UID AND A.active ='1' AND A.channel IN ('9') 
ORDER BY A.VID desc LIMIT 10

there is a condition that displays the restored videos

restored='yes' AND active_date = CURDATE()

how to combine them in one request so that both new and restored videos are displayed?

Answer 1

FROM video A
LEFT/INNER JOIN signup B
WHERE A.UID=B.UID
AND (A.active ='1' OR restored='yes') AND A.channel
IN ('9')