For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
See Announcement
We are still working on the Joomla update.
SELECT DISTINCT(CONCAT(us_states.name, ' (', us_states.abbr, ')')) AS `text`, `fab_main_test`.`state` AS `value` FROM `fab_main_test` LEFT JOIN `us_states` AS `us_states` ON `us_states`.`abbr` = `fab_main_test`.`state` LEFT JOIN `us_cities` AS `us_cities` ON `us_cities`.`id` = `fab_main_test`.`city` LEFT JOIN `us_states` AS `us_states_0` ON `us_states_0`.`abbr` = `fab_main_test`.`other_state` LEFT JOIN `fab_junk` AS `fab_junk` ON `fab_junk`.`id` = `fab_main_test`.`junk_join` WHERE `fab_main_test`.`state` IN ('AL','NM','AK','ME','CA','GA','AR') ORDER BY `us_states`.`abbr`ASC