Index: /mods/wpsg_mod_statistics.class.php
===================================================================
--- /mods/wpsg_mod_statistics.class.php	(revision 6033)
+++ /mods/wpsg_mod_statistics.class.php	(revision 6035)
@@ -835,17 +835,34 @@
 		private function getOrderData()
 		{
-			$sql = "SELECT `".WPSG_TBL_ORDER."`.`id`, `".WPSG_TBL_KU."`.`id` AS `kid`, `".WPSG_TBL_KU."`.`email`, `".WPSG_TBL_ADRESS."`.`name`, `".WPSG_TBL_ADRESS."`.`vname`, `".WPSG_TBL_ADRESS."`.`tel`, `".WPSG_TBL_ORDER."`.`cdate`, `".WPSG_TBL_ORDERPRODUCT."`.`menge` FROM `".WPSG_TBL_ORDER."` AS `".WPSG_TBL_ORDER."`, `".WPSG_TBL_ORDERPRODUCT."` AS `".WPSG_TBL_ORDERPRODUCT."`, `".WPSG_TBL_KU."` AS `".WPSG_TBL_KU."`, `".WPSG_TBL_ADRESS."` AS `".WPSG_TBL_ADRESS."` ";
-			$sql .= " WHERE (`".WPSG_TBL_ORDER."`.`id` = `".WPSG_TBL_ORDERPRODUCT."`.`o_id`) AND (`".WPSG_TBL_ORDER."`.`k_id` = `".WPSG_TBL_KU."`.`id`) AND (`".WPSG_TBL_ADRESS."`.`id` = `".WPSG_TBL_ORDER."`.`adress_id`)";
-			//$sql .= " AND (`wp_wpsg_order`.`cdate` > {d '2017-01-01' }) AND (`wp_wpsg_order`.`cdate` < {d '2017-01-31' })";
-				
+			//$sql = "SELECT `".WPSG_TBL_ORDER."`.`id`, `".WPSG_TBL_KU."`.`id` AS `kid`, `".WPSG_TBL_KU."`.`email`, `".WPSG_TBL_ADRESS."`.`name`, `".WPSG_TBL_ADRESS."`.`vname`, `".WPSG_TBL_ADRESS."`.`tel`, `".WPSG_TBL_ORDER."`.`cdate`, `".WPSG_TBL_ORDERPRODUCT."`.`menge` FROM `".WPSG_TBL_ORDER."` AS `".WPSG_TBL_ORDER."`, `".WPSG_TBL_ORDERPRODUCT."` AS `".WPSG_TBL_ORDERPRODUCT."`, `".WPSG_TBL_KU."` AS `".WPSG_TBL_KU."`, `".WPSG_TBL_ADRESS."` AS `".WPSG_TBL_ADRESS."` ";
+			//$sql .= " WHERE (`".WPSG_TBL_ORDER."`.`id` = `".WPSG_TBL_ORDERPRODUCT."`.`o_id`) AND (`".WPSG_TBL_ORDER."`.`k_id` = `".WPSG_TBL_KU."`.`id`) AND (`".WPSG_TBL_ADRESS."`.`id` = `".WPSG_TBL_ORDER."`.`adress_id`)";
+	
+			//$sql = 'SELECT `wp_wpsg_order`.`id`, `wp_wpsg_order_products`.`menge`, `wp_wpsg_adress`.`name`, `wp_wpsg_adress`.`vname`, `wp_wpsg_order_products`.`p_id`, `wp_wpsg_adress`.`tel`, `wp_wpsg_kunden`.`email`, `wp_wpsg_kunden`.`id` AS `kid` FROM { `wp2`.`wp_wpsg_order` AS `wp_wpsg_order` RIGHT OUTER JOIN `wp2`.`wp_wpsg_order_products` AS `wp_wpsg_order_products` ON `wp_wpsg_order`.`id` = `wp_wpsg_order_products`.`o_id` LEFT OUTER JOIN `wp2`.`wp_wpsg_kunden` AS `wp_wpsg_kunden` ON `wp_wpsg_order`.`k_id` = `wp_wpsg_kunden`.`id` LEFT OUTER JOIN `wp2`.`wp_wpsg_adress` AS `wp_wpsg_adress` ON `wp_wpsg_order`.`adress_id` = `wp_wpsg_adress`.`id` }';
+			
+			$sql = "SELECT
+			      OP.`menge`,
+			      O.`onr`,
+				  O.`id`,
+				  C.`id` AS kid,	
+			      C.`knr`,
+				  C.`email`,
+				  OA.`tel`,	
+			      IF (OA.`id` > 0, OA.`name`, C.`name`) AS `name`,
+			      IF (OA.`id` > 0, OA.`vname`, C.`vname`) AS `vname`
+  			      FROM
+				      `".WPSG_TBL_ORDERPRODUCT."` AS OP
+				         LEFT JOIN `".WPSG_TBL_ORDER."` AS O ON (OP.`o_id` = O.`id`)
+				         LEFT JOIN `".WPSG_TBL_KU."` AS C ON (O.`k_id` = C.`id`)
+				         LEFT JOIN `".WPSG_TBL_ADRESS."` AS OA ON (O.`adress_id` = OA.`id`)";
+			
 			$pid = $_REQUEST['edit_id'];
-			$sql .= " AND (`".WPSG_TBL_ORDERPRODUCT."`.`p_id`='".$pid."')";
-			
-			$sql .= " AND (`".WPSG_TBL_ORDER."`.`status` IN (".$this->observeStatuscodes."))";
+			$sql .= " WHERE (`OP`.`p_id`='".$pid."')";
+			
+			$sql .= " AND (`O`.`status` IN (".$this->observeStatuscodes."))";
 			
 			if (isset($_REQUEST['von']))
 			{
 				$von = wpsg_toDate( $_REQUEST['von']);
-				$sql .= " AND (`".WPSG_TBL_ORDER."`.`cdate` > '".$von."')";
+				$sql .= " AND (`O`.`cdate` > '".$von."')";
 			}
 			
@@ -853,5 +870,5 @@
 			{
 				$bis = wpsg_toDate( $_REQUEST['bis']);
-				$sql .= " AND (`".WPSG_TBL_ORDER."`.`cdate` < '".$bis."')";
+				$sql .= " AND (`O`.`cdate` < '".$bis."')";
 			}
 				
Index: /views/mods/mod_statistics/produkt_edit_sidebar.phtml
===================================================================
--- /views/mods/mod_statistics/produkt_edit_sidebar.phtml	(revision 6033)
+++ /views/mods/mod_statistics/produkt_edit_sidebar.phtml	(revision 6035)
@@ -63,5 +63,5 @@
 		        foreach ($this->view['odata'] as $pa) { ?>          
 		        <tr>
-					<td> <a href="<?php echo WPSG_URL_WP; ?>wp-admin/admin.php?page=wpsg-Order&action=view&edit_id=<?php echo __($pa['id'], 'wpsg');?>" target="_blank"><?php echo __($pa['id'], 'wpsg');?></a></td>
+					<td> <a href="<?php echo WPSG_URL_WP; ?>wp-admin/admin.php?page=wpsg-Order&action=view&edit_id=<?php echo __($pa['id'], 'wpsg');?>" target="_blank"><?php echo __($pa['onr'], 'wpsg');?></a></td>
 					<td> <a href="<?php echo WPSG_URL_WP; ?>wp-admin/admin.php?page=wpsg-Customer&action=edit&edit_id=<?php echo __($pa['kid'], 'wpsg');?>" target="_blank"><?php echo __($pa['name'], 'wpsg');?></a></td>
 		            <td> <?php echo __($pa['vname'], 'wpsg');?></td>
Index: /views/mods/mod_statistics/statisticProduct.phtml
===================================================================
--- /views/mods/mod_statistics/statisticProduct.phtml	(revision 6033)
+++ /views/mods/mod_statistics/statisticProduct.phtml	(revision 6035)
@@ -32,5 +32,5 @@
         foreach ($this->view['odata'] as $pa) { ?>          
         <tr>
-			<td> <a href="<?php echo WPSG_URL_WP; ?>wp-admin/admin.php?page=wpsg-Order&action=view&edit_id=<?php echo __($pa['id'], 'wpsg');?>" target="_blank"><?php echo __($pa['id'], 'wpsg');?></a></td>
+			<td> <a href="<?php echo WPSG_URL_WP; ?>wp-admin/admin.php?page=wpsg-Order&action=view&edit_id=<?php echo __($pa['id'], 'wpsg');?>" target="_blank"><?php echo __($pa['onr'], 'wpsg');?></a></td>
 			<td> <a href="<?php echo WPSG_URL_WP; ?>wp-admin/admin.php?page=wpsg-Customer&action=edit&edit_id=<?php echo __($pa['kid'], 'wpsg');?>" target="_blank"><?php echo __($pa['name'], 'wpsg');?></a></td>
             <td> <?php echo __($pa['vname'], 'wpsg');?></td>