MySQL error: 1213 - Deadlock found when trying to get lock; try restarting transaction

INSERT INTO specials_retail_prices SELECT DISTINCT s.products_id, s.specials_new_products_price, s.status, s.customers_group_id FROM specials s WHERE s.customers_group_id = '0' and s.status = 1 AND NOT EXISTS(SELECT products_id FROM specials_retail_prices WHERE specials_retail_prices.products_id = s.products_id)
[TEP STOP]

IP Address:18.97.9.168