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 │
├───────────────────────────────┤ [...]