let $1 = 1000; --disable_query_log while ($1) { SELECT link.id AS link_id,link.advertentie_id,link.campagne_id, '0' AS netwerk_id,type,src,content_type FROM link INNER JOIN advertentie ON advertentie.id = link.advertentie_id INNER JOIN campagne ON campagne.id = advertentie.campagne_id AND campagne.status = 'default_campagne' AND campagne.id = 1 WHERE link.bannermaat_id = 1 LIMIT 1; dec $i; } --enable_query_log