DELETE
FROM keywords
WHERE
(keyword_id IN SELECT id FROM SELECT k.keyword id FROM keywords k WHERE (k.keyword_type = 'CAMPAIGN' AND k.keyword != 'Airtel' AND k.keyword != 'Nokia' AND k.keyword != 'Micromax' AND NOT k.keyword IN SELECT DISTINCT keyword_id FROM customer_analysis ) ORDER BY k.keyword_id a )
vakorol
commented
10 years ago
DELETE FROM keywords WHERE (keyword_id IN SELECT id FROM SELECT k.keyword id FROM keywords k WHERE (k.keyword_type = 'CAMPAIGN' AND k.keyword != 'Airtel' AND k.keyword != 'Nokia' AND k.keyword != 'Micromax' AND NOT k.keyword IN SELECT DISTINCT keyword_id FROM customer_analysis ) ORDER BY k.keyword_id a )