Select

SELECT dom,ext FROM domains WHERE record_date < DATE_SUB(CURDATE(),INTERVAL 1 DAY)

SELECT * FROM products WHERE id IN (SELECT id FROM safe_products)

SELECT * INTO OUTFILE '/tmp/prods.txt' FROM products;