Yes, I checked the database - before I posted the reply above. Everything looks like it's supposed to look from what I can tell. Unless there is another table somewhere that I don't know about that doesn't say Fabrik. I looked at the tables I created and all of the Fabrik tables, even the ones not related to fields - ALL of them. I may have missed something, because this doesn't make any sense, but I'm beyond frustrated.
So, instead of moving the Fabrik lists, forms, groups, elements, etc, I took the production site (where Fabrik was working great for months and suddenly completely quit working and now no longer even allow me to see the data from the administrator/backend and no one can get to any forms or lists on the front end. I have another thread where I have posted about all the related issues) and cloned it to another dev site. I installed gantry and a template from rocketthem and uninstalled the T3framework and JoomlaArt templates. Now I'm getting the same 500 Fabrik has generated an incorrect query for the list IITB - Client. (Not the same error I was getting when using the JoomlArt template). I'm now working on that to see why that same error is occurring in the new test site where I cloned all of production instead of just trying to move all the Fabrik stuff.
As I said several times in the other thread, the really confusing/frustring thing is all was working well for months and the only thing I changed was to update versions of extensions along the way. And suddenly all the Fabrik stuff became completely hosed. So I did an update from github and now in the production site and now NO ONE, includng me, can get to the lists, forms, or data in the front end or back end - I can only see it in the database. This happened with new problem cropping up each day over the course of about 5 days with NO CHANGES at all during that time. Makes no sense.
Update: I don't think the 500 error is related to the JoomlaArt template.