SELECT p.id, p.category_id, p.price FROM products AS p
LEFT JOIN product_descriptions AS pd
ON p.id = pd.product_id
WHERE pd.product_id IS NULL