Bestellungen mit Produkten

SELECT sys_products_orders.uid as order_uid,sys_products_orders.name,sys_products_orders.tracking_code, sys_products_orders.crdate as order_date,pa.sys_products_orders_qty AS quantity,product1.uid AS product_uid
FROM sys_products_orders sys_products_orders LEFT OUTER JOIN sys_products_orders_mm_tt_products pa ON sys_products_orders.uid = pa.sys_products_orders_uid INNER JOIN tt_products product1 ON pa.tt_products_uid = product1.uid
WHERE
sys_products_orders.pay_mode > 0 AND product1.uid = 15 AND sys_products_orders.deleted=0 AND sys_products_orders.hidden=0