JayKayBe

Same problem here. My site also is in developement, but unfortunately I have to get my permalinks to the be /%postname% as I have 25.000+ old links in this format that have to be reachable on the new site.
If anybody finds a solution to this please share, I will do the same!

Thank you for your answers Michelle! After looking into it I more and more realized this may be a little over the top for me to solve and after a brief search I found another solution, where I have the likes/dislikes stored as post_meta and it works like a charm now!
Best,
Jay

Hi Michelle,
thank you for your response. I’m not quite sure what you mean by not using normal WordPress custom_fields / post_meta.
The posts themselves are completely normal WordPress posts stored in the wp_posts table. It is just the likes which are stored in the custom table described below.
The solution to my problem would probably be to do a query on the custom table to select every ID with 20+ likes and then query the wp_posts table to select just the posts with the IDs from the other query. However I am kind of scared to do so because I am not very sophisticated with MySQL queries and both of them would query for about 30.000 posts. Can this impact server performance?
Again if I misunderstood your question for more information please accept my apologies.
Best,
Jay

Resolved:
I just used an image tag with the url to the old content folder in the content part of the wp_posts table. Works like a charm and only uses one ID per post!