Deutsch
English
English
Nederlands
Nederlands
Magyar
Magyar
Русский
Русский
Shop System tt_products Shop System

Home

über tt_products
Tutorials
tt_products Forum
tt_products Sponsors

SQL Abfragen

tt_products Demo Shop

tt_products Shop

Warenkorb

Impressum

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

   ^ top

PDF erstellen, hier klicken

zum Drucken hier klicken

Benutzeranmeldung

Geben Sie Ihren Benutzernamen und Ihr Passwort ein, um sich an der Website anzumelden:
Anmelden

Kennwort vergessen?

Der Warenkorb ist leer

  Copyright 2015 - POB EDV-Systeme