Useful database queries

In Opencart 3 find all products without a seo url value

SELECT * FROM oc_product WHERE NOT EXISTS(SELECT 1 FROM oc_seo_url WHERE query LIKE CONCAT('product_id=', product_id))