I am trying to make a many-to-many selection by linking the product table with the table of related variants, tags, and images. But despite me using LEFT JOINs, the query keeps returning only the first row of results (with id 1).
Here is my query:
query
I tried to fetch my data from the different tables on one row (and thats worked well), but it only fetch the first row of products. I didn’t specify any kind of WHERE conditions on my query so i don’t really know where is the problem.
New contributor
Roberto Spini is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3