I am having a little trouble with this query. I want to filter my Features down for all features that have applicabilities that have include the name ‘G6’, but that also do not have a many to many relationship with applicabilies that have the name ‘n2’. I have right now: I have a many …
Tag: many-to-many
Making sense of database table references with foreign and primary keys
I am relatively new to database logic, and am trying to figure out how multiple tables should/shouldn’t reference each other. I have a table, ‘Book’, that should have columns: I want each book to have the possibility to have 1 or more genres. I want each book to have the possibility to have …
MySQL conditional querying many to many relations (inner joined tables) from an array
I’ve a colors table and an items table, with a many to many relation between these 2 tables (via an items_colors table). An item can have many colors and a color can have many items. From an array of colors, I would like to get all items that only match one or more provided colors. If an item is also
Get all Many:Many relationships from reference/join-table
I am having difficulty querying for possible relationships in a Many:Many scenario. I present my schema: What I do know how to query with this schema is: All Bands that a given User belongs to. All …
Many-to-many sql select query containing multiple values, all values are taken into account
There is the following database structure: How do I write a query that returns only those Questions that have both CSS and JS tags?
Finding voters that did not vote in an election through a many to many relationship with MySQL
I have two tables linked through a many-to-any relationship. Table one contains all voters with an ID, table two contains all elections with an ID, and table three links both tables using their IDs. …
Django many-to-many: Best way to get elements in one related query set but exclude elements in other related query sets?
Consider these related models: In a view, I need to query to get all Bs related to a given A while excluding all Bs related with a set of other As. I need the grey area: My current, grossly inefficient approach is as follows: In my application, previous_As could have nearly 1,000 elements, which makes this ap…
Pairing table query
I was wondering how I construct a query to get all articles with all their information, and for every article a list with their tags. I used a pairing table called ArticleTags to connect Article and Tags. Can anyone tell me what the query would be if I wanted to receive all articles along with their tags per …
GROUP_CONCAT to return an object array in a many to many relationship
I am working on a mySQL query for a personal project. Right now the end goal is to have the query return the following json for each item: My most recent attempt is: Which is giving me an internal server error. Testing it with a simplier query goes through fine so I’ve narrowed it down to the query itse…
Mysql many to many relations. Filter exact match
Hello. I want to select dishes which has the only the exactly selected ingredient alias? For example: Ingredient alias table: +—-+———-+ | id | Name | +—-+———-+ | 22 | potato | | …