CREATE TEMPORARY TABLE temp_nyheter REPLACE SELECT id FROM nyheter LIMIT 8,0 SELECT * FROM nyheter WHERE produkt = 'ja' AND id NOT IN (SELECT id FROM temp_nyheter)