Why does my phone screen turn on?

Question

MySQL

This is not the first phone to have this problem. All my phones had this kind of nonsense. Smart just lies on the table and the screen turns on periodically. Which naturally drains the battery. How can this be fixed? Ruth is not. Doogee mix phone. Before that there were lenovo and samsung.

Answer 1

SELECT `id`
  FROM `products`
  WHERE `id` NOT IN (
    SELECT `product_id`
      FROM `products_category`
  )

Answer 2

select t1.id
from products as t1
left join products_category as t2 on t1.id = t2.product_id
where t2.product_id is null