INSERT INTO customers_basket
SELECT 
NULL customers_basket_id,
c.customers_id customers_id,
p.products_id products_id,
1 customers_basket_quantity,
NULL final_price,
CURRENT_DATE customers_basket_date_added
FROM `products` p
LEFT JOIN customers c on 1=1
LEFT JOIN products_to_categories ptc on ptc.products_id = p.products_id
LEFT JOIN categories ca on ca.categories_id = ptc.categories_id
LEFT JOIN categories_description cd on cd.categories_id = ca.categories_id
WHERE p.products_status = 1 and cd.language_id = 2
AND c.customers_email_address ='mustermail@gmail.com'
# wo Produkt vorrätig, Bestand über
AND p.products_quantity > 0
# aus Kategorie
#AND cd.categories_name like '%admin%'
and products_model IN 
(			
	trim(' 1400-02' ),
	trim(' PD-01435'),
	trim(' 10005'   ),
	trim(' 1302'    ),
	trim(' 1705 '   ),
	trim(' 1130 '   ),
	trim(' 1111 '   ),
	trim(' 10041-1' ),
	trim(' 10006'   ),
	trim(' 2021 '   ),
	trim(' 1300'    ),
	trim(' 1802'    ))
group by p.products_id;
  

#Warenkorb Menge pauschal setzen 
UPDATE customers_basket  cb
LEFT JOIN customers c on 1=1
SET customers_basket_quantity = 2
WHERE c.customers_email_address ='mustermail@gmail.com';

#Warenkorb nach Kategorie befüllen
call fill_customers_basket1 ('14147', '3', '3', 'Nerven');

#weiterentwicklung zu Kategorieauswahl
products_to_basket1.php