Категории: Array ( [0] => Array ( [id] => 1 [name] => Комнатные растения [image] => uploads/categories/67a87d20769e8.webp [sort_order] => 0 [created_at] => 2025-02-09 06:26:49 [description] => ) [1] => Array ( [id] => 2 [name] => Композиции [image] => uploads/categories/67a87c5e8f0f3.jpg [sort_order] => 0 [created_at] => 2025-02-09 06:26:49 [description] => ) [2] => Array ( [id] => 3 [name] => Моно букеты [image] => uploads/categories/67a872f173774.webp [sort_order] => 0 [created_at] => 2025-02-09 06:26:49 [description] => ) [3] => Array ( [id] => 4 [name] => Мягкие игрушки [image] => uploads/categories/67a87cf2523af.jpg [sort_order] => 0 [created_at] => 2025-02-09 06:26:49 [description] => ) [4] => Array ( [id] => 5 [name] => Розы [image] => uploads/categories/67a87ce9742f6.webp [sort_order] => 0 [created_at] => 2025-02-09 06:26:49 [description] => ) [5] => Array ( [id] => 6 [name] => Составные букеты [image] => uploads/categories/67a87cfeda46f.webp [sort_order] => 0 [created_at] => 2025-02-09 06:26:49 [description] => ) [6] => Array ( [id] => 7 [name] => Цветы [image] => uploads/categories/67a87d0cdd016.webp [sort_order] => 0 [created_at] => 2025-02-09 06:26:49 [description] => ) [7] => Array ( [id] => 8 [name] => Шары [image] => uploads/categories/67a87d1715a2a.jpg [sort_order] => 0 [created_at] => 2025-02-09 06:26:49 [description] => ) )

SQL запрос: SELECT pb.id as base_id, pb.name, pb.description, COALESCE(GROUP_CONCAT(DISTINCT pi.image_url SEPARATOR '|||'), '') as images, COALESCE(GROUP_CONCAT(DISTINCT CONCAT( pv.article, ':::', pv.price, ':::', pv.quantity, ':::', pv.active, ':::', COALESCE(pv.name, '') ) SEPARATOR '|||' ), '') as variations FROM product_bases pb LEFT JOIN product_variations pv ON pb.id = pv.base_id LEFT JOIN product_images pi ON pb.id = pi.base_id WHERE pv.active = 1 GROUP BY pb.id ORDER BY pb.created_at DESC LIMIT 8

Товары: Array ( [0] => Array ( [base_id] => 11368 [name] => Шпагат джутовый 200м [description] => [images] => [variations] => 3948f63c-d1a7-11ee-9399-bc5ff4658908:::0.00:::9:::1:::Шпагат джутовый 200м ) [1] => Array ( [base_id] => 11376 [name] => Пистолет клеевой [description] => [images] => [variations] => 634fc588-d1ab-11ee-9399-bc5ff4658908:::0.00:::1:::1:::Пистолет клеевой ) [2] => Array ( [base_id] => 11374 [name] => Бумага тишью [description] => [images] => [variations] => c3cd214a-d1aa-11ee-9399-bc5ff4658908:::0.00:::187:::1:::Бумага тишью ) [3] => Array ( [base_id] => 11373 [name] => Пленка Корея OMG ассорти [description] => [images] => [variations] => af52c0dc-d1a8-11ee-9399-bc5ff4658908:::0.00:::294:::1:::Пленка Корея OMG ассорти ) [4] => Array ( [base_id] => 11372 [name] => Лента Польша ассорти [description] => [images] => [variations] => 54f9dcce-d1a8-11ee-9399-bc5ff4658908:::0.00:::157:::1:::Лента Польша ассорти ) [5] => Array ( [base_id] => 11371 [name] => Кашпо трапеция картон цветоное [description] => [images] => [variations] => 3ce10824-d1a8-11ee-9399-bc5ff4658908:::80.00:::12:::1:::Размер 15*12*9 см ) [6] => Array ( [base_id] => 11370 [name] => Тонировка матовая ассорти [description] => [images] => [variations] => ab011e6c-d1a7-11ee-9399-bc5ff4658908:::0.00:::341:::1:::Тонировка матовая ассорти ) [7] => Array ( [base_id] => 11359 [name] => Пленка 60 чистая 800 гр [description] => [images] => [variations] => d8cb1100-d1a6-11ee-9399-bc5ff4658908:::0.00:::104:::1:::Пленка 60 чистая 800 гр ) )