Are you importing data from one table to another, from one big complex strange query select statement to make something else work try this simple way:
“INSERT INTO zip_codes(code,city_id) SELECT t.zip_code,(select c.id from cities c where c.state_id=s.id and c.name=t.city) as ‘vikiyagroup’ from temporal t inner join states s on t.state=s.name order by t.city”;
And yes it worked with thousands of records!
Happy coding!