--disable_query_log
let $1=1000000;
#let $1=1;
while ($1)
{
  let $k = `select concat('CD', cast(round(10000*rand()) as char))`;
#  let $k = `select ISIN from ISIN order by rand() limit 1`;
  --error 0,1297
  eval SELECT r.`name` as name, r.`classname` as classname FROM `products`, `product_registry` r WHERE r.`producttype`= products.`producttype` AND products.hide_retail = 1 AND products.`ISIN` = '$k';
  dec $1;
}
--enable_query_log