How can I make this SQL query more efficient? PHP.
- by Alan Grant
Hi all,
I have a system whereby a user can view categories that they've subscribed to individually, and also those that are available in the region they belong in by default.
So, the tables are as follows:
Categories
UsersCategories
RegionsCategories
I'm querying the db for all the categories within their region, and also all the individual…