Bug with large IN query

@michaelv,

You could easily test that yourself.  All you have to do is test both queries in MySQL Workbench.  

Also, to give your query more flexibility try the query binding approach ( https://codeigniter.com/user_guide/datab...y-bindings ).

PHP Code:

$prod_list = array(12666,29593,20398,17415,..... over 1000 ids);
$qry = "SELECT blabla ... FROM xxx x WHERE x.afficher = 1 AND id_prod IN ? GROUP BY x.id_prod ORDER BY RAND() LIMIT ? ";
$this->db->query($qry,array($product_list,24));