I am just guessing that you are operating a retail business with several outlets and are issuing customer cards to identify repeat customers. You appear to be storing visits to each outlet in separate tables, one for each outlet. Your schema is definitely broken and joining 5 tables that should be only 1 table is not going to help.