Bug with large IN query

Bug with large IN query

php_rocs
Administrator
Posts: 1,393
Threads: 80
Joined: Jun 2016
Reputation: 72

07-25-2018, 08:10 AM

@michaelv,

Suggestion 1: Is your not in list shorter then you in list?
Suggestion 2: Create a subquery of the table with the wanted values and then join it to itself. I'm assuming that there is an easier way to identify the wanted id_prods.

Messages In This Thread

Bug with large IN query - by michaelv - 07-25-2018, 07:08 AM

RE: Bug with large IN query - by php_rocs - 07-25-2018, 08:10 AM

RE: Bug with large IN query - by michaelv - 07-25-2018, 08:43 AM

RE: Bug with large IN query - by dave friend - 07-25-2018, 09:15 AM

RE: Bug with large IN query - by zurtri - 07-25-2018, 04:14 PM

RE: Bug with large IN query - by michaelv - 07-26-2018, 01:18 AM

RE: Bug with large IN query - by php_rocs - 07-26-2018, 08:56 AM