Today I discovered and firstly used MySQL aggregate function GROUP_CONCAT and it’s really usefull in same cases. Consider structure database like this: ┌───────────────────────────────┐ ┌───────────────────────┐ │ eshop_items │ │ eshop_items_to_genres │ ├───────────────────────────────┤ ├───────────────────────┤ │ * ID [INTEGER] |—-| item_ID [INTEGER] │ │ title [VARCHAR] │ │ genre_ID [INTEGER] |—-┐ │ image [VARCHAR] │ └───────────────────────┘ | │ [...]