I have a BIG problem. I had to move a fully functional admin from a windows server to a unix server. I don't know if that's even the problem, or just the fact, that the MYSQL version is different. Anyway, in the Admin (php) the programmer used a lof of queries with IN().
i.e. : $sql = "SELECT image FROM product_images WHERE image LIKE('".$sku."%') AND product_id IN (SELECT id FROM products WHERE season_id = ".$season_id.");";
That doesn't work at all on the new server. Is there a workaround, maybe a join or something else I can replace that with? Its hard to find anything on google with a search term like " mysql_query + IN( +problem ".
Anyway, any help is appreciated!